mysql PHP auto increment column

Question

How do i add an auto incrementing column called ID to these statements:

$sql = "CREATE TABLE IF NOT EXISTS ".$username." (uid varchar(255), tweet varchar(255))";
$alter = "ALTER TABLE ".$username." ADD UNIQUE (uid)";

Thanks

alampada · Accepted Answer · 2011-01-15 15:34:37Z

1

I would do

"CREATE TABLE IF NOT EXISTS ".$username." (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY, uid varchar(255) UNIQUE, tweet varchar(255))";

answered Jan 15, 2011 at 15:34

alampada

2,4192 gold badges26 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Why limiting the auto increment to 8 millions?

Déjà vu · Accepted Answer · 2011-01-15 15:32:05Z

1

$sql = "CREATE TABLE IF NOT EXISTS ".$username." (ID int not null auto_increment primary key, uid varchar(255), tweet varchar(255))";

answered Jan 15, 2011 at 15:32

Déjà vu

29k6 gold badges79 silver badges105 bronze badges