1. Download the SQLite database:http://www.sqlite.org/download.html If you are installing on a window you need to be in the windows Zone to download the precompiled binaries. Download download Sqlite-shell-win32-*.zip and
When using sqlite3 to create database tables, note that the sqlite3 Database
Note the following when using sqlite3 to create a database table:
1. Cannot use pure numbers
2. It cannot contain "-", "@", and other characters. Cannot start with a number.
When you learn that Django performs manage.py Dbshell on a book, "' Sqlite3 ' is not an internal or external command, or a program or batch file that can be run. ”This means that there is no "sqlite3" in the environment variable.I'm using python2.7,
When you create a database table using Sqlite3, you need to be aware that:1. Cannot use pure digital2. Cannot have characters such as "-", "@". It cannot begin with a number.One, the following is the message log out:DB error:1 "Unrecognized token:" 4
When you create a database table using Sqlite3, you need to be aware that:1. Cannot use pure digital2. Cannot have characters such as "-", "@". It cannot begin with a number.One, the following is the log information:DB error:1 "Unrecognized token:" 4
Recently used Python to write a crawler, the beginning of the 3.4, very hard to write, but in the runtime often stop working, after reducing the number of threads (16->8), stability has improved, but still occasionally there is a problem of stop
Sqlite Study Notes 2: Create a database and sqlite Study Notes
In the last note, an sqlite executable file is generated, and cd is executed under the directory where sqlite is located:
Sqlite3 MyDataBase. db
A database named MyDataBase. db is
Import MySQL
We can import the SQLite library with a simple statement, assuming that LUA is properly implemented and completed. During the installation process, the folder Libsql contains database-related files.
Copy Code code as follows:
This article mainly introduces the use of MySQL in the LUA program tutorial, is the basic knowledge of LUA learning, need friends can refer to the
Import MySQL
We can import the SQLite library with a simple statement, assuming that LUA is properly
Create a table in the current database
create table person(id integer,name Text);
Insert two data entries
insert into person values(1,"zhangsan");insert into person values(2,"lisi");
View the current database content
select * from person;
1 |
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.