Records w/in 1 week Time Frame

How can I pull all records within a 1 week time frame? So if I enter 2003-10-19, how can I write a query that will get all records from 2003-10-12 - 2003-10-19. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Error linking mysqlclient

Found it myself... checking the documentation isn't such a bad idea... adding -lz did the trick. /Lars > Getting the following errors when trying to link client application > written in C: > > /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function > `my_uncompress': > my_compress.o(.text+

Error linking mysqlclient

Getting the following errors when trying to link client application written in C: /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0xaa): undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_al

mysqldump script

Using 3.23.54 mysqldump produces DB references when scripting foreign keys. I.E FOREIGN KEY (`KEYNAME`) REFERENCES `DBNAME.TABLENAME` (`KEYFIELD`) Is there a way to avoid "DBNAME."? Using a template DB which is copied to new DB's with different names, hand editing is a pain. Could possibly be strea

Re: confirm subscribe to mysql@lists.mysql.com

Dec 2002 10:09:43 - > Received: from pcow035o.blueyonder.co.uk ([127.0.0.1]) by blueyonder.co.uk with >Microsoft SMTPSVC(5.5.1877.757.75); >Mon, 16 Dec 2002 10:09:41 + > Received: from fruitnfibre (unverified [62.31.78.139]) by pcow035o.blueyonder.co.uk > (Content T

RE: Extracting fields from a table

theMinTime < col < $theMaxTime. Is that what you need? It works the same way if you don't use timestamps, by the way. timestamps are just more convenient ;) --- Alain Fontaine Consultant & Developer VAlain S.A. Tél: +32-4-2522950 --- -Origi

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:[E

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-

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?

OT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE) <-- snip --> What have I understood wrong? --- Alain Fontaine Consultant & Developer VAlain S.A. Tél: +32-4-2522950 --- - Before posting, please che

RE: Extracting fields from a table

theMinTime < col < $theMaxTime. Is that what you need? It works the same way if you don't use timestamps, by the way. timestamps are just more convenient ;) --- Alain Fontaine Consultant & Developer VAlain S.A. Tél: +32-4-2522950 --- -Origi

RE: dumping between tables?

.fldOrder_ID FROM tblTemp1 WHERE tblTemp1.fldOrder_ID > 100; . . [/quote] --- Alain Fontaine Consultant & Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul Reilly [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07,

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-

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:[E

mySQL 4 - FullText searching syntax?

OT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE) <-- snip --> What have I understood wrong? --- Alain Fontaine Consultant & Developer VAlain S.A. Tél: +32-4-2522950 --- - Before posting, please che

primary key

how to use more than one field in a table as combined primary key. e-mail= [EMAIL PROTECTED]