Created
September 22, 2020 09:20
-
-
Save Djaxis/92a42573a5f7e3ff53534507ba7b7da6 to your computer and use it in GitHub Desktop.
MYSQL MODIFIER SUPPRIMER DES CHAMPS ET ID
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE school | |
SET capacity = 700 | |
WHERE ID = 7 | |
# SUPPRIMER TOUS LES CHAMPS/LIGNES CONTENANT UNE VALEUR | |
DELETE FROM school | |
WHERE name | |
LIKE '%magic%' | |
# MODIFIER UN UNE VALEUR DANS UN CHAMP | |
UPDATE school #TABLE | |
SET country = 'Sweden' #COLONNE + VALEUR | |
WHERE ID = '3' #LIGNE ID | |
DESCRIBE school; |
Author
Djaxis
commented
Sep 22, 2020
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment