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 vote192 views1 answer
How to count null values in sql
SQL
1 vote241 views1 answer
Sql select sum group by id laravel
SQL
20 votes194 views1 answer
Sql change column types
SQL
7 votes211 views1 answer
Sql limit decimal places
SQL
0 vote214 views2 answers
Insert data mysql with cmd
SQL
0 vote189 views1 answer
Drop all tables db2
SQL
2 votes202 views2 answers
Sql percentage
SQL
5 votes172 views2 answers
Create table
SQL
1 vote201 views1 answer
Best configuration for display table in sqlplus
SQL
14 votes192 views2 answers
Oracle add column with default value
SQL