MySQL Database Forum

I'm trying to figure out how to select all the records in one table which have multiple specified records in a second table. Here's a simplified version of my problem. I have two tables, resources and goals. resources table: ID TITLE

I have a problem with MYSQLBINLOG.EXE: result file doesn't contain log such as CREATE TABLE and DROP, even if bin files contains it correctly. This is a problem because I use bin result file to manage update of my (test) application, and when I create an Index, or modify a table, exporting bin log files I can manage it simply. But, and I...

i have a strange problem : MySQL 4.0.21 innodb and php 4.3.9-1 all tables are in innodb type. For a simple select statement sometimes i get result and sometimes nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random behaviour. If my table is MyISAM type no problem. If someone have an idea ?

i have a stored procedure that accepts parameters. is it possible to 'throw' a warning if the parameters are invalid? e.g the parameter must be more than 0. the client will then see "..... 0 rows affected, 1 warning .."

i have a stored procedure that does several things in the following order: select record do stuff with record delete record if there are multiple clients accessing the procedure, will the resultset of 'select record' differ among the clients? does each client execute the procedure until finish or will they take

is it possible to generate a random number within an sql script rather than the client specifying which random row to select?

how does one prevent someone from directly inserting into a table such that any inserts should be passed to a stored procedure e.g insert_data(....) i have read the manual on revoke, grant but couldn't grasp the idea.

I have 2 Suse 9.1 boxes with similar configurations. I'm in the process of moving some PHP code from one server (192.168.0.100) to another (192.168.0.102). MySQL is running on each server, and the same PHP code can access its respective localhost databases and make queries with no problem. However, the code on the old server (.100) can...

I have a problem with MYSQLBINLOG.EXE: result file doesn't contain log such as CREATE TABLE and DROP, even if bin files contains it correctly. This is a problem because I use bin result file to manage update of my (test) application, and when I create an Index, or modify a table, exporting bin log files I can manage it simply. But, and I...

Is there a way to filter 'show processlist'? like show processlist where Host rlike "abc" Thanks, Sam

i'm getting an errno: 150 when creating a table and this is what i read from the mysql manual: "Both tables must be InnoDB type. In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order. In the referenced table, there must be an index where the referenced columns are...

i am using the development release of mysql and have a PROCEDURE that executes a prepared statement. it works fine when i call the procedure but repeating it multiple times produces an "incorrect arguments to execute" error. replacing the prepared statement with a normal statement eliminates the error. is this due to the release or is a...

I've been trying to implement database axis using the C api for a many-threaded application (several, actually), and keep running into a problem on server disconnect. One of the main reasons is to get around the packet size limit of ODBC (which seems to be somewhere around 10MB), which prevents a few large BLOBs from being inserted into the...

I'm trying to figure out how I can sort records alphabetically by almost "blending" two fields. SELECT city, county FROM fullist WHERE type = 'city' or type = 'county' ORDER BY ???; It should output like this :

Hiya. I'm _sure_ this is an FAQ, but Googling hasn't produced the answer in a way I can make sense out of. I know I should get this, but so far no way... I'm creating tables and doing queries in Perl, and Nulls have started to bother me greatly. The first issue is, as far as I understand it, a column should be NOT NULL if it is necessary...

Hi all, I have done a lot of experimentations using several "or" predicates within an sql select statements on mysql. My only conclusion so far is that whatever syntax or order I use it is always slower than doing seperate sql statements (one for each or) and programaticaly adding them to a vector.

I keep a log book of things I do to my car like checking air in the tires, getting gas... What I would like to do is put this stuff in a DB. The format I have been using on paper is: Date - Mileage - Category - Description Jan.8, 2005 - 12345.1 - FUEL - 20.123 gal @ $1.509 (35mpg) Jan.9, 2005 - 12350.5 - TIRE - RF:Flat. Put on spare....

I am using Query Browser version 1.1.2, MySQL Administrator 1.0.14, MySQL Version 4.1.7-nt on Windows XP Service Pack 2 ALTER TABLE `purpleflavours`.`purchaseorderitem` CHANGE COLUMN `PurchaseCost` `PurchaseOrderItemCost` DOUBLE UNSIGNED ZEROFILL CHARACTER SET NULL COLLATE NULL NOT NULL DEFAULT 0000000000000000000000 Generates when I...

Ok I have an interesting problem. I have written a database in Access to connect to our web shop and update prices etc from a supplier feed. It works almost perfectly! The prices are doubles, I am using ADO in access to connect via myodbc (with options don't optimize column width, Allow big results and change bigint to int). Everything...

how do you post to this group?

Hi, if i run the following query: select * from std_order_lines sol where exists(select * from std_orders so, customers c where so.customers_id = c.customers_id and c.test_customer = 'Y' and so.order_id = sol.order_id)

Hi, I was playing with MySQL (4.1.9) during the weekend, but noticed a minor problem and would like someone to explain this to me. Basically I could successfully create a table with one unique column like this: mysql> create table t1 (c1 int unique); Query OK, 0 rows affected (0.08 sec)

Hi, What is the practical use of ZEROFILL in your case? regards, Khaz

i have a strange problem : MySQL 4.0.21 innodb and php 4.3.9-1 all tables are in innodb type. For a simple select statement, sometimes i get result and sometimes nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random behaviour. If my table is MyISAM type no problem. If someone have an idea ?

I run a MySQL Server (v. 4.1.5-gamma) from a binary distribution on a SuSE 7.0 Linux. The default character set for the server is utf8 (runs with the flag --default-character-set=utf8). The utf-8 encoded databases I have seem to work fine. But I want to create another database with greek (iso-8859-7) encoding from a dump from a 3.23.X server...