David Blomstrom wrote:
I just wondered if anyone on this list has worked with
counties in databases and is aware of a pre-existing
code system that's in fairly wide use. It would be
nice to make a database that's compatible with other
databases, if they share a common code for counties.
I don't kn
Garth Webb wrote:
I'm not asking for an alternative way to do it; I'm asking what
is wrong with what I did?
It looks like you want to copy over several or all values from a second
table. The INSERT .. SELECT syntax isn't an alternate way, its the only
way.
Okay, thanks for the clarification. I di
Victoria Reznichenko wrote:
"P. Hill" <[EMAIL PROTECTED]> wrote:
Why when there is a figurae, figurae2 table does the follow give an error?
INSERT INTO figurae2 SET id = figurae.id;
The error is:
ERROR 1109 at line 35: Unknown table 'figurae' in field list
>
Look
Why when there is a figurae, figurae2 table does the follow give an error?
INSERT INTO figurae2 SET id = figurae.id;
The error is:
ERROR 1109 at line 35: Unknown table 'figurae' in field list
Line 35 is the Insert line shown. There are no following lines in the file.
I cut and pasted "figurae" fro
I have imported 1000s of records into a table and even spent some time
cleaning up characters which I messed up as I imported them (not the
fault of the DB layer, but the result of bringing things into a text
editor), but now I have the following problem.
I have a whole series of author and boo
