Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error 1064 on change SMALLINT field type

marco811's profile image marco811 posted 4 months ago in General Permalink

Hello

There is an error doing "alter table" for a "SMALLINT" field.

ALTER TABLE store CHANGE COLUMN order order SMALLINT(5,0) NOT NULL AFTER id; / Error de 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 ',0) NOT NULL AFTER id' at line 2 /

You can see the error in the screenshot. Must be "SMALLINT (5)" instead of "SMALLINT (5,0)"

regards

1 attachment(s):
  • Sin-t-tulo
marco811's profile image marco811 posted 4 months ago Permalink

Error appears when changing field order

ansgar's profile image ansgar posted 4 months ago Permalink

I think I fixed that already recently. Please update to the latest build and retry.

marco811's profile image marco811 posted 4 months ago Permalink

Thanks. I updated and works fine.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.