MySql error # 1064 comes up.

Question

3.00/5 (1 vote)

See more:

Hello,

I'm using this SQL :

SQL

ALTER TABLE  `Houses` ADD  `Phase` VARCHAR NOT NULL

And this is the error that comes up :

SQL

#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 'NOT NULL' at line 1

I'm using MySql clint version 5.1.62.

What's the problem? Any ideas?

Posted 25-Jul-12 21:21pm

FahdSanaullah

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-07-25T21:35:00

Solution 1

You need to specify the size:

SQL

ALTER TABLE  `Houses` ADD  `Phase` VARCHAR(100) NOT NULL

Posted 25-Jul-12 21:35pm

OriginalGriff

MySql error # 1064 comes up.

1 solution

Solution 1

Add your solution here

Preview 0

MySql error # 1064 comes up.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us