mysql insert statement using sql execution error

vkimura · Post by **vkimura** » Thu 10 Jun 2010 05:27

Hi,

I'm just wondering how I can execute a mysql insert statement using the sql tab. I selected the proper server at the top drop-down menu. But when I used this insert mysql:

INSERT INTO `howtopr1_medicaidc.mcinfo` (`info_id`, `title`, `desc`, `keywords`, `robots`, `css_includes`, `javascript_includes`, `analytics`, `header`, `h1`, `h2`, `header_nav`, `left_col`, `body`, `footer`) VALUES (63,...);

The dbforge gives me an error and prepends the statement with:

'howtopr1_table.howtopr1_medicaidc.mcinfo'

Not quite sure how to get around this.

I have a snapshot of this problem here:
http://mysql.tutorialref.com/dbforge/db ... error.html

Thank you,
Vkimura

Viktor · Post by **Viktor** » Thu 10 Jun 2010 11:24

INSERT INTO `howtopr1_medicaidc.mcinfo` ....

It is necessary to quote database and table name separately.
Try to perform the Insert stated below:

INSERT INTO `howtopr1_medicaidc`.`mcinfo` (`info_id`, `title`, `desc`, `keywords`, `robots`, `css_includes`, `javascript_includes`, `analytics`, `header`, `h1`, `h2`, `header_nav`, `left_col`, `body`, `footer`) VALUES (63,...);