|
Written by Willy Gerber
|
|
Friday, 11 March 2011 11:07 |
| Action | Commandos | | Administration | | Changing MySQL root user password using MySQL sql command | mysql> use mysql;
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='USER';
mysql> flush privileges; | | Action on Data | | Select | SELECT column_names FROM table_name | | Select without repetition | SELECT DISTINCT column_names FROM table_name | | Select with condition | SELECT column_names FROM table_name WHERE column_name operator value
=,<>,>,<,>=,<=,BETWEEN,LIKE,IN | | Multiple Conditions | condition_1 AND condition_2
condition_1 OR condition_2 | | Multiple Tables | tables: table1 AS t1, table2 AS t2, ...
column_names: t1.column1, t2.column2, ... | | Order | ORDER BY column_names (ASC or DESC) | | Insert all columns | INSERT INTO table_name
VALUES (value1, value2, value3,...) | | Insert select columns | INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...) | | Update | UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value | | Delete | DELETE FROM table_name
WHERE some_column=some_value |
MySQL
|
MySQL
