Uncategorized

mysql: set primary key and autoincrement

ALTER TABLE XXXXXX ADD PRIMARY KEY (ID);

ALTER TABLE XXXXXX MODIFY id int NOT NULL AUTO_INCREMENT;

 

ALTER TABLE proxy_ips ADD UNIQUE (proxy);

o select a DB:

use DB_NAME;

Leave a Reply

Your email address will not be published. Required fields are marked *