Customize appearance of the navigation panel.
Customize the navigation tree.
Databases display options.
Tables display options.
xxxxxxxxxx
Customize default export options.
LOCK TABLES
Customize default options.
Customize default options
Scroll down to fill in the options for the selected format and ignore the options for other formats.
This format has no options
Add statements:
DROP DATABASE
DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
/ TRIGGER
CREATE TABLE
IF NOT EXISTS
AUTO_INCREMENT
CREATE VIEW
CREATE PROCEDURE / FUNCTION / EVENT
CREATE TRIGGER
Instead of INSERT statements, use:
INSERT
INSERT DELAYED
INSERT IGNORE
Syntax to use when inserting data:
INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3), (4,5,6), (7,8,9)
INSERT INTO tbl_name VALUES (1,2,3)