Sql query checker

CREATE TABLE employee

   ( employee_id VARCHAR(20),

    Name VARCHAR (20),

    Address VARCHAR (20),

    Mobile_no  SMALLINT);

Online sql testing tool

select * from sql_test_a

Source: sqltest.net

Sql check

Adds a constraint that limits the value which can be added to a column.
Example 1 (MySQL): Makes sure any users added to the users table are 18
or over.
CREATE TABLE users (
first_name varchar(255),
age int,
CHECK (age>=18)
);
Example 2 (MySQL): Adds a check after the table has already been
created.
ALTER TABLE users
ADD CHECK (age>=18);

-1

Similar codes

0 vote142 views1 answer
Mysql check if lowercase
SQL
0 vote175 views1 answer
Postgres execute multiple sql file from command line
SQL
2 votes131 views1 answer
Cast string to datetime mysql
SQL
4 votes127 views1 answer
Mysql ip address
SQL
0 vote139 views1 answer
Hibernate with springboot mysql
SQL
0 vote219 views1 answer
Python mysql check if database exists
SQL
0 vote131 views1 answer
Get only one row in mysql
SQL
6 votes120 views4 answers
Mysql update set
SQL
2 votes130 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
2 votes177 views1 answer
Sql compare strings
SQL