[DiscordArchive] This query is only possible in MySQL 8.x isn't it?
[DiscordArchive] This query is only possible in MySQL 8.x isn't it?
Original source
This query is only possible in MySQL 8.x isn't it?
```sql
SELECT * FROM `information_schema`.CHECK_CONSTRAINTS;
```
Does anyone know what is the query for 5.7?
rektbyfaith
06-07-2021, 06:58 PM #1Archived author: stevej • Posted: 2021-06-07T18:58:24.279000+00:00
Original source
This query is only possible in MySQL 8.x isn't it?
```sql
SELECT * FROM `information_schema`.CHECK_CONSTRAINTS;
```
Does anyone know what is the query for 5.7?
Original source
should be the same
rektbyfaith
06-07-2021, 07:07 PM #2Archived author: Kitzunu • Posted: 2021-06-07T19:07:28.990000+00:00
Original source
should be the same
Original source
I tried this on 5.7 and got:
`Error Code: 1109. Unknown table 'check_constraints' in information_schema`
rektbyfaith
06-07-2021, 07:11 PM #3Archived author: steen • Posted: 2021-06-07T19:11:55.130000+00:00
Original source
I tried this on 5.7 and got:
`Error Code: 1109. Unknown table 'check_constraints' in information_schema`
Original source
rektbyfaith
06-07-2021, 07:12 PM #4Archived author: stevej • Posted: 2021-06-07T19:12:20.205000+00:00
Original source
Original source
https://pangolp.github.io/estandares-de-sql.html
[Embed: El blog de Pango | Stevej]
En este artículo, traducido de la wiki oficial de AzerothCore, trataremos de abarcar, temas relacionados a las buenas prácticas del lenguaje SQL. Con ejemplos sobre las tablas del emulador, pero que pueden ser modificadas, para utilizadas en otras tablas.
https://pangolp.github.io/estandares-de-sql.html
rektbyfaith
06-07-2021, 07:12 PM #5Archived author: stevej • Posted: 2021-06-07T19:12:22.234000+00:00
Original source
https://pangolp.github.io/estandares-de-sql.html
[Embed: El blog de Pango | Stevej]
En este artículo, traducido de la wiki oficial de AzerothCore, trataremos de abarcar, temas relacionados a las buenas prácticas del lenguaje SQL. Con ejemplos sobre las tablas del emulador, pero que pueden ser modificadas, para utilizadas en otras tablas.
https://pangolp.github.io/estandares-de-sql.html
Original source
I did the translation of the document into Spanish.
And at the end, I found that query.
I was curious.
rektbyfaith
06-07-2021, 07:12 PM #6Archived author: stevej • Posted: 2021-06-07T19:12:48.724000+00:00
Original source
I did the translation of the document into Spanish.
And at the end, I found that query.
I was curious.
Original source
https://dev.mysql.com/doc/refman/5.7/en/...table.html
rektbyfaith
06-07-2021, 07:16 PM #7Archived author: stevej • Posted: 2021-06-07T19:16:54.751000+00:00
Original source
https://dev.mysql.com/doc/refman/5.7/en/...table.html
Original source
https://github.com/azerothcore/wiki/pull/523
[Embed: Update.md: Add step to upgrade to latest release before running DB ...]
Add a step to the 'How to update AzerothCore to the latest stable version' (Update.md) page to upgrade to latest release before running the DB Assembler tool
Motivation and Context
...
https://github.com/azerothcore/wiki/pull/523
rektbyfaith
06-07-2021, 07:28 PM #8Archived author: steen • Posted: 2021-06-07T19:28:16.071000+00:00
Original source
https://github.com/azerothcore/wiki/pull/523
[Embed: Update.md: Add step to upgrade to latest release before running DB ...]
Add a step to the 'How to update AzerothCore to the latest stable version' (Update.md) page to upgrade to latest release before running the DB Assembler tool
Motivation and Context
...
https://github.com/azerothcore/wiki/pull/523
Original source
try
```sql
SELECT * FROM `information_schema`.TABLE_CONSTRAINTS
``` for 5.7
rektbyfaith
06-07-2021, 07:52 PM #9Archived author: Kitzunu • Posted: 2021-06-07T19:52:46.394000+00:00
Original source
try
```sql
SELECT * FROM `information_schema`.TABLE_CONSTRAINTS
``` for 5.7
Original source
rektbyfaith
06-07-2021, 07:53 PM #10Archived author: stevej • Posted: 2021-06-07T19:53:18.485000+00:00
Original source
1 Guest(s)
1 Guest(s)