Forum : When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Manju S Reddy 's Profile

When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?

When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
Asked by Manju S Reddy | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Manjunath,
1. VARCHARs with length less than 4 become CHARs
2. CHARs with length more than 3 become VARCHARs.
3. NOT NULL gets added to the columns declared as PRIMARY KEYs
4. Default values such as NULL are specified for each column
Mar 18, 2010

Forum By Category