SQL QUERY ERROR "DEFAULT NULL"

Question

I am trying to write an sql query in PHP My admin ,but facing an error could any one help please!

QUERY

ALTER TABLE `transactions` ADD `giftAmount` FLOAT NOT NULL DEFAULT '0' AFTER `recievingCurrency` ,
ADD `giftCurrency` VARCHAR NULL DEFAULT NULL AFTER `giftAmount`

ERROR

#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 'NULL DEFAULT NULL AFTER giftAmount' at line 2

HELP

A nullable column by definition has a default value of NULL. The error message is quite clear and point to the exact location of the error. Remove DEFAULT NULL and try again — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jul 3, 2014 at 7:45

mvp · Accepted Answer · 2014-07-03 07:43:04Z

2

Your syntax is not correct. Try:

ALTER TABLE `transactions`
  ADD `giftAmount`   FLOAT   NOT NULL DEFAULT '0'  AFTER `recievingCurrency` ,
  ADD `giftCurrency` VARCHAR                       AFTER `giftAmount`

You don't need to explicitly say DEFAULT NULL - it already is NULL by default.

answered Jul 3, 2014 at 7:43

mvp

118k15 gold badges132 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sadikhasan · Accepted Answer · 2014-07-03 07:42:02Z

1

You have to give size of varchar datatype like

ADD `giftCurrency` VARCHAR(100) DEFAULT NULL AFTER `giftAmount`

answered Jul 3, 2014 at 7:42

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Collectives™ on Stack Overflow

SQL QUERY ERROR "DEFAULT NULL"

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related