01/25: MySQL > ROOTと同じユーザを作る
MySQLクイック・リファレンス
mysql> GRANT ALL PRIVILEGES ON *.* TO user1@"%"
-> IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO user1@localhost
-> IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
01/23: Delphi for PHP
01/23: excel indirect index
01/22: Mysql debug
01/22: 秒間隔でコマンドを繰り返し実行し続ける
秒間隔でコマンドを繰り返し実行し続ける
$ while true; do date; netstat -i; sleep 1; clear; done;
$ watch --interval 1 date
$ while true; do date; netstat -i; sleep 1; clear; done;
$ watch --interval 1 date
01/21: autocomplete="off"
01/14: MySQL > Joins and Subqueries
Types of Subqueries
Scalar subqueires return a single value.
Row subqueries return a single row.
Colulmn subqueires return a single column.
Table subqueires return a result set.
Multiple table UPDATE and DELETE statements
UPDATE t1, t2 SET t1.name = t2.name WHERE t1.id = t2.id;
DELETE t1 FROM t1, t2 WHERE t1.id = t2.id;
DELETE FROM t1 USING t1, t2 WHERE t1.id = t2.id;
The ODER BY and LIMIT clauses are not allowed for multiple table UPDATE and DELETE statements.
Using ALL, ANY, and SOME
SELECT Name, Population FROM Country WHERE Population < ALL (SELECT AVG(Population) FROM Country GROUP BY Continent) ORDER BY Name;
ANY and SOME may be equivalent to IN except IN can't be combined with any comparison operators such as '=' or '><'.
NOT IN is an alias of '>< ALL'.
Comparison Using Row Subqueries
The row subquery must return a single row.
SELECT City.Name FROM City WHERE [ROW](City.ID, City.CountryCode) = (SELECT Capital, Code FROM Country WHERE Name='Finland');
* ROW is optional.
Row constructors can be used only for equality comparison using the = operator.
Scalar subqueires return a single value.
Row subqueries return a single row.
Colulmn subqueires return a single column.
Table subqueires return a result set.
Multiple table UPDATE and DELETE statements
UPDATE t1, t2 SET t1.name = t2.name WHERE t1.id = t2.id;
DELETE t1 FROM t1, t2 WHERE t1.id = t2.id;
DELETE FROM t1 USING t1, t2 WHERE t1.id = t2.id;
The ODER BY and LIMIT clauses are not allowed for multiple table UPDATE and DELETE statements.
Using ALL, ANY, and SOME
SELECT Name, Population FROM Country WHERE Population < ALL (SELECT AVG(Population) FROM Country GROUP BY Continent) ORDER BY Name;
ANY and SOME may be equivalent to IN except IN can't be combined with any comparison operators such as '=' or '><'.
NOT IN is an alias of '>< ALL'.
Comparison Using Row Subqueries
The row subquery must return a single row.
SELECT City.Name FROM City WHERE [ROW](City.ID, City.CountryCode) = (SELECT Capital, Code FROM Country WHERE Name='Finland');
* ROW is optional.
Row constructors can be used only for equality comparison using the = operator.
01/14: VMware仮想ディスクの拡張
VMware仮想ディスクの拡張 - Ogawa::Memoranda
VMwareの仮想ディスクを拡大するには
/usr/sbin/vmkfstools -i win2k3std.vmdk win2k3stdx.vmdk
VMwareの仮想ディスクを拡大するには
/usr/sbin/vmkfstools -i win2k3std.vmdk win2k3stdx.vmdk
01/11: Apache LDAP
01/09: Regular Expressions
SpeedGuide.net :: Windows 2k/XP Tweaks
Automatic Updates Computer Browser Error Reporting Service Help and Support Indexing Service Messenger (pop-up spam vulnerability) NetMeeting Remote Desktop Sharing Performance Logs and Alerts Protected storage (stores passwords and enables ato-complete) Remote Registry (remote access to your registry) Routing and Remote Access (enables dial-in routing to your computer) Secondary Logon Task Scheduler
01/04: IPVS keepalived
1. Install becomeroot http://eko.one.pl/maemo/dists/mistral/user/binary-armel/becomeroot_0.1-2_armel.deb 2. Copy Japanese ttf fonts into /usr/share/fonts then fc-cache -fv /usr/share/fonts FM Radio is already the installable application list. Set up phone connection (Bluetooth) Create a packet data connection: Access point name: 3netaccess Dial-up number: *99# User name: (blank) Password: (blank)
Sidebar
