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 vote321 views1 answer
Sqlite closes value
SQL
0 vote327 views1 answer
Sauvegarde complète my sql
SQL
0 vote350 views1 answer
Shrink database file in sql server
SQL
0 vote320 views1 answer
How to get table current identity value in sql server
SQL
2 votes278 views1 answer
Sql view column data type
SQL
2 votes332 views1 answer
How to insert string variable into sqlite database
SQL
0 vote308 views1 answer
Parsing float to int in mysql
SQL
5 votes322 views1 answer
Mysql change primary key
SQL
0 vote317 views1 answer
How to to get current date and time in sql
SQL
2 votes332 views1 answer
Sqlite insert if not exists
SQL