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

0 vote165 views1 answer
Mysql find foreign key references
SQL
12 votes175 views4 answers
SQL Where
SQL
3 votes194 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote178 views1 answer
Create another table from existing table sql oracle
SQL
0 vote172 views1 answer
How to output a different column name in mysql
SQL
0 vote171 views1 answer
Create function syntax sql server
SQL
16 votes181 views2 answers
Mysql date between two dates
SQL
0 vote170 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
1 vote246 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
7 votes260 views2 answers
Oracle foreign key reference table
SQL