Wordpress 地址和站点地址
15 Mar 2015
mysql> describe wp_options;
+--------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+----------------+
| option_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| option_name | varchar(64) | NO | UNI | | |
| option_value | longtext | NO | | NULL | |
| autoload | varchar(20) | NO | | yes | |
+--------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
mysql> select * from wp_options where option_name=siteurl;
ERROR 1054 (42S22): Unknown column 'siteurl' in 'where clause'
mysql> select * from wp_options where option_name="siteurl";
+-----------+-------------+-------------------+----------+
| option_id | option_name | option_value | autoload |
+-----------+-------------+-------------------+----------+
| 1 | siteurl | http://vgeez.com/ | yes |
+-----------+-------------+-------------------+----------+
1 row in set (0.00 sec)
mysql> select * from wp_options where option_name="home";
+-----------+-------------+------------------+----------+
| option_id | option_name | option_value | autoload |
+-----------+-------------+------------------+----------+
| 36 | home | http://vgeez.com | yes |
+-----------+-------------+------------------+----------+
1 row in set (0.00 sec)