Hi,
Congratulation to MySQL for a two pages article published by the leading
business journal in Germany (Wirtschaftswoche).
Sorry, no online resource available only a headline
http://www.wiwo.de (German language)
sql, mysql
Andreas Karl Wittwer
I'm not related to wiwo in any case, just
;
++
| Tables_in_test |
++
| 123|
2 days of work wasted here!!
2 minutes to test all kin of quotes :-)
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
SQL, DATABASE, MYSQL
|
+--++
|1 | no |
+--++
1 row in set (0.00 sec)
mysql SELECT VERSION();
+-+
| VERSION() |
+-+
| 3.23.37-log |
+-+
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
),(NULL,2);
INSERT INTO tmp (id,c1) VALUES(NULL,3),(NULL,4);
SELECT * FROM tmp;
^Z
1 Datei(en) kopiert.
C:\mysql\binmysql upd.sql
id c1
1 1
2 2
3 3
4 4
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
and you
do a
CREATE TABLE ... TYPE=INNODB
the table is 'silently' create as (i guess) MyISAM.
No warnings, errors or hints ...
Is this WAD?
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
or in other words:
if something is nothing nothing can't be nothing because nothing is 'something' ;-)
Think about it, it's some kind of philosophy :-)
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
Andreas Karl Wittwer
Phone: +49-7052-92206
FAX: +49-7052-92208
Mobil: +49-172-542 541 4
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com