Re: [libreoffice-users] Re: LO Base Problem

On 02/22/2015 03:20 PM, Alex Thurgood wrote:
> You could try using :
>
>        ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
Thanks Alex

I gave this a try in MyAdmin and got ...


 Error

*SQL query:*

||

|ALTER TABLE Members CHANGE RecordID1 INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
|

*MySQL said: *Documentation 
<http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Ferror-messages-server.html&token=8d06c7c288ebb2e01f21b98220996b09> 


|#1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY' at line 1 |

My SQL is Ver 5.1.73 and MyAdmin 4.2.10.1

IanW
Pretoria RSA

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted