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

2 votes98 views1 answer
Sql update alias
SQL
0 vote110 views1 answer
Run sql script file and changes db name in this file using c#
SQL
3 votes108 views1 answer
Sql replace character in string in all records
SQL
0 vote107 views1 answer
Run postgresql dump to csv
SQL
0 vote138 views2 answers
Insert data into multiple tables mysql
SQL
3 votes113 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote121 views2 answers
Drop tables from local table database postgres
SQL
0 vote150 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote108 views2 answers
Find a column in all tables mysql
SQL
0 vote100 views2 answers
How to set global time_zone in mysql
SQL