-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Benjamin, et al --
...and then Benjamin Pflugmann said... % % Hi again. And again :-) % % On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote: % > ...and then Benjamin Pflugmann said... % [...] % > % Of course, that's only possible if you can live with being % > % MySQL-specific. % > % > Hmmm... so it's a mysql thing and not a SQL thing. Well, I'd like to % > avoid that, even though I like mysql... % % Well, setting up a database (or updating it) is always very % vendor-specific, isn't it? Well, yeah, but I want to try to write portable code; just because I like mysql doesn't meant that my customer (or some future contract employer) will... % % % Besides, I have yet to see production-level SQL that works on several % databases without change (except for stuff that is developed that That's my general goal, though I hardly know enough to know what's specific versus standard [yet]. % way). The problem is that the SQL standard is too unspecific in some Ahhh... % areas and the vendors have to fill in the details and it becomes a % PITA to work without the vendor-specific features. Yeah. Well, mysql, postgresql, and oracle are enough for me; now I only have to become expert, or even fluent, in three. Ha ha :-) % % IMHO, the most common example is the lack of sequence support. % AUTO_INCREMENT is MySQL-specific. To be portable you have to simulate Oops! :-) % sequences yourself, which is possible, but you won't do except if you % *know* you will need to run on a different RDBMS later. Yeah. Well, or if you plan to be able to run on one later... % % More info here: % % http://www.mysql.com/doc/en/Compatibility.html % % % > Thanks & HAND & HH % ^^^^ % % Hehe. I wondered about the non-abbriviation in your first mail % already. ;-) *grin* I figure the first one in the thread will define it for later since it's not too standard... :-) % % HTH, % % Benjamin. % % % -- % [EMAIL PROTECTED] Thanks again & HAND & HH mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EYVJGb7uCXufRwARAuwYAKDCffmOYnUM2G81hel5l9vLOoShqwCeOhzz /sb2qzOkmS0TYBUCwsSFW3E= =/oTU -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
