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

From: Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
To: Turritopsis Dohrnii Teo En Ming <ceo(at)teo-en-ming(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?
Date: 2020-03-30 13:26:11
Message-ID: d1903dcbe4ce4533b95325b4cb29a49cfe51dfff.camel@ucll.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 am looking forward to hearing from you soon.
>
> Thank you.
>
>
>
>
>
>
>
> -----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://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nytimes.com%2F2018%2F09%2F01%2Fscience%2Fsonic-attack-cuba-microwave.html&amp;data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&amp;sdata=jjYYIaR9%2BT%2Bn5ZnZ10asrNYy29%2FOH1diXRa%2Fz73%2FeCc%3D&amp;reserved=0
>
> *********************************************************************
> ***********************
>
> 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://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftdtemcerts.wordpress.com%2F&amp;data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&amp;sdata=7y%2F8jlQS2YBeXw%2BZ6114Adl7Vsh73teL8PmNWZd%2Fc8s%3D&amp;reserved=0
>
> [2]
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftdtemcerts.blogspot.sg%2F&amp;data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&amp;sdata=Z70%2BW5Q7OUXswXw5j4Lt85W2DyLSycu8d4FCc1s8pq8%3D&amp;reserved=0
>
> [3]
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.scribd.com%2Fuser%2F270125049%2FTeo-En-Ming&amp;data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&amp;sdata=Ug%2BqnOPc5bB4g1LrECXLIz8EOUKlvdDXF10%2BcUTfxTI%3D&amp;reserved=0
>
> -----END EMAIL SIGNATURE-----
>
>
--
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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-03-30 14:59:04 Re: Uploading existing shapefile from geoserver to postgresql
Previous Message Pavel Stehule 2020-03-30 13:07:33 Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?