MySQL Database Forum

I'm working on a Windows client program in C++, using Qt and OleDbPro (for database access). Everything was working great until I had to use a query for the first time in the code that pulled data from two tables. The query executes, but returns 0 rows. I verified that the query should return rows by running the query both through another...

I launch the command line: "mysqlcheck --repair dbname" over a database with only one myisam table of more than 10.000.000 rows and 5 GB. The elapsed time to repair is about 1 hour! Is possible to increase speed? Thanks. Marco

Hi, I have a quick question. I have a .asp application in which certain parts, clients can now edit/update/add information to their records in our DB. I basically use an include statement at the top of each page. The include .asp page has my connection data within .asp tags. The general 'user' to which the connection belongs only has...

I would like to use a "LIKE" condition in my LEFT JOIN statement. At the moment I have something like: SELECT * FROM page AS p LEFT JOIN item AS i ON p.url=i.url Now I want to include the subpages from i.url. So if p.url is "www.here.com/page" it should also match if i.url is "www.here.com/page/subpage.html"

Hi, I am using MyODBC 3.51.06 on solaris. When a ODBC call fails to execute due to communication problems with database server, according to ODBC reference, sqlstate should be set to 08S01 (Communication link failure). But myodbc driver is setting it to HY000 in case of communication errors.

I am running Win 2000. I need to change the MySql excutable path in Component Services. When Iright click on Properties the path is wrong but can't change it from there. How do I do this? Thanks

I have a table with this structure CREATE TABLE `occurrence` ( `occurrence_id` int(10) unsigned NOT NULL auto_increment, `word_id` int(10) unsigned NOT NULL default '0', `productId` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`occurrence_id`) ); The following query will show me how many times 'something' occurred for each...

I have a large list of email addresses that I have found are undeliverable to users, I want to mark a field in mysql to 1 where there is this email address, how can I do this in one go from a \r file. Something like update mytable set bad_email = 1 where email_address = readFile(my_return_sep_file) --

I'm trying to run this query: SELECT * FROM features WHERE food_group_ID = 'Company™' I've tried Company%99, Company™ Company™ and nothing returns. What do I need to pass from a jsp page to represent the trademark in MySql? Thanks

Hi, I downloaded MySQL 3.23.57 for Windows as I wish to learn MySQL locally and then use the one I already have installed on my UNIX server. I ran setup and rebooted but the WinMySQLadmin program will not start the Server as it has a MyODBC error "Driver 3.51 Not Found". I cannot find any reference to this in the books I have, at MySQL.com,...

I have this query which does a left outer join and it takes forever (like half a day). Here are the results of an explain analysis. mysql> explain SELECT count(searchresult.title) AS number, campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER JOIN searchresult ON searchresult.title = campaigntrack.title WHERE...

I'm trying to run this query: SELECT * FROM features WHERE food_group_ID = 'Company™' I've tried Company%99, Company™ Company™ and nothing returns. What do I need to pass from a jsp page to represent the trademark in MySql? Thanks

Is there a way to store images in a mySQL database? I was hoping to store them in a table, then use php to call them from the database and display the picture on a webpage. Any help would be appreciated.

Hi, I know about stored procedures and that they can speed up data entry via the SQL 'insert ' statement. However, one drawback to this method is that using the stored procedure still requires one to manually and individually enter each and every record to be inserted to the database before the procedure is executed. I want to circumvent...

I have a web program where I want to connect to my database and discover the tables within the database. Then select a table and discover the column names, their types, and lengths. Thanks in advance. Braden Bowers

Hi all For speed reasons, I would like to rewrite the following query without the subquery : SELECT * FROM table1 WHERE field1 NOT IN (SELECT field1 FROM table2 where field2=X); I thought something like this would work fine : SELECT table1.* FROM table1 LEFT JOIN table2 ON

I have a large'ish mySQL table, very text heavy (although no fields are larger than varchar 255). I do a bulk update once a day, which probably removes a 1/4 of the records, replacing them with fresh records. I find my table swiftly becomes massively inefficent, with the reported overhead soon exceeding the actual size of the table. So my...

Hi I want to create the best index for thar query: "select * from talkback where status=0 order by bject_type,vertical_id,event_id" Which index i need to create for best performance. 10X

DID YOU KNOW A HACKER COULD BE READING YOUR EMAILS RIGHT NOW? the next email you receive could contain a virus. are you protected? All emails are scanned automatically with Norton Antivirus! btw, you look great today. Purchase a copy now and be safe. http://9302fs@softwaresavings2you.biz/default.asp?id=3000

Hi It's probably a stupid question, but I can't find how to do that in the MySQL documentation ... I want to do the following query, or something like that: SELECT id, "string"+id as text FROM ... and the result should be:

Hi, I'm trying to get a version of MySQL 4.1.0 installed on my (Gentoo Linux) machine. I have a copy of MySQL 4.0.13 already installed, using Gentoo's ebuilds, but am trying to install 4.1.0 in a side-by-side configuration. (Into /usr/local/mysql_alpha, talking to port 3300) - So I can run 4.0 as my "production" server, and muck about with...

Hello, all - I would be interested in hearing opinions on how easy or difficult it it to use MySQL as part of a Web page. I have no experience with MySQL, but I have experience with MS Access and VB. The project that I'd like to put together is an online ordering facility for videotapes, not too many concurrent users and relatively low...

I am porting C code originally written to talk to a SQL Server engine via ODBC. While many of the differences are mainly annoyances, and I found work arounds, I have run across one big issue. The MySql driver (3.51.06) doesn't support bookmarks. The only time this is a real problem is when I need to get the value of an auto-incremented...

Hello, mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them. Thanks Anticipated, Iulian

For the following query, I have a little problem ... First, I have to rewrite several times the same query because the alias are not recognised in the same query ( I got an error when I try to reuse the alias "nb_bogus_leads", for instance). Do you have a way to avoid this ? Because If I do so, the same query is calculated twice .... ...