Jump to content


Photo

The Parts of a Create Table Statement.


  • Please log in to reply
3 replies to this topic

#1 Random

Random
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationIndiana

Posted 02 April 2003 - 03:34 AM

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

#2 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 02 April 2003 - 03:48 AM

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.
DEFINE("YOU","Spending Too Much Time On The Computer");

#3 Random

Random
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationIndiana

Posted 03 April 2003 - 05:09 AM

anyone know the rest?

#4 DocSeuss

DocSeuss
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts
  • LocationTexas, USA

Posted 03 April 2003 - 05:45 AM

http://www.phpfreaks...ml#Column_types
"Unlimited budget? Great, for $5,000,0000 we will run your ad banner for one year"  ----Rasmus Lerdorf




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users