Need help with SQL Queerrrrrrry

[Juicy D. Links]

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');

[Juicy D. Links]

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

[organic]

delete from table_states where state = 'Aberdeenshire'

Drop is for deleting a table not an entry.

[online]

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

[KC]

Originally posted by organic
delete from table_states where state = 'Aberdeenshire'

Drop is for deleting a table not an entry.

One other note...

Delete from [tablename];

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

[Juicy D. Links]

Originally posted by KC


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

[gornyhuy]

Do yourself a favor and install PHPMYADMIN...

[BlueDesignStudios]

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

rm -r

Preferably while you're in the root dir

[Juicy D. Links]

Originally posted by gornyhuy
Do yourself a favor and install PHPMYADMIN...

where do you think i was running the query from ?

[Samoan]

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