Random Posted April 2, 2003 Share Posted April 2, 2003 can someone explain each part of the table...example: sql = CREATE TABLE test int not null AUTO_INCREMENT, dead VARCHAR(20), live CHAR(1); or whatever, like what does the int, not null, AUTO_INCREMENT, and VARCHAR/CHAR, and the numbers in the parathesis mean? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/289-the-parts-of-a-create-table-statement/ Share on other sites More sharing options...
Avalanche Posted April 2, 2003 Share Posted April 2, 2003 I know varchar is the maximum amount of characters it can have in it, and char might be the minimum, I\'m not sure about that one. Quote Link to comment https://forums.phpfreaks.com/topic/289-the-parts-of-a-create-table-statement/#findComment-893 Share on other sites More sharing options...
Random Posted April 3, 2003 Author Share Posted April 3, 2003 anyone know the rest? Quote Link to comment https://forums.phpfreaks.com/topic/289-the-parts-of-a-create-table-statement/#findComment-917 Share on other sites More sharing options...
DocSeuss Posted April 3, 2003 Share Posted April 3, 2003 http://www.phpfreaks.com/mysqlmanual/page/...ml#Column_types Quote Link to comment https://forums.phpfreaks.com/topic/289-the-parts-of-a-create-table-statement/#findComment-919 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.