Help about mysql
#3

Quote:
Originally Posted by BroZeus
Посмотреть сообщение
Go to phpmyadmin
Click on database name that you are using on left side of screen
Then click on SQL tab
Then paste these queires in text box
PHP код:
ALTER TABLE `objectsDROP COLUMN `ObjectID`;
ALTER TABLE `objectsADD `ObjectIDINT PRIMARY KEY AUTO_INCREMENT
Then hit 'GO'
Then a box will appear saying something like 'Are you sure you want.....' Click Yes on that

Here is a pic of it -
--
I have already key, which is `ScriptID`. I can't have 2 primary keys.
I tried to use the ObjectID as the primary key and then this error showed up once again instead of erroring `ObjectID` there was: " `ScriptID` doesn't have a default value OnQueryFinish "
Reply


Messages In This Thread
Help about mysql - by maximthepain - 28.01.2015, 04:07
Re: Help about mysql - by BroZeus - 28.01.2015, 06:42
Re: Help about mysql - by maximthepain - 28.01.2015, 14:04

Forum Jump:


Users browsing this thread: 1 Guest(s)