Re: Is my MySQL Gaining ?

On Sun, Dec 28, 2003 at 02:42:20AM -0500, Casey Allen Shobe wrote:
> D. Dante Lorenso (Sunday 28 December 2003 00:45)
> > The only SQL customizations that MySQL has that I really miss in PostgreSQL
> > are the commands:
> >
> > SHOW DATABASES;
> > SHOW TABLES;
> > DESC table;
>
> I agree here. Similarly, one of the things I miss most from DB2 is 'LIST
> TABLES'. I don't have any problem at all remembering \commands - the only
> problem is, as you described, that they are unique to psql.

Yes, they do vary, there is no stardard. As you point out, DB2 and MySQL use
different commands, as does probably every other database. There is no
command that is going to work everywhere.

> One of the things I miss most from MSSQL is the ability to use variables.
> Supposedly MySQL has this ability as well. I can come up with a very good
> reason if you want to hear it ;-).

psql has variables, though I can't comment on how they compare to MSSQL's.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce