Looking For Database ID number to Random number

any one help me out to recoding of users in database and id number set as unique such as 1,2,3 or put 'null'

e.g

CREATE TABLE IF NOT EXISTS `Classificator_Country` (
`user_ID` int(11) NOT NULL AUTO_INCREMENT,

can i set the ID number as random, or auto gernerate number where user can login with auto number,
help me please

 

this code set fild "user_id" as primary key and have auto imcrement

CREATE TABLE IF NOT EXISTS `Classificator_Country` (
`user_ID` int(11) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`id`)
);

you can stay this field null, every add records will have auto id

 

sir i have do that auto imcrement that added users as id=1, id=2
but i needed auto generator number like
id=552214
id=221444
something like that

 

only by hard coding... you must create a counter with value such like = 555555, and make increment (count++)

also you can create in database 555555 record, and delete these records, and then all next records will have id = 555556, and 555557, 555558

 

yeah i do that and added loops, and array in PHP, but what thing i want if its done best well i do that
e.g loop-id=5, x=5, user-id=1
function (new);
{ id+5/2*3.5 , ans+user-id`

something like that,

if you got added number notify me

 

Для установки нужного Вам числа выполните запрос

PHP:

ALTER TABLE `Classificator_Country`  AUTO_INCREMENT = 552214

Не советую средствами программирования делать произвольное число так как оно является уникальным и рано или поздно совпадет, тогда будет не очень приятная ситуация.

 

yeah i know that but there is possibility that user are not login with user name but login with auto generator number