Insert Into ... Select

[expired user #5259]'s profile image [expired user #5259] posted 13 years ago in General Permalink
When I write m. , heidi says:
/* SQL Error (1146): Table 'simulator2c.m' doesn't exist */

(simulator2s database is selected)
Insert Into simulator2s.settings
s(SettingName, CategoryId, ValueTypeId, Tag, ShownLevel, PathId)
Values
Select m. From simulator2c.mysettings m

ansgar's profile image ansgar posted 13 years ago Permalink
It's written in the SQL log panel, after this is tried for interpreting your SQL code, to get a completion proposal. If "m" was a table or a table alias, "m." would popup the column names in that table.
[expired user #5259]'s profile image [expired user #5259] posted 13 years ago Permalink
m is not a table. it just abbreviation of simulator2c.mysettings
when I write 'm.' the column popup do not appears.
ansgar's profile image ansgar posted 13 years ago Permalink
So, what have you exactly written, completely?

Please login to leave a reply, or register at first.