Need help with SQL Queerrrrrrry
 

INSERT INTO table_states (state, code, country_code) VALUES ('Aberdeenshire','ABd','GB');


Ok if i want to drop this country would i make it look like this?

DROP table_states (state, code, country_code) VALUES ('Aberdeenshire','ABd','GB');

i aint gonna make fun of Sobe or Lil2rich till i get help fuckers :1orglaugh

delete from table_states where state = 'Aberdeenshire'

Drop is for deleting a table not an entry.

You may have problems deleting other rows if state is not key

One other note...

Delete from [tablename];

without a where clause, will empty your entire table. Make sure you're really careful when deleting records.

Thanks KC and others. Yeah i backed it up then fucked around with it till i got it.

SQl queries make me hard for some reason

Do yourself a favor and install PHPMYADMIN... :2 cents:

Try this unix command as well while you're at it:

rm -r

Preferably while you're in the root dir

:)

where do you think i was running the query from ?

PHP myAdmin is a great tool. I highly recommend it if you work with a database a lot.