пятница, 2 августа 2013 г.

MySQL main comands

select * from mysql.user;

INSERT INTO `isys_mandator` ( `isys_mandator__id` , `isys_mandator__title`)
UPDATE t1 SET col1 = col1 + 1;

mysql> SHOW COLUMNS FROM City;
SHOW COLUMNS FROM mytable FROM mydb;
SHOW COLUMNS FROM mydb.mytable;

SHOW GRANTS FOR 'admin'@'localhost';

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost';
GRANT USAGE ON *.* TO 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90;

GRANT ALL ON *.* TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON *.* TO 'someuser'@'somehost';


Комментариев нет:

Отправить комментарий