Re: [sqlite] Question about regexp function

Thanks! That answers my question perfectly. Best, Neil On 3/3/07, Griggs, Donald <[EMAIL PROTECTED]> wrote: Hi Neil, Re: " I would like to perform regular expression queries interactively, i.e. from the sqlite> prompt"I I'm not sure what operating system you're using, but there are sqlite GUI

[sqlite] Question about regexp function

Hello, I understand from the SQLite documentation that no regular expression function is defined by default in SQLite. I have seen scripts that define a regular expression function in Python or PHP, and use that in their SQLite query as the REGEXP function. However, I would like to perform regula

Re: [sqlite] How do you combine two SQLite databases?

Thanks! That fixed it. Neil On 2/17/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: On Sat, 17 Feb 2007 15:27:25 -0500, you wrote: >Hello, > >I have two SQLite database files, stuff1.db and stuff2.db. Each has three >tables within. I want to combine the two so I have one database file, >stuff.db, wit

[sqlite] sqlite: current_time is off

Hello, I just started using SQLite, and it seems my timestamps are all 5 hours ahead of time (i.e. "select current_time" gives me 0:47 when it is actually 19:47 here). I guess this is GMT. Is there a way to adjust the time? I'm on Windows XP, and the time is listed correctly in my taskbar. Thank

[sqlite] How do you combine two SQLite databases?

Hello, I have two SQLite database files, stuff1.db and stuff2.db. Each has three tables within. I want to combine the two so I have one database file, stuff.db, with 6 tables. How could I combine the databases? I am aware of the "attach" command, but this just seemed to create a file with two sub