Re: [sqlite] SQL request. Sign "-" as NOT LIKE

[EMAIL PROTECTED] a écrit : Cecilia VIGNY <[EMAIL PROTECTED]> wrote: Hi everybody, I'm building a SQL request in order to question my SQLite database from my php program. I would be happy if this request were compatible with a MySQL database ;o) So what I want to know is if we c

[sqlite] SQL request. Sign "-" as NOT LIKE

Hi everybody, I'm building a SQL request in order to question my SQLite database from my php program. I would be happy if this request were compatible with a MySQL database ;o) So what I want to know is if we can use the minus sign as we can do with the index fulltext in MySQL. For instance,

[sqlite] Fulltext (php)

Good afternoon, Does anybody have an idea of when the most recent version of SQLite, which supports fulltext indexes, will be integrated with Php ? Have a nice day ;) Ce message est prot?g? par les r?gles relatives au secret des correspondances. Il est donc ?tabli ? destination exclusive

Re: [sqlite] SQLite / php - Using REGEXP

[EMAIL PROTECTED] a écrit : Cecilia VIGNY <[EMAIL PROTECTED]> wrote: Hi, I'm developing a Php program which uses a SQLite database. I want to execute an SQL request : select * from dicsupp WHERE supp regexp 'test'; It doesn't work... What's wrong ? From the documen

[sqlite] SQLite / php - Using REGEXP

Hi, I'm developing a Php program which uses a SQLite database. I want to execute an SQL request : select * from dicsupp WHERE supp regexp 'test'; It doesn't work... What's wrong ? Thank you ! ;) Cécilia. Ce message est protégé par les règles relatives au secret des correspondances. Il

Re: [sqlite] Re: DROP TABLE IF EXISTS my_table

Thank you for response. How can I install a more recent version with my php ? (I'm using Wamp5) Igor Tandetnik a écrit : Cecilia VIGNY wrote: I'm using SQLite with a PHP program and I would like to execute this SQL request : DROP TABLE IF EXISTS clients; When I test my program, this error

[sqlite] DROP TABLE IF EXISTS my_table

Hi, I'm using SQLite with a PHP program and I would like to execute this SQL request : DROP TABLE IF EXISTS clients; See my code : $allsqls=<<$sqlite = sqlite_open('pac.sdb') or die ('Impossible de se connecter a la base SQLite'); //Création des tables dans la base SQLite