\u7a81\u7136\u3067\u3059\u304c\u3001epgrec\u3067\u5feb\u8abf\u306b\u9332\u753b\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u7a81\u7136
\n\u9332\u753b\u6e08\u4e00\u89a7\u753b\u9762\u304c\u3001\u4e0b\u8a18\u30b3\u30e1\u30f3\u30c8\u3067\u53c2\u7167\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002
\nconstruct:Recorder_categoryTbl\u306bid=0\u306f\u3042\u308a\u307e\u305b\u3093
\n\u4ee5\u4e0b\u4fee\u5fa9\u8a18\u9332\u3067\u3059\u304c\u3001\u7d50\u5c40epgrec\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u308a\u76f4\u3057\u307e\u3057\u305f\u3002
\n\u539f\u56e0\u8abf\u67fb\u3067\u3059\u304c\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff06\u30c6\u30fc\u30d6\u30eb\u306f\u3061\u3083\u3093\u3068\u3042\u308a\u307e\u3057\u305f\u3057
\n-----------------------------------------------
\njose@jose-desktop:~$ mysql -u epgrec -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 489
\nServer version: 5.5.41-0ubuntu0.12.04.1 (Ubuntu)
\nCopyright (c) 2000, 2014, Oracle and\/or its affiliates. All rights reserved.
\nOracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.
\nType ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.
\nmysql> show databases;
\n+--------------------+
\n| Database |
\n+--------------------+
\n| information_schema |
\n| epgrec |
\n+--------------------+
\n2 rows in set (0.17 sec)
\nmysql> use epgrec;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A
\nDatabase changed
\nmysql> show tables;
\n+----------------------+
\n| Tables_in_epgrec |
\n+----------------------+
\n| Recorder_categoryTbl |
\n| Recorder_channelTbl |
\n| Recorder_keywordTbl |
\n| Recorder_logTbl |
\n| Recorder_programTbl |
\n| Recorder_reserveTbl |
\n+----------------------+
\n6 rows in set (0.00 sec)
\n\u30c6\u30fc\u30d6\u30eb\u306e\u30c1\u30a7\u30c3\u30af\u3068\u4fee\u5fa9\u3092\u8a66\u307f\u307e\u3057\u305f\u304c
\nmysql> check table Recorder_categoryTbl;
\n+-----------------------------+--------+----------+----------+
\n| Table | Op | Msg_type | Msg_text |
\n+--------------------- -------+--------+----------+----------+
\n| pt2_db.Recorder_categoryTbl | repair | status | OK |
\n+---------------------- ------+--------+----------+----------+
\n1 row in set (1.24 sec)
\nok\u306e\u3088\u3046\u3067\u3059
\n\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3067id=0\u304c\u3069\u3053\u306b\u884c\u3063\u3066\u308b\u306e\u304b\u63a2\u3057\u3066\u307f\u307e\u3057\u305f\u304c
\n\u3042\u308a\u307e\u305b\u3093\u3057\u3001id=0\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u30a4\u30f3\u30b5\u30fc\u30c8\u3057\u3066\u307f\u307e\u3057\u305f\u304c
\n\u6700\u7d42\u30ec\u30b3\u30fc\u30c9\u4ee5\u964d\u306b\u8ffd\u52a0\u3055\u308c\u308b\u3060\u3051\u3067id=0\u306f\u51fa\u6765\u307e\u305b\u3093\u3002
\nmysql> select id from Recorder_categoryTbl where id = 1;
\n+----+
\n| id |
\n+----+
\n| 1 |
\n+----+
\n1 row in set (0.02 sec)
\nmysql> insert into Recorder_categoryTbl(id) values(0);Query OK, 1 row affected (0.01 sec)
\nmysql> select id name_jp from Recorder_categoryTbl where id < 5;\n+---------+\n| name_jp |\n+---------+\n| 1 |\n| 2 |\n| 3 |\n| 4 |\n+---------+\n4 rows in set (0.01 sec)\nmysql> select id name_jp from Recorder_categoryTbl where id ;
\n+---------+
\n| name_jp |
\n+---------+
\n| 1 |
\n| 2 |
\n| 3 |
\n| 4 |
\n| 5 |
\n| 6 |
\n| 7 |
\n| 8 |
\n| 9 |
\n| 10 |
\n+---------+
\n10 rows in set (0.00 sec)
\nmysql> delete from Recorder_categoryTbl where id = 9;
\nQuery OK, 1 row affected (0.00 sec)
\nmysql> insert into Recorder_categoryTbl(id) values(0);
\nQuery OK, 1 row affected (0.00 sec)
\n\u7d50\u5c40epgrec\u306eDB\u304c\u58ca\u308c\u305f\u3068\u5224\u65ad\u3057\u3066\u4f5c\u308a\u76f4\u3057\u307e\u3057\u305f
\n$ mysql -u -root -p
\nmysql>drop database epg;
\nmysql>create database epg;
\nmysql>grant all privileges on *.* to [username]@localhost identified by ‘[Password]’;
\nmysql>exit;
\n\u2193\u3092\u5b9f\u884c
\nhttp:\/\/\u30db\u30b9\u30c8\u540d\/epgrec\/install\/step1.php
\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4fee\u5fa9\u5f8c\u306b\u6b63\u5e38\u72b6\u614b\u306b\u623b\u3063\u305f\u306e\u3092\u78ba\u8a8d\u3057\u3066DB\u3068\u30c6\u30fc\u30d6\u30eb\u3092\u30c1\u30a7\u30c3\u30af\u3057\u307e\u3057\u305f\u304c\u3001
\nid=0\u306f\u7d50\u5c40\u7121\u3044\u3088\u3046\u3067\u3059\uff1f\uff1f
\nmysql> use epgrec;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A
\nDatabase changed
\nmysql> show tables;
\n+----------------------+
\n| Tables_in_epgrec |
\n+----------------------+
\n| Recorder_categoryTbl |
\n| Recorder_channelTbl |
\n| Recorder_keywordTbl |
\n| Recorder_logTbl |
\n| Recorder_programTbl |
\n| Recorder_reserveTbl |
\n+----------------------+
\n6 rows in set (0.00 sec)
\nmysql> select id name_jp from Recorder_categoryTbl where id ;
\n+---------+
\n| name_jp |
\n+---------+
\n| 1 |
\n| 2 |
\n| 3 |
\n| 4 |
\n| 5 |
\n| 6 |
\n| 7 |
\n| 8 |
\n| 9 |
\n+---------+
\n9 rows in set (0.00 sec)
\nmysql>
\n\u7d50\u5c40\u539f\u56e0\u306f\u4e0d\u660e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u7a81\u7136\u3067\u3059\u304c\u3001epgrec\u3067\u5feb\u8abf\u306b\u9332\u753b\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u7a81\u7136 \u9332\u753b\u6e08\u4e00\u89a7\u753b\u9762\u304c\u3001\u4e0b\u8a18\u30b3\u30e1\u30f3\u30c8\u3067\u53c2\u7167\u3067\u304d\u306a\u304f\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3057\u305f\u3002 construct:Recorder_categoryTbl\u306bid=0\u306f\u3042\u308a\u307e\u305b\u3093 \u4ee5\u4e0b\u4fee\u5fa9\u8a18 … <\/p>\n