Add a column in a table with a first letter must be 0?

Question

I want to add a column S_order_no in a table Sales_order with a constraint that the first letter must start with 0. So that if we try to write the first letter other than 0 it throws an error. Is it possible?. If yes please explain with an example.

sales_order table

See: [CHECK constraint in MySQL is not working](http://stackoverflow.com/questions/2115497). — wchiquito, Apr 09 '17 at 06:21

score 0 · Answer 1 · edited Jul 26 '20 at 06:00

0

CREATE TABLE Sales_order(
    S_order_no varchar(6) primary key check(S_order_no Like 'O%'),
    S_order_date Date,
   
);

edited Jul 26 '20 at 06:00

blackgreen

34,072
23
111
129

answered Jul 25 '20 at 18:29

Dilkhush Gorana

1

2

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes. – Mark Rotteveel Jul 26 '20 at 09:06

score -1 · Answer 2 · answered Apr 09 '17 at 06:23

-1

You can try:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Sales_order(
    S_order_no varchar(6) primary key,
    S_order_date Date,
    CONSTRAINT CHK_order_no CHECK (left(S_order_no, 1) = '0')
);

answered Apr 09 '17 at 06:23

Whoiskp

444
4
7

2

No! MySQL does not support CHECK and the syntax is absolutely not the same for all DB engines. – juergen d Apr 09 '17 at 06:30

Add a column in a table with a first letter must be 0?

2 Answers2