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: [email protected]
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
