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?. >