datetime as float
Is there any MySQL built in function to convert datetime types to real numbers (float) i.e. seconds or days since a reference date? I can't find any in the manual. If not, how do I best write a speedy one (conversion of calendar dates to Julian days is a bit tricky)? Thanks in advance for any help or suggestion H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för laboratoriemedicin KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax +46 (8) 585 877 79 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgraded (?) to MySQL 3.23.52 and lost connection
Yesterday I upgraded (?) to MySQL 3.23.52 on two different machines and since then I get the message MyODBC 3.51 DataSource Test MySQL ODBC 3.51 Driver : 03.51.02 [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query when I try to test the data source from windows with MyODBC 3.51. I get similar results from programs using the Zeos database components and my Roxen server refuses to connect. The mysqld is running on a freshly installed Red Hat Linux 8.0 and the mysql console program running on this machine functions normally. Is the new RH 8.0 or MySQL 3.23.52 to blame or can I be doing something wrong? Pls help me Håkan Håkan Elmqvist Sunnerdahlsv 7 167 62 Bromma Telefon: +46 (8) 80 18 81, +46 (704) 56 74 81, +46 (176) 84 077 epost: [EMAIL PROTECTED] - 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
minimal SQL
I am new to databases and SQL and find the language rich and interesting. It seems to me, however, that there are quite a few redundant elements and that the language is the result of quite a few compromises. There are not less than 233 keywords in MySQL. Is there any preferred way to write SQL-statements? Is there any purist or minimalist view? Håkan Elmqvist - 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
Functions as default values
Timestamp is a useful datatype when you want to register when a record changed. Now I want to register who changed it and tried to use user() as a default value and my database just returned user() as the field value. Is there someone who can tell me how to use a function result as default value? The manual is not very clear on this issue. H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
Illegal table names
By accident, I don't know how (perhaps microsoft played me a trick), I managed to create a table with a name containing spaces i. e. a useless table with an illegal name. Now would like to drop that table. Is there anyone who knows how? H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
Illegal table names
Thanks for your very rapid response but: mysql show tables; +--+ | Tables_in_test | +--+ | personer | | resultat impl VT2001 | | tentamen_impl_vt2001 | +--+ 3 rows in set (0.00 sec) mysql drop 'resultat impl VT2001'; ERROR 1064: You have an error in your SQL syntax near ''resultat impl VT2001'' at line 1 mysql drop resultat impl VT2001; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001' at line 1 H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
Illegal table names
I am sending this again since for some reasons undescores don't show up in this forum. The third table name should read tentamen_impl_vt2001 i.e. tentamen[underscore]implunderscore]vt2001 which is legal. Thanks for your very rapid response but: mysql show tables; +--+ | Tables_in_test | +--+ | personer | | resultat impl VT2001 | | tentamen_impl_vt2001 | +--+ 3 rows in set (0.00 sec) mysql drop 'resultat impl VT2001'; ERROR 1064: You have an error in your SQL syntax near ''resultat impl VT2001'' at line 1 mysql drop resultat impl VT2001; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001' at line 1 H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
Illegal table names
mysql drop `resultat impl VT2001`; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001`' at line 1 I don't seem to have the proper character `. What's the ASCII? H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
Illegal table names
The character seems to be decimal 96 (enter it with Alt-96 on a PC). Interestingly the command produces an error when the command is given directly to mysql over a ssh connection but works fine when invoked with Zeos Simple_mysql (http://www.zeoslib.org/zeos_zia_main.php ). Thanks for the help. H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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
slow MySQLGUI
My MySQLGUI running on a Windows system is invariably much slower(typically 30 seconds) than a MSAccess database with tables linked with MyODBC to the same Linux-hosted Mysql-database (typically less than 1 second) when executing the same query over a telephone internet connection. Why is that so? H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - 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