Thread: SQL deleting
View Single Post
  #5  
Old 05-13-2009, 12:14 AM
napo_p2p napo_p2p is offline
oh snaps
napo_p2p's Avatar
Join Date: Sep 2003
Location: Pismo Beach, California
Posts: 2,118
napo_p2p has a spectacular aura aboutnapo_p2p has a spectacular aura about
Send a message via AIM to napo_p2p Send a message via MSN to napo_p2p
Quote:
Originally Posted by cbk1994 View Post
And, for columns you can use

NPC Code:


ALTER TABLE table_name

DROP COLUMN column
For MySQL, yes. With SQLite (default database for Graal servers), you can only rename or add columns when altering tables. Dropping columns is not directly supported.
__________________
Scito hoc super omnia.
Haec vita est tua una sola.
Dum vita superest, utere maxime quoque puncto, momento, et hora quae habes.
Tempus neminem non manet.
Noli manere tempus.
Carpe Diem

Seize the Day.
Reply With Quote