|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
08-18-2003, 04:42 PM
|
#1 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
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'); |
|
|
|
08-18-2003, 04:49 PM
|
#2 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
i aint gonna make fun of Sobe or Lil2rich till i get help fuckers
 |
|
|
|
|
08-18-2003, 04:50 PM
|
#3 |
|
Registered User
Join Date: May 2003
Location: Passed Out In Jersey
Posts: 16
|
delete from table_states where state = 'Aberdeenshire'
Drop is for deleting a table not an entry. |
|
|
|
|
08-18-2003, 04:52 PM
|
#4 |
|
Registered User
Join Date: Mar 2003
Location: Uruguay
Posts: 22
|
You may have problems deleting other rows if state is not key
|
|
|
|
|
08-18-2003, 05:09 PM
|
#5 | |
|
Confirmed User
Industry Role:
Join Date: Jan 1995
Posts: 2,417
|
Quote:
Delete from [tablename]; without a where clause, will empty your entire table. Make sure you're really careful when deleting records.
__________________
 Jupiter Hosting, Inc. Vice President, Business Development kc (AT) jupiterhosting.com |
|
|
|
|
|
08-18-2003, 05:58 PM
|
#6 | |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
Quote:
SQl queries make me hard for some reason |
|
|
|
|
|
08-18-2003, 06:41 PM
|
#7 |
|
Chafed.
Join Date: May 2002
Location: Face Down in Pussy
Posts: 18,041
|
Do yourself a favor and install PHPMYADMIN...
__________________
 icq:159548293 |
|
|
|
|
08-18-2003, 07:02 PM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Feb 2003
Location: Australia
Posts: 9,492
|
Try this unix command as well while you're at it:
rm -r Preferably while you're in the root dir 
__________________
 Blue Design Studios - Adult Design Specialists! Email me for a free quote: [email protected] |
|
|
|
|
08-18-2003, 07:04 PM
|
#9 | |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
Quote:
|
|
|
|
|
|
08-18-2003, 09:18 PM
|
#10 |
|
Confirmed User
Join Date: Aug 2003
Location: Los Angeles, CA
Posts: 203
|
PHP myAdmin is a great tool. I highly recommend it if you work with a database a lot.
__________________
Samoan |
|
|
|
