RE: Extracting fields from a table

Hi, Using PHP? If so, this works quite nicely if you pass your dates as unix timestamps: SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND FROM_UNIXTIME($theMinTime) < col) In other words, "col" needs to be between $theMinTime and $theMaxTime as in $theMinTime < col < $theMa

RE: long query on php

Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: savaidis [mailto:[EMAIL PROTECTE

RE: dumping between tables?

Hello Paul, Why don't you just use mysqldump to dump the data to a textfile, and then insert the data from the textfile into your new table? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul

RE: dumping between tables?

Paul, RTFM : http://www.mysql.com/doc/I/N/INSERT_SELECT.html [quote] INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ... With INSERT ... SELECT statement you can quickly insert many rows into a table from one or many tables. INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fl

mySQL 4 - FullText searching syntax?

Hello, I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am playing with the new fulltext search features and I have a question regarding the syntax... I have created a fulltext index on a field 'Notes'. I'd like to search for records that have words starting with "app

RE: Extracting fields from a table

Hi, Using PHP? If so, this works quite nicely if you pass your dates as unix timestamps: SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND FROM_UNIXTIME($theMinTime) < col) In other words, "col" needs to be between $theMinTime and $theMaxTime as in $theMinTime < col < $theMa

RE: dumping between tables?

Paul, RTFM : http://www.mysql.com/doc/I/N/INSERT_SELECT.html [quote] INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ... With INSERT ... SELECT statement you can quickly insert many rows into a table from one or many tables. INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fl

RE: dumping between tables?

Hello Paul, Why don't you just use mysqldump to dump the data to a textfile, and then insert the data from the textfile into your new table? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul

RE: long query on php

Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: savaidis [mailto:[EMAIL PROTECTE

mySQL 4 - FullText searching syntax?

Hello, I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am playing with the new fulltext search features and I have a question regarding the syntax... I have created a fulltext index on a field 'Notes'. I'd like to search for records that have words starting with "app