Sql check

Sql constraint check value in list

ALTER TABLE <table>
ADD CONSTRAINT chk_val CHECK (col in ('yes','no','maybe'))

Source: stackoverflow.com

Sql constraint check value in list

CREATE TABLE test(
    _id BIGINT PRIMARY KEY NOT NULL,
    decision NVARCHAR(5),
    CHECK (decision in ('yes','no','maybe'))
);

Source: stackoverflow.com

Sql query checker

CREATE TABLE employee

   ( employee_id VARCHAR(20),

    Name VARCHAR (20),

    Address VARCHAR (20),

    Mobile_no  SMALLINT);

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

14 votes133 views4 answers
Sql compiler
SQL
0 vote149 views1 answer
No query unable to fetch row sqlite
SQL
12 votes163 views6 answers
How to install sqlite3 in python
SQL
0 vote136 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote134 views1 answer
Top 10 rows in mysql
SQL
1 vote95 views2 answers
Last working day in week date function in sql
SQL
1 vote178 views1 answer
How to check all scheduled jobs in oracle
SQL
6 votes131 views4 answers
How to remove unique key in mysql
SQL
0 vote137 views1 answer
Sql reverse order of results
SQL
0 vote138 views1 answer
Sql query wordpress export post
SQL