Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 28 Nov 2001, 10:19
Palmer ofShinra's Avatar
Palmer ofShinra Palmer ofShinra is offline
 
Join Date: Oct 2001
SQL query help...

OK... pretty simple actually...

What would be the query to delete rows completely in a table.

Both the query for selective deletions and to just wipe the table clean...

Basically, it's for a polling type system, but not the normal VB one.

And every so often we need to clear out all the votes and start fresh.
Reply With Quote
  #2  
Old 28 Nov 2001, 11:11
Chen's Avatar
Chen Chen is offline
 
Join Date: Sep 2001
To delete all records:
DELETE FROM tableName;

To delete only some records:
DELETE FROM tableName WHERE fieldName = 'value';
__________________
Chen Avinadav
Formerly vBulletin.org Owner and Founder

chen@avinadav.com
Reply With Quote
  #3  
Old 29 Nov 2001, 11:14
Palmer ofShinra's Avatar
Palmer ofShinra Palmer ofShinra is offline
 
Join Date: Oct 2001
Many thanks... I couldn't seem to find my way around the mySQL documentation... way too much to wade through.

I'm still a rank amatuer at this, but getting better daily...
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:32.

Layout Options | Width: Wide Color: