[PHP-DB] How do I know when to

2002-01-11 Thread Jerry Leonard
Hi, I am really new to MySQL and am wondering this: I understand how to make a database and tables but what I don't understand is when to make a row an int with auto_increment or just a plain int. Or why would you use varchar(50) instead of char(50). Could someone please explain what is

Re: [PHP-DB] How do I know when to

2002-01-11 Thread Raquel Rice
On Fri, 11 Jan 2002 15:02:00 -0800 Jerry Leonard Jerry Leonard [EMAIL PROTECTED] wrote: Hi, I am really new to MySQL and am wondering this: I understand how to make a database and tables but what I don't understand is when to make a row an int with auto_increment or just a plain int.

[PHP-DB] How do I know when to

2002-01-11 Thread Jerry Leonard
Okay this is the way I understand the statement below. The uid will be a number from 1 to 10, max length of ten digits say starting at 1 then as the next user registers it will automatically make that user number 2. Am I correct? CREATE TABLE users ( uid int(10) unsigned NOT NULL

Re: [PHP-DB] How do I know when to

2002-01-11 Thread Raquel Rice
On Fri, 11 Jan 2002 17:21:28 -0800 Jerry Leonard Jerry Leonard [EMAIL PROTECTED] wrote: Okay this is the way I understand the statement below. The uid will be a number from 1 to 10, max length of ten digits say starting at 1 then as the next user registers it will automatically make that