How to Add a primary key in database table

[anilson1]

I created a database with phpMyAdmin. I want to creat a table with a field that has auto-increament. I selected auto-increament to the primary field and type varchar(20). How can I solve this?
in some cases the text type gets an error for "no null". I need help. anybody???? or any reference to phpMyAdmin.

 

[woiwky]

Auto-increment can only be applied to a numeric field. Varchar is a string field, it's for storing character data. Try using a numeric type. Which to use depends on how many records you think will ever be created. You can view the max storage of them here:

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

 

[phpasks]

You can set

http://www.phpasks.com/images/primramy.jpg

Field = id
Type= bigint
length/values = 20
primery key = radio button seleted


Asif
http://www.phpasks.com

 

[anilson1]

Can I add auto_increment with these values? I mean:

Field=id
Type=bigint
length/values=20
Extra=auto_increment
primery key=radio button selected.

I want to increase the numeric value of id every time I add sth.

 

[Blazer9131]

I think that would work out nicely..

~Blaze

 

[anilson1]

this problem is solved. I don't know how to close this thread. I do not see the close checkbox.

 

[LHVWB]

this problem is solved. I don't know how to close this thread. I do not see the close checkbox.

I've closed it for you. :biggrin:

We have yet to actually find out if users can close their own threads in these sections.

* Closed *