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')
- ex :
- 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');
- ex :
- 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