Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 newbie

Author  Topic 

darsh999
Starting Member

1 Post

Posted - 2007-08-15 : 09:49:16
hi i am new to mysql...and please can someone help me to tell a command how to delete a table frm database??

(spam removed)

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-15 : 09:51:41
you want to delete the table complete then use

drop table table_name

if you want to delete just the data from table then

truncate table table_name
or
delete from table_name

USE BOOKS ONLINE AND THERE IS LOT OF HELP ON ALMOST EVERYTHING

Ashley Rhodes
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-15 : 09:53:35
quote:
hi i am new to mysql

This is a Microsoft SQL Server forum. Try posting over at http://forum.mysql.com/


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

pootle_flump

1064 Posts

Posted - 2007-08-15 : 10:36:18
Nice bit of spam there too darsh.
Go to Top of Page
   

- Advertisement -