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