Platform : Win 8
Connect to MySQL v 8.0 providing valid connection details
-----------------------------------------------------------------------------------------------------------
Expand Databases,expand database named 'harish' -> expand tables -> select table 'airline'
Right click on this table -> select 'script object to windows as' ->select Create(full)
In the window with SQL generated , change the table name to a table name which is not present in this DB
Click on execute button.
Verify if the query is successfull executed and a new table is created.
Expected:
A new table should be created.
Actula
User gets an error
Below is the sql generated
CREATE TABLE aaairline ( airline_id bigint(20) NULL, name text NULL, iata_code text NULL, icao text NULL, callsign text NULL, country text NULL, active text NULL ) ENGINE = InnoDB AUTO_INCREMENT = 0 GO CREATE INDEX Unique D USING BTREE ON aairline(airline_id DESC) GO
Error post execution of query
>[Error] Script lines: 13-15 ------------------------
Screenshot is attached for further reference.
184 KB
134 KB
Hi Shubhang,
The syntax is correct. You just don't have quotes turned on in File->Options->Scripts->MySQL. See screenshot.
Thanks,
Tom
Issue #15677 |
Closed |
Invalid |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Hi Shubhang,
The syntax is correct. You just don't have quotes turned on in File->Options->Scripts->MySQL. See screenshot.
Thanks,
Tom