This type of thing works - http://www.1keydata.com/sql/sql.html
You can also look through the Sqlite documentation.
An SQL driven database is not a good tool for a person who doesn't want
to get some SQL knowledge.
If you are looking for spoon feeding, seeking free information on the
Internet is not the way. Enroll.
I found Sqlitespy a bit flaky but useful. Sqlbrowser seems to be quite
effective.
353455 453455 wrote:
i tried sqlitespy but its so unfinished!
about the tutorials i cant find any sqlite good ones
should i read mysql ones?
any texts i can read so i can learn the basics instead of having to crawl
though piles of nonsense texts? because most tutorials ive found doesnt
seem
quite right they TRY to explain a lot but they TEACH way too little.
On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:
Try sqlitespy or sqlbrowser. Both free to download.
You will need to learn some SQL. Just find an on-line tutorial and
learn the basics. It will on take a couple of hours.
353455 453455 wrote:
> hi i have a few questions hope they dont bother much.
>
> I) how can i know how many tables and how many rows there are in my
> database?
> II) how can i perform a search on my database?
>
>
> i need to do simple text search queries. and about knowing the
amount of
> tables and rows. i need this because i want to have a few
statistics. so
is
> there any way of knowing how many tables and how many rows there are in
> total via a query?
>
> im interested in searching on just a column of each table in this
database
> but i dont know any sql at all.
> im using sqlite3.
>
> does anybody know of a good administration tool for sqlite3? because i
only
> found a few tools but they werent quite done. and the others ive found
were
> shareware so i want to know if theres any freeware good tool out
there?.
>
