MySQL Database Forum

Hello, When I do a "AND" in a SQL query, eg. SELECT NAME WHERE SEX="male" AND AGE= "30", MySQL does a sub-search, right? i.e. it does the "WHERE SEX=male" first, and then searches through the list of *those* results to see if AGE=30? Does it do this from left to right? i.e. in the query above, would the table always, and necessarily, get...

I have a database like this id, field1,field2,field3,field4,field5 Database contains 100 rows, some rows have no fields filled, some 1field , some 2 fields etc. How would i count the number of fields filled in total? So the outcome is (number of fields filled in row1)+(number of fields

Hi there, Using PHP and MYSQL I changed one of my MySQL search queries to allow a situation where the user gets much more information returned then previously However, it has now given me the error message: Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 42 bytes) in /usr/share/pear/DB/mysql.php on line...

I am at kind of a loss on how to design a certain database project I am working on. Basically, we have a proprietary program with a standard backend (though we do not have direct write access to the backend). What I am working on is a project to take certain data from the database, send it to certain vendors, process the data, and send it...

how can I retreive the path to a mysql database. I need to use it as a string in my program to find image files that are stored in the same directory? Ian

Hi Can I trigger an external program to run when a new record is added to the mysql table? The external program is in C and instead of scanning the table continuously for new insertions, it will be better if an external program could be triggered. Any suggestions?

I have a table that is -- 30 Megabytes 90,000 rows ~65 columns My query goes SELECT city FROM table WHERE zip = 90210; It will then find about 10 matching records.

I dont profess to be a master at SQL statements. Thanks for your help, if anyone can give it. I have a database that has a run column. A user can place in that column a number, such as 1, 2, or 3. I want to organize me list by this run number. The problem is that when I call the query it places all the rows that have no number on the...

My client is using a shared server running MySQL 2.4, however the in house server is 4.1.12 with mysqldump 10.9. Is there a way to have the 10.9 version output a format that is fully compatible with 2.4? Some of the CREATE TABLE statements in 10.9 are not accepted by 2.4. Currently, I am not using any of the switches in creating the...

Experts/Programmers please advice on these questions. 1. Is Mysql secure than MsAccess (there are softwares avilable to retrieve Ms Office Password) 2. Which 3rd Party tool Would You recommend for Administration,Query creation.... Etc 3.Any tools for setup Mysql database to ship with ApplicationProgram (Access need not be installed...

Using MySQL 5.0.15 I am no expert so maybe I am deeply misundertanding how this should work. I have a relatively complex quey with joins and a subquery (it is probably far from optimized, but that is another issue; right now I am more interested in correctness than speed). If I do not put a GROUP BY clause then the query returns a number of...

hello can anyone help me with an sql statement that will work for mysql to take data from two tables where the two tables are linked with a common field. As you can guess im new th mysql Thanks Ian

--0-413911351-1058468110=:5477 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello I want to know if there is java API to mySQL like its available for C and C++. Bye Kalika

Hi, I have a problem to connect to my local server After I have done: c:\mysql\bin>mysqld --standalone I try: C:\mysql\bin>mysql ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Hi there I'm developing a large web application. Part of this web application will be storing numerical chart data in a MySQL table - these numbers will be already calculated, and are just being stored for reference. In this particular table, the stored data will never be deleted or changed. The only actions performed will be SELECTs and...

I'm famililar with other DB systems, but for some reason am having a problem with the simplest of queries..... SELECT * FROM table1 WHERE famc NOT IN ( SELECT familyID FROM table2 )

This is my Table Tb that has a composite key (ID and Pr are both Primary Keys): ID | Pr 1 | A 1 | B 1 | C 2 | B 3 | A 4 | A

I have a text file with about 90,000 insert statements (as below). Is there an easy way I can get these into my mysql database in one fell swoop? Can anyone tell me how and perhaps that the syntax is? Thanks -Ike INSERT INTO `lastnames` VALUES ('OFFENBERGER');

Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt. I'm trying to setup the nexus discussion software. Any help appreciated

qim ----KZbS7hrbznJi92oKn Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE= : 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar= ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE= CORATION: none...

Can someone please tell me how I can do this: I have an appointment table which has appointment_id, client_id, appoinment_time (as unix timestamp). Clients can have multiple appointments. I want to select all appointments from the appointment table but only one appointment (the latest one) for clients that have multiple appointments. How...

What is the proper procedure for promoting a Slave into a Master replication server? We want to do some fail-over testing. When we tried this in the past, the former master would not replicate. We got an error: "master and slave have equal MySQL server ids". The fail-over procedure includes renaming the slave and exchanging IP...

Hi, When I import mysql data from a dump file into mysql, then phpmyadmin under structure shows sizes as unknown. I googled for this, but could not find a good answer. How do I get the information to show in phpmyadmin? Thanks! --

Hi! I'm using the MySQL "Load data" command to load big .csv files into a MySQL database. Sometimes there are special characters within these .csv files which cause some kind of "displacement" of the loaded data. (1) Is there a way to check if the data from the .csv file was loaded correctly ? (2) I'd also like to know in which line an...

I'm fairly new to creating complex sql statements and need a little help. In plain english I want to do this: Select menu rows where the row's userGroupIDs equal the user's userGroupIDs. Menu.userGroupID has multiple values seperated by commas. User.userGroupID also has multiple values seperated by commas. I realize some may want me to...