我新申请了一个，www.hotdoor.tk
mysql> select *from Debug
DebugId DebugParamConfig.PFramDetect DebugParamConfig.bDebugLogLevel
DebugParamConfig DebugParamConfig.PLightStatus DebugParamConfig.cameraid
DebugParamConfig.DebugId DebugParamConfig.PWirteRaw
mysql> select *from Debug
DebugId DebugParamConfig.PFramDetect DebugParamConfig.bDebugLogLevel
DebugParamConfig DebugParamConfig.PLightStatus DebugParamConfig.cameraid
DebugParamConfig.DebugId DebugParamConfig.PWirteRaw
mysql> select *from DebugParamConfig;
Empty set (0.00 sec)
mysql> select *from DebugParamConfig;
Empty set (0.00 sec)
mysql> select *from SerialConfig;
+----+--------------+--------+----------+----------+----------+-----------+-------+
| Id | SerialNumber | IsOpen | BaudRate | DataBits | StopBits | CheckBits | IsRed |
+----+--------------+--------+----------+----------+----------+-----------+-------+
| 1 | 1 | 0 | 9600 | 8 | 1 | 0 | 2 |
+----+--------------+--------+----------+----------+----------+-----------+-------+
1 row in set (0.00 sec)
mysql> update SerialConfig set IsOpen=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> desc DebugParamConfig;
+----------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+----------------+
| DebugId | int(10) | NO | PRI | NULL | auto_increment |
| cameraid | int(10) | YES | | NULL | |
| PLightStatus | tinyint(3) | YES | | 0 | |
| PFramDetect | tinyint(3) | YES | | 1 | |
| PWirteRaw | tinyint(3) | YES | | 0 | |
| bDebugLogLevel | tinyint(3) | YES | | 0 | |
+----------------+------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)
mysql> insert into DebugParamConfig values(1,2,1,1,1,1);
Query OK, 1 row affected (0.00 sec)
mysql> select *from GlobalSwitch;
ERROR 1146 (42S02): Table 'test.GlobalSwitch' doesn't exist
mysql> select *from GlobalSwitch
GlobalSwitchConfig GlobalSwitchConfig.cameraid
GlobalSwitchConfig.GlobalSwitchId GlobalSwitchConfig.capdisctrl
GlobalSwitchConfig.IsRed GlobalSwitchId
GlobalSwitchConfig.bVt
mysql> select *from GlobalSwitchConfig;
Empty set (0.00 sec)
mysql> desc GlobalSwitchConfig;
+----------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+----------------+
| GlobalSwitchId | int(10) | NO | PRI | NULL | auto_increment |
| cameraid | tinyint(3) | NO | | 2 | |
| IsRed | tinyint(3) | NO | | 2 | |
| bVt | tinyint(3) | NO | | 1 | |
| capdisctrl | int(10) | YES | | 100 | |
+----------------+------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> insert into GlobalSwitchConfig values(1,2,2,1,100);
Query OK, 1 row affected (0.00 sec)
mysql> exit;
Bye