I do want to learn but i dont like to waste hours and hours through pointless explainations. i know what an integer is.. i dont need 3 pages explaining it, worst thing is that the tutorials arent good at all they dont teach me a lot of what i want to learn.
spoon feeding? well i cant afford books here because there are none to buy. and shipment fees are huge so thats not an option. i just wanted some advice. sqlite documentation seems to talk about how good sqlite WAS in those times and how things seem to be done among with a few senseless examples which doesnt help at all. by now you think im a retarded little kid for saying what i said. i just wanted some advice from those who KNOW. hence i came to ask HERE. On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote:
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?. >> > >> >> >