Sign into MySQL at the Terminal
mysql -u myusername -p
Show Table Columns
SHOW FIELDS FROM widgets
Drop a Column
ALTER TABLE 'widgets' DROP 'col_stuff'
Thursday, April 12, 2007
MySQL Cheat Sheet
This post will be updated and corrected periodically.
Sign into MySQL at the Terminal
Show Table Columns
Drop a Column
Sign into MySQL at the Terminal
Show Table Columns
Drop a Column
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment