| |
thread by: anmar |
last post Jul 23 '05 by: db_rookie
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
|
thread by: Gianluca_Venezia |
last post Jul 23 '05 by: Gianluca_Venezia
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...
|
thread by: josys64 |
last post Jul 23 '05 by: Heikki Tuuri
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 ?
|
thread by: - |
last post Jul 23 '05 by: -
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 .."
|
thread by: - |
last post Jul 23 '05 by: -
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
|
thread by: - |
last post Jul 23 '05 by: -
is it possible to generate a random number within an sql script rather
than the client specifying which random row to select?
|
thread by: - |
last post Jul 23 '05 by: Bill Karwin
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.
|
| |
thread by: dstewart |
last post Jul 23 '05 by: dstewart
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...
|
thread by: Gianluca_Venezia |
last post Jul 23 '05 by: Gianluca_Venezia
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...
|
thread by: Sam |
last post Jul 23 '05 by: Bill Turczyn
Is there a way to filter 'show processlist'?
like
show processlist where Host rlike "abc"
Thanks,
Sam
|
thread by: - |
last post Jul 23 '05 by: Bill Karwin
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...
|
thread by: - |
last post Jul 23 '05 by: -
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...
|
thread by: Mike Ruskai |
last post Jul 23 '05 by: Mike Ruskai
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...
|
thread by: usenet |
last post Jul 23 '05 by: usenet
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 :
|
thread by: iStrain |
last post Jul 23 '05 by: Bill Karwin
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...
|
| |
thread by: Fred |
last post Jul 23 '05 by: Bill Karwin
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.
|
thread by: willbr |
last post Jul 23 '05 by: Bill Karwin
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....
|
thread by: J West |
last post Jul 23 '05 by: J West
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...
|
thread by: Dave |
last post Jul 23 '05 by: Dave
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...
|
thread by: Mike |
last post Jul 23 '05 by: Michael C#
how do you post to this group?
|
thread by: Rotsj |
last post Jul 23 '05 by: Bill Karwin
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)
|
thread by: Baoqiu Cui |
last post Jul 23 '05 by: Baoqiu Cui
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)
|
thread by: Khazret Sapenov |
last post Jul 23 '05 by: Bill Karwin
Hi,
What is the practical use of ZEROFILL in your case?
regards,
Khaz
|
| |
thread by: josys64 |
last post Jul 23 '05 by: josys64
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 ?
|
thread by: Vangelis Natsios |
last post Jul 23 '05 by: Vangelis Natsios
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...
|