RE: MySQL 5.0.2-alpha-nt highly instable?

Is it just me or is the current Alpha build of MySQL 5.0 HIGHLY instable? 5.0.2 on Windows is completely unusable for me too; crashes constantly the Linux version seems to be fine, at least in my tests Michael Kofler -- MySQL General Mailing List For list archives: http://lists.mysql.com

timezones in 4.1/5.0

s not reported to the server. @@session.time_zone is SYSTEM (obviously wrong). This means: The time zone is not reported automatically, at least not in all cases. Thanks to all who can provide more insight into these topics! Michael Kofler, author of The Definitive Guide to MySQL (apress)

call stored procedure with PHP5 and get SELECT results

HP code above seems to be ok as long as I don't call a SP. $ok = $mysqli->multi_query("SELECT * FROM t1; SELECT * FROM t1"); Any ideas? Error in MySQL or in PHP? Thank you, Michael Kofler http://www.kofler.cc/ -- MySQL General Mailing List For list archives: http:

[ANN] Book: The Definitive Guide to MySQL, 2nd ed

I would like to announce the 2nd edition of The Definitive Guide to MySQL by Michael Kofler apress 2004 The book covers many aspects of MySQL application development, including - installation (Windows, Linux) - GUIs (MySQL Control Center, phpMyAdmin) - database design - SQL - security

documentation on new MySQL 4.1 features

lot, Michael Kofler (author of the book 'MySQL' published by Addison Wesley Germany / apress USA) http://www.kofler.cc/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.0.10: connection dies with SELECT @@not_a_global_variable

I am using MySQL 4.0.10 on Windows. If I process SELECT @@whatever (where whatever is not a valid global variable name), the connection is closed. Is this by design? Then it should be documented. Otherwise it is probably a bug. Best wishes, Michael Kofler http://www.kofler.cc

Re: Migrating from MS SQLserver to MySQL

try mssql2mysql; this is a VB/VBA script which can connect directly to MySQL, thus eliminating the need of temporary files http://www.kofler.cc/mysql/mssql2mysql.html Best wishes, Michael Kofler - Before posting, please

Re: Port MS SQL Database To MySQL ??

See: http://www.kofler.cc/mysql/mssql2mysql.html (converts schema + data, no SPs, no triggers, no views etc.; GPL) Best wishes, Michael Kofler - Before posting, please check: http://www.mysql.com/manual.php (the

problem with select ... in share mode

3.23.37: SELECT * FROM table1 WHERE colA=1 IN SHARE MODE does not work (ERROR 1064: You have an error in your SQL syntax near 'share mode' at line 1). On the other side SELECT * FROM table1 IN SHARE MODE does work, i.e. the syntax error only happens if I specify a WHERE clause or an OR

RE: Can you convert a MS Sql database to MySQL?

is free (GPL) Best wishes, Michael Kofler http://www.kofler.cc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

mysql not reading all options if started with -p

mysql is started without these options or if it is started with --password=xy this happens both on Linux and on Windows with 3.23.32 any ideas? thank you, Michael Kofler http://www.kofler.cc - Before posting, please check

announcement: mssql2mysql database converter

mssql2mysql converts Microsoft SQL Server databases to MySQL mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) for more informations see: http://www.kofler.cc/mysql/ Michael Kofler