September 04, 2010, 08:32:07 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  Home Help Media Affiliates Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: [SQL] delete data table  (Read 550 times)
0 Members and 1 Guest are viewing this topic.
Arkie
Javaforums.net Admin
Senior Member
*

Reputation: 16
Developer @ Javaforums.net
Offline Offline
Posts: 2620
Referrals: 13

WWW Awards
« on: August 08, 2009, 08:52:20 AM »

To delete every column in a table you can do:
Code
GeSHi (sql):
  1. DELETE * FROM someTable
Created by GeSHI 1.0.7.20

or if you want to delete data from a table that meets a certain condition:
Code
GeSHi (sql):
  1. DELETE * FROM someTable
  2. WHERE someCondition = 1
Created by GeSHI 1.0.7.20
Logged

Java and .NET developer

To students: It doesn't matter how hard you've studied; the material won't be on the exam anyway.

Fan of http://www.retardedweblogger.com
Oh man, too much stuff to do in so little time.

http://img222.imageshack....707/arkietomatoesmall.jpg
Blizzcon 2k9 Grubby and Cassandra Ng engaged ! <3
Triple D, eerste Denken Dan Doen
Javaforums.net :: a community about Java software development.
« on: August 08, 2009, 08:52:20 AM »

 Logged
ashish
Member
*

Reputation: 0
Offline Offline
Posts: 27
Referrals: 0

Awards
« Reply #1 on: August 12, 2010, 01:38:38 AM »


DELETE * FROM alextable it delete the total record or filed . thumbsup thumbsup thumbsup.
regards,
phe9oxis,
« Last Edit: August 12, 2010, 02:20:00 AM by Arkie » Logged
Javaforums.net :: a community about Java software development.
   

Your Ad Here
 Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.10 | SMF © 2006-2009, Simple Machines LLC
TinyPortal v0.9.8 © Bloc
Valid XHTML 1.0! Valid CSS!
Page created in 0.278 seconds with 33 queries.

Google visited last this page Yesterday at 01:55:25 PM