REPLACE(str,from_str,to_str)
Возвращает строку str, в которой все вхождения строки from_str заменены на
to_str:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , REFERENCES , INDEX
, ALTER , CREATE TEMPORARY TABLES ON eoby . * TO "geoby"@"localhost";
[10:24] <dragon@hq.central.office> GRANT тип-привилегии [(список-столбцов)]
[, тип-привилегии [(список-столбцов)] ...] ON { имя-таблицы | * | *.* |
имя-БД.* } TO имя-пользователя [ IDENTIFIED BY 'пароль' ] [,
имя-пользователя [ IDENTIFIED BY 'пароль ] ... ] WITH GRANT OPTION
[10:26] <dragon@hq.central.office> mysql> GRANT ALL PRIVILEGES ON *.* TO
ferst@localhost IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO ferst@"%" IDENTIFIED BY 'some_pass'
WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO doom@localhost;
[10:26] <dragon@hq.central.office> mysql> INSERT INTO user VALUES
('localhost','ferst',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y',
'Y','Y','Y','Y','Y','Y','Y');
mysql> INSERT INTO user
VALUES('%','ferst',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y',
'Y','Y','Y','Y','Y','Y','Y');
mysql> INSERT INTO user SET Host:'localhost',User:'admin',Reload_priv:'Y',
Process_priv: 'Y';
mysql> INSERT INTO user(Host, User,Password) VALUES('localhost','doom','');
mysql> FLUSH PRIVILEGES;
Киевская городская библиотека
собрана Максимом Мошковым
