What is the equivalent of "DEFAULT ((-1)) FOR" in mysql

Asked May 24 '19 at 11:51

Active May 24 '19 at 11:58

Viewed 59 times

I have some data from Sql Server and I want to create the same data in Mysql but I have an error. This is the syntax from Sql server:

ALTER TABLE [SecurityServices].[acces_grp_usr] ADD  CONSTRAINT [DF_ACCES_GRP_USR_ID_CALQ]  DEFAULT ((-1)) FOR [ID_CALQ]

I changed it like this in mysql:

ALTER TABLE acces_grp_usr ADD  CONSTRAINT DF_ACCES_GRP_USR_ID_CALQ  DEFAULT ((-1)) FOR ID_CALQ

and this is the error:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT ((-1)) FOR ID_CALQ' at line 1

thanks for your help.

edited May 24 '19 at 11:58

John Conde

217,595
99
455
496

asked May 24 '19 at 11:51

Jihana Anb

Um, you can't use SQL Server syntax in MySQL. Why did you think this would work? – John Conde May 24 '19 at 11:52
I changed it in mysql and it didn't work I just posted it like this so you can understand what I'm talking about – Jihana Anb May 24 '19 at 11:54
That error message indicates that you didn't change the syntax at all. You should post what you are actually trying to run in MySQL if you want to get any help. – John Conde May 24 '19 at 11:55
I changed it thank you. – Jihana Anb May 24 '19 at 11:58
Possible duplicate of [Adding a new SQL column with a default value](https://stackoverflow.com/questions/3569347/adding-a-new-sql-column-with-a-default-value) – Patrick Tucci May 24 '19 at 12:29
I found the answer in case someone has the same error : ALTER TABLE acces_grp_usr MODIFY id_calq INT DEFAULT -1 – Jihana Anb May 24 '19 at 13:48

What is the equivalent of "DEFAULT ((-1)) FOR" in mysql

0 Answers0