Hi I am trying to use SQLBuddy to create a new database on my PI.
I have:
Your MySQL connection id is 76
Server version: 5.5.28-1 (Debian)
and :
PHP 5.4.4-10 (cli) (built: Dec 5 2012 06:51:42)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies
I have created a database but cannot create any tables error is :
"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 'not null primary key) CHARSET latin1' at line 1"
has anyone got this working?
thanks
James