I'm exporting data from an old db to a new one with less fields, different field types, and so on. What i did first was copy the table as is from the old database to the new one, naming it tickets2. I'm using a php script to transform data within the old table and pass it to the new one.
This is the problem, I can't even get the SQL parser to recognise the following simple statement : (ive tried all of the following)
INSERT INTO tickets ('ID') SELECT ('ID') FROM tickets2
INSERT INTO tickets ('ID') VALUES ( SELECT ('ID') FROM tickets2 )
Obviously the SQL statement to transfer all the data is way more complex, but this doesn't even work. What's going on?