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

1 vote106 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
16 votes112 views3 answers
Update table from another table
SQL
0 vote109 views3 answers
Postgres date difference seconds
SQL
11 votes151 views3 answers
Pl sql example
SQL
0 vote137 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote95 views2 answers
Sql count number of rows after group by
SQL
4 votes113 views2 answers
What is table in sql
SQL
-1 vote109 views1 answer
Concat two columns in sql server
SQL
10 votes101 views2 answers
Oracle alter sequence nextval
SQL
2 votes97 views2 answers
Select multiple tables mysql
SQL