mysql
On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 16:54:29 | +---------------------+ 1 row in set (0.00 sec) On another server: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 20:01:43 | +---------------------+ 1 row in set (0.00 sec) And it'
database
今天在測試資料庫刪除資料時，發現了一件事 在有被其他資料表 Reference 成 Foreign Key 的情況下刪除資料時資料庫會發出： Cannot delete or update a parent row: a foreign key constraint fails 後來才發現在建立資料庫時，如果不會自己的 Foreign Key 設定動作的話，資料庫預設是不會做連動的更改( NO ACTION )。 ————————————– CREATE TABLE parent( id INT NOT NULL, PRIMARY KEY (id) ) TYPE = INNODB; CREATE TABLE child( id INT, parent_id INT, INDEX par_
configuration
so do the following edit my.cnf: [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = xxx.xxx.xxx.xxx # skip-networking after edit hit service mysqld restart after
mysql
Notice: Undefined variable: content in E:\Server\vhosts\www.lvtao.net\libs\template.core.php on line 557 进入网站会出现大量类似下面的提示，但是可以正常显示和运行 Notice: Use of undefined constant ctbTitle – assumed 'ctbTitle' in d:\ctb1.5\ctb\include\config.php on line 23… 答案：这些是 PHP 的提示而非报错，PHP 本身不需要事先声明变量即可直接使用，但是对未声明变量会有提示。一般作为正式的网站会把提示关掉的，甚至连错误信息也被关掉
md5
Well, there have been a fuss around the globe regarding the user data. And how well we had done to protect their interest on our side. Online forum, portal.. and all sort of password-required to access. Should really not put the password on the plaintext on MySQL table or even