Re: Mysql 8 stored procedure

[Peter Brawley]

Quote

Put this command into an execute window!
CREATE TABLE zozo0615.proba (
onefield bigint NOT NULL AUTO_INCREMENT,
twofield int NOT NULL DEFAULT '0',
PRIMARY KEY (onefield)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8 SELECT "" AS threefield SELECT "" AS three

You will get a table with 3 fields because of a semicolon is missing between two command .

I do not find that on 5.6 or 8.0. Both respond with ...

ERROR 1064 (42000): 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 'SELECT "" AS three' at line 5