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

13 votes103 views3 answers
Uninstall mysql centos 7
SQL
0 vote153 views1 answer
Import sql dump into postgresql database
SQL
0 vote145 views1 answer
Postgres list all stored procedures query
SQL
1 vote107 views2 answers
Sql select only row with the max date
SQL
-2 votes155 views1 answer
Trunc in sql
SQL
1 vote109 views1 answer
Create email address from first and last name in sql
SQL
4 votes107 views1 answer
Change nls_date_format
SQL
0 vote103 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote54 views1 answer
Ms sql unique
SQL
0 vote97 views1 answer
Jooq replace
SQL