When you create a database table using Sqlite3, you need to be aware

When you create a database table using Sqlite3, you need to be aware that:

1. Cannot use pure digital

2. Cannot have characters such as "-", "@". It cannot begin with a number.

One, the following is the message log out:

DB error:1 "Unrecognized token:" 47464636265757265763393573649 ""

DB Query:insert into 47464636265757265763393573649 (role,number,name) VALUES (?,?,?)

In fact, I would like to use 47464636265757265763393573649 as an indication that in fact it is not possible.cannot be a purely numeric

Second, the following log, I want to use the date as the table name.

DB error:1 "near": Syntax Error "

DB Query:insert into 2014-11-01-02:18:0054 (role,number,name) VALUES (?,?,?)

stating "-" It's not going to work.

Three, the following log, I want to use the URI as the table name:

DB error:1 "near": Chat0015453d2792ef ": Syntax Error"

DB Query:insert into Sip:[email protected] (role,number,name) VALUES (?,?,?)

That means @ is not going to work.

It is possible that the bottom of the sqlite3 is to program the table name as the class name. Because table naming rules are the same as the rules for variables

When you create a database table using Sqlite3, you need to be aware