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: }>); 

enter image description here

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

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

javascript - IE9 error '$'is not defined -