select * from sqlite_sequence; this one in sqllite which can perform?

sqlite build sequence

Creating a self-energizing sequence, but was found to pass values ​​manually to save
create table user (_id int auto_increment primary key not null, username text, userpwd text);


Then manually transfer value is also OK, but how to get the sequence is a problem, sqlite behind this discovery is not supported relational database sequence, ah, this information can not actually search the Internet, is extremely surprising, then there are a few people say to use the phrase , select * from sqlite_sequence;

But I am here to report directly to:

sqlite> select * from sqlite_sequence;
select * from sqlite_sequence;
Error: no such table: sqlite_sequence
sqlite>

This in the end is how it happened?
<-! Main posts under Banner (D4) -><-! Posts under the main text (D5) ->
Reply:
You should also look-up table is a user ah
Reply:
I want to use a sequence, and then they told me to go check sequence, not a look-up table
Reply:
select * from sqlite_sequence;
Personally feel that this is not a lookup table sql command it? , Sqlite_sequence be interpreted into the table name
Another brother, you say take the sequence mean?
Reply:
Brother, you've the right to use oracle, sqlite in no sequence, your table has been automatically increased,
Does not provide _id when inserting data values ​​automatically increase the value of the offer will provide you with the
For example:
insert into user (username, userpwd) values ​​('tom', 'pass')
Such _id value is the automatic growth.

insert into user (_id, username, userpwd) values ​​(10, 'tom', 'pass')
Such _id values ​​that you provide 10 a.
Reply:
In addition, _id column defined as integer primary key recommendations
Reply:

references, 4th Floor zhanfaquan reply:

brother, you've the right to use oracle, sqlite in no sequence, your table has been automatically increased,
Does not provide _id when inserting data values ​​automatically increase the value of the offer will provide you with the
For example:
insert into user (username, userpwd) values ​​('tom', 'pass')
Such _id value is the automatic growth.

insert into user (_id, username, userpwd) values ​​(10, 'tom', 'pass')
Such _id values ​​that you provide 10 a.

oracle is it so
Reply:
Clothes! How could the same oracle and sql
Reply:
Wood is wrong, I have been using the oracle, hey

New to sqlite, thank you
Reply:

reference to the third floor u011133213 reply:

select * from sqlite_sequence;
Personally feel that this is not a lookup table sql command it? , Sqlite_sequence be interpreted into the table name
Another brother, you say take the sequence mean?

sequence is the sequence ah, an automatic increase of the value of database management database objects