Test Data Management
- Test Data Management 10.5.1
- Tous les produits
Requête
| Exemple de syntaxe
|
---|---|
SELECT *
| SELECT * FROM <table_name>;
|
SELECT
| SELECT <column_name>,<column_name> FROM <table_name>;
|
SELECT
| SELECT <column_name> AS <alias_name> FROM <table_name>;
|
INSERT INTO
| INSERT INTO <table_name> (column1,column2,column3) VALUES (value1,value2,value3);
Vous devez entrer les noms de colonnes. Vous ne pouvez pas exécuter la requête sans les noms de colonnes :
|
UPDATE
| UPDATE <table_name> SET column1=value1,column2=value2
|
DELETE FROM
| DELETE FROM table_name WHERE <column_name>=<value>;
|
DELETE FROM
| DELETE FROM table_name;
Supprime toutes les données de la table.
|