It is a very good idea, and often overlooked, to a when creating a . Months later when you’ve forgotten what eggs_x_chickens was for, the will be extremely useful. It is especially useful if people will be accessing the , but you should go to the to do it even if the is for your private consumption.

How to a :

  testing (
    name VARCHAR(5)
) ='this is testing';

How to view the :

   testing;
+---------+---------------------------------------------------------
|    | CreateTable                                            |
+---------+---------------------------------------------------------
| testing |   `testing` (
  `name` varchar(5) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ='this is testing'   |
+---------+---------------------------------------------------------

Even more often overlooked: if you’ve repurposed or redesigned a an out of date should be updated, because an incorrect is worse than none at all.

ALTER  tablename  = 'new updated ';

If you liked this post, check out Seven Deadly Sins series at hubpages. Are you making any of these potentially career-ending mistakes with ?

Listen to this article Listen to this post
Rate this:
3.4

Related posts