SQL help

Swan · Post by **Swan** » 16 Aug 2007, 13:58

Ok...see the million or so -> symbols...I put them there to make my point more clear...

basically Im coding in SQL via the command line client, and sometimes ofc I make an error or worse, I have finished with a table and wish to move onto a new table. My concern is that if I still see ->, then that means any data I enter will be allocated to the first table and not the new table that I create.

how do I avoid this?

Thanks guys!

just started SQl so Im sorry if this is a really retarded question.

Nerdz · Post by **Nerdz** » 16 Aug 2007, 21:05

can't you use simply : INSERT INTO tablename VALUES()?

Post by **pseudo_opcode** » 17 Aug 2007, 04:22

terminate the statement with ';' and you wont see them

Swan · Post by **Swan** » 17 Aug 2007, 04:29

thanks guys