Re: Re: [sqlite] Need help on build query.
Thanks
--- [EMAIL PROTECTED] wrote:
> "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> > Artem Yankovskiy
>
> > wrote:
> > > I know about DROP TABLE.
> > > I have not knew when compatibility DROP TABLE
> and
> > > SELECT...
> > >
> > > DROP TABLE (select name from sqlite_master
> where...)
> > > did not work.
> > > Can I build resembling query?
> >
> > No. You will have to run the select, store table
> names in memory, then
> > build and run a separate DROP TABLE query for each
> table name.
> >
>
> Igor is correct - you cannot do that now. But I
> have sometimes
> wondered if it would be nice to add an exec()
> function to SQLite
> that would recursively invoke its argument as an SQL
> script.
> For example:
>
>SELECT exec('DELETE FROM ' || quote(name))
> FROM sqlite_master
> WHERE ;
>
> There would be security implications here, of
> course. Clearly
> one would need to make sure that user-entered SQL
> (such as can
> be seen at http://www.sqlite.org/cvstrac/new) does
> not have access
> to the eval() function, just as it does not have
> access to the
> the load_extension() function.
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
>
-----
> To unsubscribe, send email to
> [EMAIL PROTECTED]
>
-
>
>
Best regards,
Artem Yankovskiy
Вы уже с Yahoo!?
Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Re: Re: Need help on build query.
It's a pity :( --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Artem Yankovskiy > > wrote: > > I know about DROP TABLE. > > I have not knew when compatibility DROP TABLE and > > SELECT... > > > > DROP TABLE (select name from sqlite_master > where...) > > did not work. > > Can I build resembling query? > > No. You will have to run the select, store table > names in memory, then > build and run a separate DROP TABLE query for each > table name. > > Igor Tandetnik > > > - > To unsubscribe, send email to > [EMAIL PROTECTED] > ----- > > Best regards, Artem Yankovskiy Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: Need help on build query.
Hi Igor. I know about DROP TABLE. I have not knew when compatibility DROP TABLE and SELECT... DROP TABLE (select name from sqlite_master where...) did not work. Can I build resembling query? Thanks. --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Artem Yankovskiy > > wrote: > > I like delete some of table. > > DROP TABLE tableName; > > http://sqlite.org/lang_droptable.html > > Igor Tandetnik > > - > To unsubscribe, send email to > [EMAIL PROTECTED] > --------- > > Best regards, Artem Yankovskiy Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Need help on build query.
Hello. I like delete some of table. For example: I can run query: select name from sqlite_master where name like 'prefix_%'; Can I delete found tables? Using only sql. It's real? Best regards, Artem Yankovskiy Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Running out of disk space.
Hi. You do not receive the error message until receive 0 free disk spaces. When queryes are running in transaction, record in a DB does not write, the journal-file is created only, therefore you see your changes. As soon as you make commit, there is a records of changes in a DB. During this moment there can be an ending of an empty space on volume, then sqlite will return an error and will roll away changes. --- Jeffrey Rennie <[EMAIL PROTECTED]> wrote: > What happens, and/or what is supposed to happen when > sqlite runs out of disk > space? > > In an extremely disk-space constrained situation, I > create a bunch of > tables, without any sqlite errors, and then later > the tables are not found. > I see the same thing when inserting rows: no error, > but later look-ups don't > find inserted rows. I'd like to detect that the > write to DB failed at time > of write, not a later read. I'm also doing the > INSERTS and CREATE TABLES > within a transaction, and again all the sqlite calls > succeed, even the > COMMIT TRANSACTION. There are no other pending > statements at the time of > the COMMIT TRANSACTION. > > I'm using version 3.3.4 on Windows. > > Thanks, > Jeffrey Rennie > Best regards, Artem Yankovskiy Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] selecting a random record from a table
select * from table1 order by random(id) limit 1 ? --- P Kishor <[EMAIL PROTECTED]> wrote: > 1. given a non-sequential id, select all the ids > 2. grab a random id > 3. select the row with that id. > > is there a better way of accomplishing this, one > that requires a > single round-trip to the db? > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Inst. for Env. Studies, UW-Madison > http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation > http://www.osgeo.org/education/ > - > collaborate, communicate, compete > = > > - > To unsubscribe, send email to > [EMAIL PROTECTED] > ----- > > Best regards, Artem Yankovskiy Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: Re: Re: [sqlite] Sample dll using
Thanks. :-) --- Jay Sprenkle <[EMAIL PROTECTED]> wrote: > On 12/22/06, Artem Yankovskiy > <[EMAIL PROTECTED]> wrote: > > Thanks! > > Can at whom is small sample on C/С ++? > > > some example code here: > > SqliteImporter and SqliteReplicator: Command line > utilities for Sqlite > http://www.reddawn.net/~jsprenkl/Sqlite > Best regards, Artem Yankovskiy Yahoo!? Yahoo! ! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: Re: [sqlite] Sample dll using
Thanks! Can at whom is small sample on C/С ++? --- jose isaias cabrera <[EMAIL PROTECTED]> wrote: > > http://www.dprogramming.com/enticeaddrbook.html > > > > > - Original Message - > From: "Artem Yankovskiy" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Thursday, December 21, 2006 7:51 PM > Subject: [sqlite] Sample dll using > > > > Hello! > > Can I get sample source code for using DLL? > > > > > > Вы уже с > Yahoo!? > > > Испытайте > > > > обновленную > > > и > > > улучшенную > > > Yahoo! Почту! > > http://ru.mail.yahoo.com > > > > > - > > To unsubscribe, send email to > [EMAIL PROTECTED] > > > - > > > > > --------- > To unsubscribe, send email to > [EMAIL PROTECTED] > - > > Best regards, Artem Yankovskiy Yahoo!? Yahoo! ! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Sample dll using
Hello! Can I get sample source code for using DLL? Yahoo!? Yahoo! ! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] combining multiple queries
Hi Jason.
Can make is easier so:
SELECT * FROM film WHERE
genre IN ("comedy", "drama")
AND tag IN ("bill murry", "scarlett o'hara"
,"silly");
--- jason schleifer <[EMAIL PROTECTED]> wrote:
> heya folks,
>
> I'm trying to figure out the proper syntax for doing
> a query of something
> like this:
>
> I have two different types of things that people
> will be querying for, and I
> want to do an OR on each, but and AND between them..
>
> So let's say i've got a table that looks like this:
>
> Create TABLE film (id INTEGER PRIMARY KEY, genre
> VARCHAR, tag VARCHAR):
>
> Genre can be of whatever genre the user wants..
> comedy, drama, etc.
> tag is a list of words that are separated by ;..
> "kennedy;marilyn;funny;"
> etc
>
> If the user doesn't specify either genre or a tag
> when they're querying, I
> want to return the whole list of films (that's an
> easy one).
>
> If the user specifies one or more tags, I want to be
> able to return all
> moves that match EITHER tag.. for example, if htey
> specify "carrey" and
> "snow", it should return all movies that have either
> carrey or snow in the
> list.
>
> If they then specify a genre, I want it to return
> ONLY the movies in the
> specified genre that match carrey or snow.
>
> Then (just to make it more complicated), if they
> specify two genres, it
> should return all movies in either of those genres
> that match either carrey
> or snow.
>
> Does this make sense?
>
> I know how to string a whole bunch of LIKEs together
> with an OR to get it to
> work so you could get it to match a genre or a tag..
> but how do I do
> something like:
>
> SELECT * FROM film WHERE (genre = "comedy" OR genre
> = "drama") AND (tag =
> "bill murry" OR tag = "scarlett o'hara" OR tag =
> "silly");
>
> any help is greatly appreciated..
>
> cheers!
> -jason
> --
> jason schleifer
> ah-ni-may-tor | weirdo
> http://jonhandhisdog.com/
>
Yahoo!?
Yahoo! !
http://ru.mail.yahoo.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] Ответ: Re: [sqlite] count up how much an free space on DB
Thanks Richard. I will try. --- [EMAIL PROTECTED] пишет: > Artem Yankovskiy <[EMAIL PROTECTED]> wrote: > > Question, whether probably to count up how much an > > free space there is in this a DB? > > > > If the first byte of the database file is called > byte 0, > then bytes 16 and 17 form a 16-bit big-endian > integer > which is the number of bytes per page. Bytes 36-39 > form > a 32-bit big-endian integer which is the number of > unused > pages in the database. If you multiple those two > numbers > together, you will get the amount of reusable free > space > in the database file. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > - > To unsubscribe, send email to > [EMAIL PROTECTED] > - > > Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] count up how much an free space on DB
Hello. There is a DB. auto_vacuum is not used. One of tables of a database contains 500 records. We for example delete from it 300 records. The place in a database was released, but the size of a file has not decreased how is not set auto_vacuum. Question, whether probably to count up how much an free space there is in this a DB? Вы уже с Yahoo!? Испытайте обновленную и улучшенную. Yahoo! Почту! http://ru.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
