requetes mysql

SELECT [options] items [INTO file_details] FROM tables [ WHERE conditions ] [ GROUPS BY group_type ] [ HAVING where_condition ] [ ORDER BY order_type DESC|ASC] [ LIMIT limit_criteria ] [ PROCEDURE proc_name(arguments)] [lock_options]


SELECT id FROM `PYTHONS` AS A WHERE 1 limit 0,25

SELECT id FROM `PYTHONS` AS A WHERE A.id<10 limit 0,25

SELECT A.id,B.id FROM `PYTHONS` AS A,`PYTHONS` AS B WHERE A.md5=B.md5 limit 0,25

SELECT A.id,B.id FROM `PYTHONS` AS A,`PYTHONS` AS B WHERE A.id!= B.id and A.md5=B.md5 limit 0,25

SELECT A.*,B.* FROM `PYTHONS` AS A,`PYTHONS` AS B WHERE A.id!= B.id and A.md5=B.md5 limit 0,25



Q:
SELECT A.id FROM `PYTHONS` AS A WHERE A.id>= ALL ( select id FROM PYTHONS) limit 0,25
R:
1 réponse 


Q:
SELECT A.id FROM `PYTHONS` AS A WHERE A.id> ANY ( select id FROM PYTHONS) limit 0,25
R:
TOTAL - 1 réponses


SELECT x,y,z FROM Points1 WHERE (x,y,z) in (SELECT x,y,z FROM Points2)

INSERT [INTO] table [(colonne1,colonne2,colonne3,...)] VALUES (valeur1,valeur2,valeur3,...)

INSERT INTO points (x,y,z) VALUES (8.5,5.6,-5.6)

UPDATE [LOW_PRIORITY] [IGNORE] nomtable SET colonne1=expression1,colonne2=expression2,... [WHERE condition] [ORDER BY critères de tri] [LIMITE nombre]

UPDATE homothetie set longueur=longueur * 1.5

UPDATE homothetie set longueur=longueur * 1.5 where id=5

UPDATE `BLENDERSpoub` SET `NomLong` = REPLACE(`NomLong`, '/media/a/Elements', '/media/a/E2/Elements') WHERE `NomLong` LIKE '%/media/a/Elements%' COLLATE utf8mb4_bin

CREATE DATABASE IF NOT EXISTS `basededonnee` ;

mysql --user=root --password=mdp  < mysqm avec mysqm:'CREATE DATABASE IF NOT EXISTS `basededonnee` ;'

CREATE USER 'nom'@'localhost' IDENTIFIED BY 'mdp';

GRANT SELECT,INSERT,UPDATE ON `basededonnee` . * TO 'nom'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT SELECT,INSERT,UPDATE ON micalaur.* TO basededonnee@localhost IDENTIFIED BY 'mdp';
GRANT ALL PRIVILEGES ON `nom` . * TO 'nom'@'localhost';

CREATE USER 'a09.gfsd'@'localhost' IDENTIFIED BY 'gfd456456j';
GRANT SELECT,INSERT,UPDATE ON `wind04.5` . * TO 'a04.5gfsd'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'nom'@'localhost' IDENTIFIED BY 'mdp';
GRANT SELECT,INSERT,UPDATE ON `basededonnee` . * TO 'nom'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'a09.gfsd'@'localhost' IDENTIFIED BY 'ljkljklhj';# MySQL a retourné un résultat vide (aucune ligne).
 GRANT SELECT,INSERT,UPDATE ON `wind09` . * TO 'a09.gfsd'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;# MySQL a retourné un résultat vide (aucune ligne).

INSERT INTO dossiersSecrets(titre, contenu) VALUES ('$titre', AES_ENCRYPT('AA','BB'));

SELECT titre, AES_DECRYPT(contenu,'motdepasse') AS contenu FROM dossiersSecrets;