RE: MYSQL + acquiring table relationships

Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial

'TYPE = InnoDB'

Hi, I need to obtain FK data from my DB. I am designing the database using DBDesigner. Using the said tool, do I have to export my schema as SQL and manually append the table type (TYPE = InnoDB) at the end of the table definition? For each table?! For those of you who are using DBDesigner

MYSQL + acquiring table relationships

Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such informat

MYSQL + acquiring table relationships

Hi, How can I, if at all, acquire table relationships - in particular one-to-may/many-to-one relationships? I have looked into the DatabaseMetaData object (Java) , but have not as yet been able to acquire the said relationship data. I post to this list as the ability to pull such such informat

Set unique from Control Centre

Hi, Using MYSQL Control Centre 0.9.4 Beta, I would like to set a column to be a unique field. When I choose to edit the table, the Unique radio, along with Index and Fulltext is dulled out (deactivated). No amount of 'fiddling' has enabled me to select this feature. How may I sel

Control Center autoincrement

Hello, May I specify a column to auto increment from within the Control Center UI, either on or after creation? thanks Paul.

Control Center autoincrement

Hello, May I specify a column to auto increment in the Control Center UI, either on or after creation? thanks Paul.

internal MYSQL clock?

Hi, I just encountered a problem when entering a datetime field. Using 'now()' in my SQL string input a time about 13 minutes before my other method (a JSP System.currentTimeMillis() method - one that generates the time from the CPU clock) Can anyone tell me why the time generated by now() d

MySQL / XP / some expletive

Hello, This post pertaining to a previous one on the same subject. That is I cannot get MySQL to run on Win XP! I get the "ERROR 2003: can't connect to MySQL server on 'localhost' (10061)" when running mysql from c:\mysql\bin in the command prompt. I have looked for the MySQL service to

MySQL on XP

Hello, I am trying to install and run MySQL on Win XP, the latest release being: MySQL 3.23.49, Windows 95/98/NT/2000/XP (12M), from http://www.mysql.com/downloads/mysql-3.23.html. My problem is simply that I cannot use it after installation! I go into the command prompt, cd mysql\bin, type my

Roman alpha sorting!

Hello, Further to my last entry, and hopefully more simple, does MySQL have the capability of sorting data alphabetically using the ROMAN alphabet? Ie A-Z. Thanks for all input Paul. - Before posting, please check: http

Japanese alpha sorting?

Hi, I wish to alphabetically sort data retrieved from MySQL using JSP for web a page. The data will be stored in Japanese. I understand there are multiple alphabets/dialects in Japanese with a large number of characters for each, so this may be difficult / impossible (for the Japanese out ther