| 0 |
0 |
SET NAMES utf8mb4 |
| 1 |
-1 |
SELECT * FROM `v2_rule` |
| 2 |
1 |
SELECT COUNT(*) nb FROM `v2_user` WHERE `name` = Non connecté |
| 3 |
-1 |
SELECT
-- k.CONSTRAINT_SCHEMA,
-- k.CONSTRAINT_NAME,
-- k.TABLE_NAME,
k.COLUMN_NAME,
-- k.REFERENCED_TABLE_SCHEMA,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS k
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c ON k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME
WHERE
c.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND k.REFERENCED_TABLE_SCHEMA = 'clubmangdy784595'
AND k.TABLE_NAME = 'v2_group'
|
| 4 |
-1 |
SELECT
-- k.CONSTRAINT_SCHEMA,
-- k.CONSTRAINT_NAME,
-- k.TABLE_NAME,
k.COLUMN_NAME,
-- k.REFERENCED_TABLE_SCHEMA,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS k
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c ON k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME
WHERE
c.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND k.REFERENCED_TABLE_SCHEMA = 'clubmangdy784595'
AND k.TABLE_NAME = 'v2_user_group'
|
| 5 |
2 |
SELECT reference FROM `v2_group` INNER JOIN `v2_user_group` ON `v2_group`.`id` = `v2_user_group`.`id_group` WHERE `id_user` = |
| 6 |
-1 |
SELECT
-- k.CONSTRAINT_SCHEMA,
-- k.CONSTRAINT_NAME,
-- k.TABLE_NAME,
k.COLUMN_NAME,
-- k.REFERENCED_TABLE_SCHEMA,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS k
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c ON k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME
WHERE
c.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND k.REFERENCED_TABLE_SCHEMA = 'clubmangdy784595'
AND k.TABLE_NAME = 'v2_group'
|
| 7 |
-1 |
SELECT
-- k.CONSTRAINT_SCHEMA,
-- k.CONSTRAINT_NAME,
-- k.TABLE_NAME,
k.COLUMN_NAME,
-- k.REFERENCED_TABLE_SCHEMA,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS k
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c ON k.CONSTRAINT_SCHEMA = c.CONSTRAINT_SCHEMA
AND k.CONSTRAINT_NAME = c.CONSTRAINT_NAME
WHERE
c.CONSTRAINT_TYPE = 'FOREIGN KEY'
AND k.REFERENCED_TABLE_SCHEMA = 'clubmangdy784595'
AND k.TABLE_NAME = 'v2_user_group'
|
| 8 |
0 |
SELECT reference FROM `v2_group` INNER JOIN `v2_user_group` ON `v2_group`.`id` = `v2_user_group`.`id_group` WHERE `id_user` = |
