###
MEMENTO :
###

SHOW DATABASES;

USE myDatabase;

SHOW TABLE FROM myDatabase;

SHOW COLUMNS FROM myDatabase.myTable;   # si on a pas utilise USE myDatabase;
or
SHOW COLUMNS FROM myTable;

SELECT * FROM myDatabase.myTable;				# si on a pas utilise USE myDatabase;
or
SELECT * FROM myTable;

DELETE FROM myTable WHERE id=2;

ALTER TABLE myTable RENAME myDatabase.myTable;

INSERT INTO myTable(id, myName, myEmail, tel) VALUES('','tata', 'tata@tata.fr','0600000002');

UPDATE myTable SET myname = toto2 WHERE id = 2;		//	 sans WHERE TOUT les myName changent !

ALTER TABLE myTable AUTO_INCREMENT=0;

CREATE TABLE myTable (id INT KEY AUTO_INCREMENT, name VARCHAR(100));

DROP TABLE myTable;

SELECT password FROM myTable WHERE myil='toto@toto.fr';

Cloner une table :
CREATE TABLE tableClonee LIKE tableSource ;
INSERT INTO tableClonee SELECT * FROM tableSource ;

Changer le type de champs du colonne :
ALTER TABLE `myTable` CHANGE `myChamp` `myChamp` TEXT;

ALTER TABLE myTable ADD mycolonne VARCHAR;


Vider un champ :
UPDATE myTable SET monmychamps = null;

vide une table en gardant les colonnes sans leur contenu :
TRUNCAT myTable;
--

mysqldump -u root -p myDatabase > myDatabasemybackup.sql

mysqldump -u root -p myDatabase myTable > myTable.sql

mysql -u root -p myDatabase < myDatabasemybackup.sql

--

mynque :
-changer l'ordre des columns