SQLite3.exe, this cargo was dead right, that the goods dead yet, this stock is dead?

            


Database SQLite
want to see how the operation ADV
I put a Eclpise launched by ADV, and then double-click sqlie3.exe put a stuff to start up.

I guess this cargo, sqlite3.exe, is the legendary SQLite client, right?

However, no matter what I input sql language, which are related to the goods as dead ah, see figure it, only a few basic commands can be used SQLite comes as .database something, but it is also empty

They kept giving me look ...- & gt ;, ...- & gt; I lost what SQL did not respond ah,

Ah dead Well


Reply:
You finally have a semicolon at the end yet? I remember sqlite which is select * from tableName;
Otherwise it will think that you did not finish the sql statement
Reply:
I did not write, start writing, it is wrong to say the goods
Reply:

Reply:
Why do you use this to create a database? Creating a database of codes are generally written in the program inside ah.
Reply:
Debugging ah, you write JAVA then embedded SQL database server to view data ah.

A smart point with customers more convenient ah.
Reply:
Sqlite3 only used in adb shell, and never tried
windows underBut sqlite3 each statement must end with a semicolon, and we should not wait until you have entered. . .
Reply:

quote, 6th Floor yuleyouxi reply:

sqlite3 only used in adb shell, and never tried
windows underBut sqlite3 each statement must end with a semicolon, and we should not wait until you have entered. . .

Yes, the landlord on the phone right sqlite3, created adb pull back
Reply:
What, that's a little fog.

Can I explain it SQLite3.exe ADB shell and is valid relationship.

Also, adb shell default path is generally below that?
Reply:
I'm through, I'm through, it said that the goods have Cuoa

create database abc;
create database 'abc';


Reply:
Landlord Zhendou!
Reply:

quote the 10th floor shililang reply:

the landlord so funny!

Ah, in the end how to get it
Reply:
What management tools within SQLite I am using SQLite Expert Personal 3
Is visualized ...
Cell phone database ADB PULL out you only need to use this software to modify and then go on the line PUSH
Reply:

quote the 11th floor Eniak reply:

Quote: references to the 10th floor shililang reply:

Landlord Zhendou!

Ah, in the end how to get it

Just try the next, seemingly create is used to create table, you are not currently a database so we can not create a table
You try to create a database with the following command:

D: \ Android \ android-sdk-windows \ tools & gt; sqlite3 test.db // open the database, not on its own create
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite & gt; .database
seq name file
--- --------------- -------------------------------- --------------------------
0 main D: \ Android \ android-sdk-windows \ tools \ test.db
sqlite & gt; create table test (username test, age integer);
sqlite & gt; .table
test
sqlite & gt; insert into test values ('abc', 100);
sqlite & gt; select * from test;
abc | 100
sqlite & gt;

Reply:
Ah, now with the SDK comes with DDMS can read, graphical, easy adb shell, what will be used

Is found, limited DDMS following operations can not be removed, create some files and folders
?
Can you try to write SQL to do something in the SDK / JAVA environment as much as possible through the little button, through a graphic representation of data relationships and so on?




Reply:

quote the 14th floor Eniak reply:

ah, now with the SDK comes with DDMS can read, graphical, easy adb shell, what will used

Is found, limited DDMS following operations can not be removed, create some files and folders
?
Can you try to write SQL to do something in the SDK / JAVA environment as much as possible through the little button, through a graphic representation of data relationships and so on?

minus not a plus sign next to that deleted What ....
I did not need you to understand ....
You use the database file DDMS pull out completely and then treated with visualization SQLite data line management software would not push back
Reply:
The plus sign is not lit up, only you choose test.db situation before allowing the plus sign to light up, otherwise, can only be a plus, is to increase the meaning of the folder.

You said pull / push this I know, but think it is quite cumbersome point, had DDMS is a client, and also pull out, and then use the other to edit, edit finished, plug back in.

I think this one a forward, more cumbersome.

I can not think that is a client, all full buttoned, then primary and secondary key database are graphically represented
Reply:
In ...- & gt; then enter the semicolon you can exit the kind of been waiting mode. . .
Reply:
The landlord is not clear SQLITE commands. The new version is .open XXX (xxx is your database file name) then you can do the other. Remember that if you are SQLITE automatic commands. As .help .open .separator not need ';' if the SQL command is required;

Reply:
A Shamao, are still figuring out the syntax wood biting here!