I have posted a similar question on the blojsom group but I feel I will
have better chance of an answer here.
Blojsom 3 was developed using MySQL5 for it's back end. However the
host I am with uses 4.0.25 and are unwilling to upgrade - which is fair
enough.
So I decided to see what I can do
Dan Buettner wrote:
Graham, I seem to recall those single quote marks working without a
problem on various platforms and versions of MySQL. Of course they are
generally just a nicety and only required if you are using reserved
words as table/column/key names, so you could just remove them ent
Using the text mode mysql client program I tried to alter a table - but
received a syntax error. Why?
mysql> alter table blog convert to character set utf8;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to
Graham Reeds wrote:
Using the text mode mysql client program I tried to alter a table - but
received a syntax error. Why?
This is using MySQL 4.0.25 btw.
mysql> alter table blog convert to character set utf8;
ERROR 1064: You have an error in your SQL syntax. Check the manual t
Quentin Bennett wrote:
http://dev.mysql.com/doc/refman/4.1/en/alter-table.html
From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this:
ALTER TABLE tbl_name CONVERT TO CHARACTER
Raz wrote:
Dan,
Forgot to say, re. MySQL Workbench - this may be a useful source of info:
http://forums.mysql.com/list.php?113
Raz
Sent off the link to the forum before I moved on to this message. D'OH!
G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Bruno Cochofel wrote:
Does anyone know a sw that can reverse engineering a mysql table? I want to
be able to draw a entity-relationship model from an already made MySQL
table.
Thanks,
Bruno
There's MySQL Workbench here: http://forums.mysql.com/list.php?113 which
is a bit shakey but will do t
