MySQL Database Forum

Hello, Does mysql parse this querys differently ? - select * from table where row='1' - select * from table where row=1 ( whitout ') What is the fastest ? Thanks

Hello all - I'm having a small problem with the mysql startup script that ships with MySQL-3.23.56-1. I'm running on RedHat Linux. It works fine, but I have a backup server that runs a script that passes these commands remotely through ssh: (1) ssh dbsys-dc "sudo /etc/init.d/mysql stop" (2) ssh dbsys-dc "sudo tar

Hi everyone: Does anyone know how to reset the auto_increment value of certain table. Any ideas or sugestions Greetings in advance _________________________________________________________________ Únete al mayor servicio mundial de correo electrónico:

Trying to start mysqld for the first time after a reinstall on Mac OS X gives me this error: 030709 12:53:26 mysqld started 030709 12:53:27 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: The error means mysqld does not have the access rights to...

Hi! I'm running MySQL 4.0.13 and have problem with fulltext search. I have a column of type 'text' which I fulltext index. I want to search for an e-mail address but I don't get any matches. I assume characters like @ . are ignored (stop words). How can I create an index which contains e-mail addresses? Eg. How can I edit the list of...

Hello, skip-new is explained as follows in the manual: "Don't use new, possibly wrong routines." (4.1.1 mysqld Command-line Options). Is there a list of the routines that will be disabled when using this command-line option? The manual also states the following: "concurrent_inserts If ON (the default), MySQL will allow you to use INSERT...

As we're on this topic in another thread right now: Say I have a SELECT query from more than one table and with some = conditions, does it matter in what order I enter the tables in the FROM = clause and in what order the WHERE conditions appear in my query? Or = does it make any difference if I use WHERE or HAVING? (I see that MS = Access...

I have two tables that I am trying to use to create a report by using a join. When the query is executed, the SUM on the second table is 4 times the expected amount. As a stand alone query on the second table, this works: SELECT `Last_Name`, `First_Name`, `Employee_SSN`, SUM(`id_es_inv`.`Total_Amount`) AS `Expense Amount` FROM `id_es_inv`...

Can anyone point me to a reference on how to insert images into a column in a mySQL database -- or is that not possible? Thanks in advance, Dan Anderson -- MySQL General Mailing List

I would like to extract one row of data where the row extracted contains the largest number in the row_name column. The following example doesn't work but it shows what I mean: SELECT name FROM names_movies WHERE count = MAX(count); I can do this by first selecting the MAX(count) and then selecting the row that corresponds to that...

Occasionally in checking one of the servers, I noticed that mysql shows 85% + of cpu usage essentially leaving the server at 0% idle. After monitoring it for a few hours, the status did not change. After a stop and start of mysql, things progessed normally. Checking back a few days later I noticed it was once again sitting up there at 95%...

Hi I am trying to make mysqld max so i can create innodb tables but I am getting the following error when i run mysqld No Variable Match for: -0 'innodb_buffer_pool_size = 40M' ../mysqld version 3.23.56 for pc-linux on i686 I am unable to figure out what to do. This shows that it reads the my.cnf file but how can I get rid off this...

One of these days I will maybe understand... Using MYSQL 4.0.13, debian linux create table members ( id unsigned int autoincrement, name ) create table activity (

Hello MySQL programmers, suppose we have an Enhanced ER diagram, with entities as classes/ subclasses connected through some IS-A relationship. How can this be Coded in MySQL Please? My prerequisites are the basic database texts from

Dear mysql users, in the tutorial of the documentation I found an interesting example of a complicated non trivial sql query: URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html# example-Maximum-column-group-row 3.7 Queries from Twin Project

I have a shopping cart which creates temporary tables in the format of zorder_<phpsessionid>; These tables are used to hold a customers order while they shop and after checking out, it is dropped. The values of the shopping cart are put together in an HTML table and stored as their history. What I want to do is to run a cron job to...

When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that...

--=_alternative 002B892D48256D5E_= Content-Type: text/plain; charset="us-ascii" Is it possible to manually delete the logfiles created in innodb tables and then do a 'touch logfilename' to recreate it? If this is not the proper way, can somebody help me on this; there's no specific explanations in the mysql manual.. Thanks.

Perfomance matters the most. So, what would be the ideal setup for permomance in Mysql? Machine specs: PIII 1.0 GHz 640 MB Ram 36 Gig Hd partions as follows: /dev/sda1 linux swap 1 Gig

Could any one advise what SQL statement I would need to use, to check a table for any duplicate records e.g that contain the same data within a field. Note that I haven't got the field as a unqiue field. Thanks Neil _________________________________________________________________ Stay in touch with absent friends - get MSN Messenger...

Hi, I want to insert massive amounts of data in near real-time into a MySQL database. The data is in a structured binary format, and I have code that parses the data into logical data structures. Right now I can load into a MySQL database via ODBC, but I need to improve throughput. How can I bulk insert the data more efficiently? I would...

I'm using INNODB with mysql 4.0.12 and a single data file: innodb_data_file_path = ibdata1:10M:autoextend My database has grown out of hand though and I am almost out of disk space: df: /dev/sdb1 35859376 34878228 981148 98% /

I have a table like this (table_gender): gender_id gender_description --------------- ---------------------------- 0 female 1 male I also have a table like this (table_post):

I'm kinda new to administering MySQL. I have a remote db that I want to backup to my local MySQL server (windows). I can do a dump of the db from phpMyAdmin on the remote server. I try running it on my local server through the MySQL Control Center, and it says "Read Only". I don't have to enter password for root@localhost to login to the...

I have just installed MySQL++ 1.7.9 using the RPMs from Rpmfind.com. It installed all Ok. The reason why I installed the RPM over the source was that I can't get the source to compile. When I go and search the drive after the installation I don't see the 'sqlplus.hh'