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

7 votes412 views3 answers
Sql server check if temp table exists
SQL
36 votes367 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote341 views1 answer
Scaffold mysql database
SQL
0 vote296 views1 answer
Sql table to store status
SQL
1 vote352 views1 answer
Alter constraint postgres
SQL
14 votes374 views1 answer
Oracle new column
SQL
3 votes349 views2 answers
Mysql select database
SQL
-1 vote344 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote367 views1 answer
Mariadb search columns
SQL
2 votes356 views1 answer
Get first n letter of department name in sql
SQL