Re: SHOW foreign keys

2004-08-17 Thread Michael Seele
and how is a foreign key displayed? as KEY or FOREIGN KEY??? Martijn Tonies schrieb am 17.08.2004 12:24: Hi, how can i get all the foreign keys from a database? i used SHOW INNODB STATUS; but i get an unknown error! You can only get them on a per-table basis with a SHOW CREATE TABLE statem

SHOW foreign keys

2004-08-17 Thread Michael Seele
hi! how can i get all the foreign keys from a database? i used SHOW INNODB STATUS; but i get an unknown error! thanks! -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www.guh-sof

Re: get extended infos over table-columns

2004-08-10 Thread Michael Seele
YES! but these statement DON'T return my needed infos("maximumDataLength", "numericPrecision", "numericScale")!!! Martijn Tonies schrieb am 10.08.2004 14:27: yes!! Did you find SHOW [FULL] COLUMNS FROM I know I did when looking through the docs... With regards, Martijn Tonies Database Wo

Re: get extended infos over table-columns

2004-08-10 Thread Michael Seele
yes!! Martijn Tonies schrieb am 10.08.2004 14:03: Hi, i need some extended infor over the table-columns! how can i get the "maximumDataLength", "numericPrecision", "numericScale" of a column? Did you check the documentation? With regards, Martijn Tonies Database Workbench - developer tool f

get extended infos over table-columns

2004-08-10 Thread Michael Seele
hi, i need some extended infor over the table-columns! how can i get the "maximumDataLength", "numericPrecision", "numericScale" of a column? thx -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N.

Re: connect to mySQL without database

2004-08-09 Thread Michael Seele
oh! sorry! i use java! [EMAIL PROTECTED] schrieb am 09.08.2004 14:33: Not which natural language, which programming language? We need to know in order to help you. C, C++, Java, Perl, PHP, Python... The answer will differ. Alec Michael Seele <[EMAIL PROTECTED]> 09/08/2004 13:

Re: connect to mySQL without database

2004-08-09 Thread Michael Seele
i use mySQL english version! why? Karam Chand schrieb am 09.08.2004 14:13: Yes. Which language you are using? Regards, Karam --- Michael Seele <[EMAIL PROTECTED]> wrote: hi, is it possible to connect to a mySQL-Server without entering a database and then check all available database

connect to mySQL without database

2004-08-09 Thread Michael Seele
hi, is it possible to connect to a mySQL-Server without entering a database and then check all available databases? thx mseele -- G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20 Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90 D-72160 Horb a.N. http://www

infos over the internal meta-data for mysql-databases

2004-08-09 Thread Michael Seele
hi, i write a application in java that creates database-diagrams like ms-visio can do this! until now i only support ms sqlserver and oracle for importing data from the database and displaying a database-diagram! now i want to add mySQL support into my application! for this reason i need to kno