pense-bête de bruno sanchiz

Accueil > Programmation > mysql - mariadb > requetes mysql

requetes mysql

Publié le 24 avril 2018, dernière mise-à-jour le 30 septembre 2023, 10 visites, 23089 visites totales.

fonctions

  • https://mariadb.com/kb/fr/concat/
  • concat ( chaine1, chaine2)
    • ex : update <span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+cGhvdG9zPC9jb2RlPg=="></span> set <span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+Z3JvdXBlPC9jb2RlPg=="></span>=concat(<span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+Z3JvdXBlPC9jb2RlPg=="></span>,'animaux')
  • concat_ws ( separateur,chaine1, chaine2)
    • ex :
      update <span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+ZXNzYWk8L2NvZGU+"></span> set <span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+dmlzaXRlczwvY29kZT4="></span>=concat_ws(",",<span class="base64" title="PGNvZGUgY2xhc3M9InNwaXBfY29kZSBzcGlwX2NvZGVfaW5saW5lIiBkaXI9Imx0ciI+dmlzaXRlczwvY29kZT4="></span>,'animaux');
  • https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html

  • INSERT
    • INSERT [INTO] table [(colonne1,colonne2,colonne3,...)] VALUES (valeur1,valeur2,valeur3,...)
    • on peut rajouter ON DUPLICATE KEY UPDATE
  • SELECT
    • 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]
  • UPDATE
    • UPDATE [LOW_PRIORITY] [IGNORE] nomtable SET colonne1=expression1,colonne2=expression2,... [WHERE condition] [ORDER BY critères de tri] [LIMITE nombre]
  • ALTER TABLE
  • CREATE DATABASE
  • CREATE USER / GRANT

SELECT


INSERT


UPDATE


CREATE DATABASE


CREATE USER

chiffrage des données

[bruno sanchiz]