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 vote295 views1 answer
Create new table from old table with data
SQL
1 vote269 views2 answers
Pl sql case
SQL
1 vote289 views1 answer
Query for all indexes in table postgres
SQL
3 votes298 views3 answers
Order by postgres
SQL
0 vote287 views1 answer
Replace content value from old to new sql
SQL
4 votes297 views1 answer
Id increment ms sql server
SQL
2 votes273 views5 answers
Alter table primary key postgresql
SQL
0 vote307 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote283 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote294 views1 answer
Sql server pivot rows to columns
SQL