php - MySQL Workbench 6.0 - incorrect syntax template -
i new using mysql workbench, discovering now.
i can't find clear tutorial or documentation explain why syntax.
i have table, called chefs, id, name , country columns. want populate table, using mysql workbench, following tutorial, end doing right click on table want insert, click "send sql editor", , click on "insert statement". when this, template appears on query screen this:
insert `cooking_book_new`.`chefs` (`id`, `name`, `country`) values (<{id: }>, <{name: }>, <{country: }>);
i have checked , verified, if use regular syntax use use mysql inserts row:
insert chefs (id, name, country) values (1, 'chef1', 'country1');
but, whole point of trying use software make easier, know why prepares query, , how should introduce data there.
i have tried this:
insert `cooking_book_new`.`chefs` (`id`, `name`, `country`) values (<{1}>, <{'chef1'}>, <{'country1'}>);
and this:
insert `cooking_book_new`.`chefs` (`id`, `name`, `country`) values (<{id:1 }>, <{name:'chef1' }>, <{country:'country1' }>);
but seems wrong. know how use syntax? know query have tested works like:
insert chefs (id, name, country) values (1, 'chef1', 'country1');
but better if understand how mysql workbench works.
thank you!
the manual workbench contains explanation it, given large, (probably) take (me) longer keep searching, did , finding on website similar syntax.
as per manual:
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
the <{}>
representational (expressions) values.
for example:
update statement
update `sakila`.`actor` set `first_name` = <{first_name}> <{where_expression}>;
let's @ manual on insert:
http://dev.mysql.com/doc/refman/5.7/en/insert.html
you're not going use {values | value}
or rest of [...]
right? "options".
insert [low_priority | delayed | high_priority] [ignore] [into] tbl_name [partition (partition_name,...)] [(col_name,...)] {values | value}
it replace "representational" values proper syntax, needs used in conjunction reference manual.
Comments
Post a Comment