insert operation in MySQL

[Guest_imported]

This is what I'm trying to do :

insert into table supporters values(null,"Degraef Nico", "Daalstraat 46 3870 Heers","nitro2000be@hotmail.com","tafeltennis-uitgaan-muziek","

http://www.powong66.f2s.com","Aruna,

Stoica","RSCA","Van Den Stock",'null')


mysql gives as an error:

MySQL retourneerde: You have an error in your SQL syntax near 'table supporters values(null,"Degraef Nico", "Daalstraat 46 3870 Heers","nitro20' at line 1

I thought that the problem was the @ sign, but if I remove it, MySQl still gives an error and then the error is :

MySQL retourneerde: You have an error in your SQL syntax near 'table supporters values(null,"Degraef Nico", "Daalstraat 46 3870 Heers","nitro2000be","ta' at line 1

 

[fortytwo]

Just noticed:
[tt]
insert into table supporters values(null,"Degraef Nico", "Daalstraat 46 3870 Heers","nitro2000be@hotmail.com","tafeltennis-uitgaan-muziek","www.powong66.f2s.com";,"Aruna, Stoica","RSCA","Van Den Stock",'null')
[/tt]
you have a semi-colon in the text (highlighted in red) try removing that.

previewing this post puts yet another semi-colon into the code however, so it could be that the forum put the original one in. Also, print out your sql statement after you have constructed it, it might reveal errors that are harder to spot in the code.

Will.
fortytwo
will@hellacool.co.uk

 

[Guest_imported]

No, it wasn't that, that wasn't originally in my query, but the problem was insert into TABLE supporters.
The table doesn't have to be there