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 to detect which rows in the result of that statement > are your FOREIGN KEYS. They not only indicate which table(s) is/are > this table's parent(s) but also which columns participate in each > relationship. > This technique does not rely on any particular connection library as > the functionality is provided by MySQL itself. Once the > INFORMATION_SCHEMA views are made available as of v5.x+ we will have > an alternative to using the "SHOW" family of statements to extract schema metadata. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'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 with MySQL, is it, and if so how is it possible to use the Database Synchronisation function so that the resulting tables are of type InnoDB? As it is, the tables are created fine, but I can not access them to get the FK data, as they are of type MyISAM. Thanks and regards Paul. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 information may be vendor specific? (am using MYSQL 4.018). Can anyone tell me if MySQL is capable of serving up such information - particularly using JDBC & JConnector) thanks and regards Paul.
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 information may be vendor specific? (am using MYSQL 4.018). Can anyone tell me if MySQL is capable of serving up such information - particularly using JDBC (JConnector)) thanks and regards Paul.
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 select a column to be unique using the said version please? thanks Paul.
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() differed significantly to the time generated by the method above that uses the CPU clock?! To me, that would suggest MySQL has some kind of internal clock? Or am I barking up the wrong bush? Thanks for any input P. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 run it manually to ensure it is running, but there is no service to run. Like other entries to the list, I have it running on 2K with no problem. But on XP - no joy. All advice gratefully received. Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 mysql and am given a "can't connect" error. Has anyone had any experience of this / solution? I have it running on Win 2K no problem but need to migrate to XP. Thanks for all input, if not just to quell my cynicism of XP. Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 there, it will have become clear that I am not Japanese!). Can anyone tell me if this is possible / feasible from MySQL? Thanks and regards Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
