Error 1064 shown with MySQL

Asked By 10 points N/A Posted on -
qa-featured

Hello,

I am doing a research on MySQL and the error messages but concerning this particular error below I did not see much information. I would like some experts here to tell me all I need to know about the error from MySQL shown below.

Thanks.

An error has occurred

Query failed ALTER TABLE leads modify colum website Null::MySQL 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 at line 1

SHARE
Answered By -10 points N/A #176747

Error 1064 shown with MySQL

qa-featured

The following error has been occurring in you system because you are repeating a common syntax error again and again.The scripting that you are following is not correct as You have not provided semicolon at the end to terminate your statement. The error clearly states this deficiency.

The correct syntax of using the command is "ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_bin;"

Related Questions