Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?

On 2020-03-30 21:26, Wim Bertels wrote:
> Turritopsis Dohrnii Teo En Ming schreef op ma 30-03-2020 om 20:49
> [+0800]:
>> Good evening from Singapore,
>>
>> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
>
> Unfortunately mysql/mariadb syntax differs in general more than others
> dbms from the iso/ansi sql standard.
>
>>
>> Because I have never used PostgreSQL before.
>
> So you might have to adapt a bit when leaving mysql/mariadb for another
> dbms. To start development you should be ok,
> if you want to migrate data, you might want to use a migration tool (or
> fdw) (instead of dumping mysql syntax into postgresql)

I have had more exposure to MySQL/MariaDB in the past.

>
>>
>> I am looking forward to hearing from you soon.
>>
>> Thank you.
>>
>>
>>
>>
>>
>>
>>

>>
>>
> --
> mvg,
> Wim Bertels
> --
> Lector
> UC Leuven-Limburg
> --
> For years a secret shame destroyed my peace--
> I'd not read Eliot, Auden or MacNiece.
> But now I think a thought that brings me hope:
> Neither had Chaucer, Shakespeare, Milton, Pope.
> -- Justin Richardson.

-----BEGIN EMAIL SIGNATURE-----

The Gospel for all Targeted Individuals (TIs):

[The New York Times] Microwave Weapons Are Prime Suspect in Ills of
U.S. Embassy Workers

Link:
https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html

********************************************************************************************

Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic
Qualifications as at 14 Feb 2019 and refugee seeking attempts at the
United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan (5 Aug
2019) and Australia (25 Dec 2019 to 9 Jan 2020):

[1] https://tdtemcerts.wordpress.com/

[2] https://tdtemcerts.blogspot.sg/

[3] https://www.scribd.com/user/270125049/Teo-En-Ming

-----END EMAIL SIGNATURE-----