MySQL Database Forum

MySQL 4.0 -- Generally Available (GA) release (recommended) MySQL 4.1 -- Gamma release (use this for new development) MySQL 5.0 -- Alpha release (use this for previewing and testing new features) MySQL 5.0.1 -- Snapshot release (use this for previewing and testing new features) Older releases -- older releases (only recommended for special...

I'm running a MySQL database with one of tables holding the members of a volleybal club in the Netherlands. One the the fields in that table is holding the name of the players. How do I search for all people with the name "Andre", with the important remark, that it should also match "André"!! So with the letter "e" with an accent "'" on...

Hi, I just installed MySQL on a Windows XP machine, and upon using the SHOW DATABASES command, I was suprised to see that the only table that exists is the 'test' table. Isn't there supposed to be a 'mysql' table there also? Did I miss something? Thanks, AC

DEAR SIR/MADAM, PLEASE I BEG YOU IN THE NAME OF ALMIGHTY GOD TO PLEASE READ THIS MAIL, AND DO NOT DISREGARD MY MAIL TO YOU.I AM AWARE WITH A MAIL LIKE THIS FROM A TOTAL STRANGER WILL MAKE ANY BODY APPREHENSIVE AND SUSPICIOUS, BUT I AM DESPERATE AS I CAN BEAR IT NO MORE. I AM mRS. BRIDGET SAYED ABDALLA A WIDOW AND MOTHER OF FIVE DAUGHTERS (AND A...

I am wondering what I miss to be able to handle binary data from the mysql client. I have ensured that the user has file_priv set to 'Y' and that max_allowed_packet is larger that the binary lumps handled. Here is my version: Ver 4.1.5-gamma-log for pc-linux on i686 (Source distribution) Right now I'm trying this to insert binary data:...

I've seen some pages with the footer: This page was created in 0.003s using 123 queries. Is there a way to get the number of queries on a single connection? I could fetch the value of "SHOW STATUS LIKE Questions" at the start and end of the page, but that would also count queries from other pages running at the same time, on a busy server....

Hi, I'm importing our DOS data base (Dataflex) to Mysql I have a table with 174,638 records that I convert into a tab delimetered Text file however, Mysql only reads 87,035! I checked the text file & it apperars fine is there any limitation? Joel

I am looking to package a java / swing / mysql application so that it can be installed primarily on Window based systems. I googled for "java mysql installer" and came up with a large number of products, gpl'd or commercial; its hard to know where to start. In addition, I am not a particular expert in mysql installation. Anyone have any...

CHINA METALLURGICAL IMPORT AND EXPORT COMPANY Dear Sir/Madam, I am Mr.Woo Lui.of (CMIEC) a company that deals on import and export of various metallurgical products, equipments, spare parts, mechanical and electrical products, as well as metallurgical technology into the Canada,America and Europe. We are searching for representatives who can...

Can I do this? Can't find any ref. select substr(col1,1,3) from table ... select col1 from table The column contains ABC123, DEF456, etc I want: ABC DEF

Hi Column width in a series of UNIONs is determined by the width of the first SELECT. Here is an example: mysql> ( SELECT "foo" ) UNION ( SELECT "fnord" ); +-----+ | foo | +-----+ | foo |

Hi all, I have a MYSQL table with emailaddresses from our members, AND a distributionlist with the same emailaddresses in mailman. I would like to retrieve the emailaddresses from the table and create a distribution list from it (with or without mailman) Right now I store the addresses twice, first in the mysql-table, and second in...

I have a large Mysql database and about 500,000 users on my site. I have installed a load balancer and 4 apache servers but only have 1 mysql server. Recently, my database server crashed and my site was offline because of this. While it was down less than an hour, I would like to eliminate this problem in the future. Would replication help?...

Hi there, I'm trying to export a pictures table, my mySQL database table already exists so I have linked both tables in Access and I tried to run a simple append query in Access to export the data but I either : - lose the connection to mySQL - have packets that exceed max_allow_packet I have tried different things to set...

Hi all, I would like give users the ability to experiment with complex queries but I'm worried about them creating queries that will bog down the server. Does anyone have any ideas for preventing a runaway process? I'd like to empower my users AND keep my server online :-) Thanks!

To gain performance, do I need to index ALL the fields in the where clause. Say we have a query like: select stuff from table where field1=.. and field2=... If field1 selection substantially reduces the number of records selected, do we really need to index field2 as well. In other words, does the query first subselect from the first...

If you have access to root, and are running heavy loads on your mysql (e.g. running a forum), then I recommend that you download mytop and run it on your server. mytop is like Linux "top" command, but it shows you the current mysql queries, time they are taking to run, etc. I discoverd quite a few dreaded "table scans" using this tool. My...

Hi, I have the following query: select sls2.shpr, sum(sls2.pkgs) as pkgs, sum(sls2.amnt) as sales, nams.code, nams.name, sls1.numb, sls2.numb, sls1.prnt from sls1, sls2, nams where sls2.shpr=nams.code and sls1.numb=sls2.numb and sls1.prnt=2 group by sls2.shpr order by sales desc This gives me a ranking of our suppliers. I want to modify...

Hey guys, I am using MySQL 4.0.18 and I have a field named "order_datetime" in which I store data in the format 20041001 23:00:00 (for example Oct 1, 2004 11pm) When I do a select statement to find dates in a given range, the result set never includes records that have the ending date. For example, if my SQL statement is

I have a pretty long query that ends with ORDER BY R.r_recent_hits DESC LIMIT 0, 1 I also have an index on R.r_recent_hits. I did an explain select and got this: ALL - which means (from the manual): A full table scan will be done for each combination of rows from the

I'm having a bit of a problem creating foreign keys on a MySQL database. The tables create and everything seems to be fine. But I just wanted to test out adding a row to one of the child tables without having anything in the parent table and it lets me insert the row, which it shouldn't obviously. How do i create it so that the constraints...

I'm teaching myself mysql and wonder if there are any sources of inane, complex, bogus data that I can download and insert into a table(s.) I have created some very small sets to practice joins and whatnot but they are not very big or complex, or exciting. A compressed tar of text strings (no blobs) could have plenty of data but still be a...

Hi Folks, I am about to start on a project where I will need to store a large amount of images and details about images. SQL seemed a natural choice for this, but I was a little unsure about how to store the image itself. From reading around I have found that there are two techniques that people normally chose for this sort of work:

I have a few MySQL tables that do not have key fields associated with them. I am linking to this MySQL database from Microsoft Access 2000 using the DoCmd.TransferDatabase acLink method. When the link is created, I get prompted with a "Select Unique Record Identifier". Here are my questions: 1. Is there a way to make this message not...

Hello Dear, I know this letter may come to you as surprise but due to a good recommendation from a good friend of mine thatworks with ministry of chamber of commerce, mining and agriculture here in Germany on my research of a reliable and trusted partner overseaswho will assist me for investment in his country,although I did notdisclose why I...