MySQL Database Forum

I am building a website which stores the headers of newsgroup articles in a database so people can search through the headers using keywords. My queries use WHERE LIKE statements. CREATE TABLE `headers` ( `header_id` int(11) NOT NULL auto_increment, `header_num` int(11) NOT NULL default '0', `message_id` varchar(150) NOT NULL default '',...

Can anybody tell what is wrong with this syntax? I'm trying to move some dates from 9 months ago into the present month UDPATE tbl_name SET datetime = DATE_ADD(datetime, INTERVAL 9 MONTH) WHERE MONTH(datetime) = '3'; -- Matt Bradley "Myths which are believed in tend to become true"

I have blob fields in some tables - never more than one field in any table, and never where a blob can be > 64k. I have inherited the code for this project from someone else, and was considering investing considerable effort in this case to move the blobs over to a separate table altogether. I am wondering if it is worth it however. Is it...

Having created a table with a longblob column, what is the insert syntax to set the value of the longblob column? The data will be read from a file.

I am building a website which stores the headers of newsgroup articles in a database so people can search through the headers using keywords. My queries use WHERE LIKE statements. CREATE TABLE `headers` ( `header_id` int(11) NOT NULL auto_increment, `header_num` int(11) NOT NULL default '0', `message_id` varchar(150) NOT NULL default '',...

Hi I have this query: SELECT id, name, YEAR(born) AS year FROM people WHERE DAYOFMONTH(born) = 7 AND MONTH(born) = 12 ORDER BY year DESC, name

Hi I have this query: SELECT id, name, YEAR(born) AS year FROM people WHERE DAYOFMONTH(born) = 7 AND MONTH(born) = 12 ORDER BY year DESC, name

I am looking at options/ways to store 12 million gif/jpg images in a database. Either we store a link to the file or we store the image itself in the database. Images will range from 4k to 35k in size and there will be 12 millions of them (at the beginning)... I expect a 8% growth every year. We will also have to perform some cleanup...

I'm another linux noob running redhat 9 and the included mysql. I had it working using phpmyadmin to configure it until I follishly removed my permisions for root trying to secure my server in phpmyadmin. Is there anyway to get this back? I've tried the grant options but I can't even logon to mysql as root@localhost. Thanks for any tips....

I'm trying to run NOT EXISTS or NOT IN query to find out wich records in one table do not match the other and mysql just gives me weird error. QUERY: SELECT cust_id FROM customers WHERE cust_id NOT IN (SELECT * FROM nightwatch_matrix); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL...

could anyone tell me how to clear mysql command line history? thanks Dave

Has anyone ran into problems where mysql_num_rows() return 0 when I know the result set contains a certain number of rows? My code looks something like this: MYSQL_RES *result; int numRows = -1; mysql_query(conn, "show databases"); result = mysql_store_result (conn); numRows = mysql_num_rows (result);

I am relatively inexperienced with SQL, and I am trying to learn how to analyze some data with it. I have a table with the following information. COMPANY ID , DATE, MarektValue I would like to select the largest 100 marketvalues for each date in my table. How can I do this efficiently in MySql.

Hi, i have a table with INT columns id,key,b1,b2,c1,c2, having 1.500.000 rows. 'key' and 'id' are indexed (Kardinality 385381) and id (Kardinality 1541525). Performing a SELECT * FROM table WHERE key IN (10,11,12) OR key BETWEEN 20000 AND 28000 AND b1<4500000 AND b2>3954545 AND c1<4543554 AND c2>4400000

As an SQL programmer, I have lurked this group. Many questions have to do with queries and updates. I would like to respond to these posts, but the description of the problem makes it difficult. Here is what I propose; - when you have a question, post the CREATE Table statements in real MySQL syntax. That way we could re-create the database...

Hi, I already found on the MySQL web site that some users did have good results with tables of some millions records. But, what I want to do is store some hundreds millions records in a table. 190 millions to start and maybe a lot more after. Does someone already use MySQL with such a quantity of data ? I was also asking myself how a...

Hi everyone. I have an interesting problem. We have two PHP shops that use MySQL databases. The database structures are exactly he same. Due to the two companies now working together we want the products to be the same on both, but not the customers or the looks of the shops (both shops are oscommerce). what we really want to do is in the...

I want to find the difference in times between the date/times of two tasks in the same table. selfJoin table task_ID task date_time 1 measure board 2004-11-28 15:53:55 2 cut board 2004-11-28 16:08:03 Here is the best SQL statement I can come up with to find how much time has passed between those two...

using InnoDB type tables: how to make a search in text fields to match for keywords "keyword1 keyword2" and "keyword1" or "keyword2" searching in text field ??? is there any way to know the raniking ? Alexei V.

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 19 Organization: Arcor NNTP-Posting-Date: 02 Dec 2004 12:46:22 MET NNTP-Posting-Host: a58bf304.newsread4.arcor-online.net X-Trace: DXC=Gl27MQXTJCTD__2dTlB=EkaMXXY;eg@jLYe\NQ\`f2NU8P_mnR6@1cH6TQE]KL?G7HZePceTdIGCVST] X-Complaints-To: abuse@arcor.de Xref:...

Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection to mysql. But now, i want MS Access to operate offline (e.g. on notebook in the field). I tried to create a local replica of the ODBC database, but the local replica still requires...

Hello, Decided (Finally!!!) to start testing out some of the new features 5.x has to offer. More specifically stored procedures and functions. I have tried to create a procedure but I continue to get an error and I think my syntax is correct..... Here is the code: CREATE PROCEDURE usp_GetPermissionGroups

Is there any way I can see what causes the warnings (and for which line in my CSV file) when I use LOAD DATA INFILE? I'm on MySQL 3.23.58 on RH9. Thanks

I'm useing PHP 4.3.9 with MYSQL5 I use odbc to connect the database that is ok but when I execte follow program ...that will disaply "Fatal error: Call to undefined function: mysql_exec() in C:\Program Files\Apache Group\Apache2\htdocs\link.php on line 10" Please .....Help me ~~~thx a lot ~~~ my program source code:

My company's enterprise directory is supposed to store all data fields in English. Before the data standards were implmented, many of the HR systems that fed data into the ED were sending some fields with a combination of English and non-English characters. I want to identify records with erroneous characters so we can ask the HR systems...