Then how 'bout letting me know the next time you see a market "bubble" coming? :-)
> -----Original Message----- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, July 07, 2006 8:53 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > ??? I am in heaven. > > 353455 453455 wrote: > > You make it so easy so others can learn from you. Youll go > to heaven for > > that. You are so useful to those who ask for your help. > Someone should make > > you a saint and pray so you help them. > > > > > > > > > > On 7/7/06, John Stanton <[EMAIL PROTECTED]> wrote: > > > >> > >> Sigh.... Free help is a privilege, not a right. > Explanations are not > >> pointless, they are educational. > >> > >> 353455 453455 wrote: > >> > 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?. > >> >> >> > > >> >> >> > >> >> >> > >> >> > > >> >> > >> >> > >> > > >> > >> > > >