Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Doug Dalton wrote:
I found a log error after turning on warning running the server manually:
051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user:
'user' host: `client'
Hello.
Surround your code inside the IF statement with BEGIN...END. For example
this works for me:
drop procedure if exists testcursor;
DELIMITER //
CREATE PROCEDURE testcursor(IN city_name varchar(255))
DETERMINISTIC
BEGIN
declare tval int;
IF (INSTR(city_name, ',') 0) THEN
begin
Hello.
In the example,routine_body is non-deterministic.But the function
defined DETERNINISTIC.Do mysql throw a exception in creating process?
In my opinion, it shouldn't, but you can check this by yourself.
I want to say,if i my funciton is a non-deterministic function.But i
can you please post the complete .err log that also contains
information about the crashes. If there are stack traces, please
resolve them.
I keep a lot of personal information in a MySQL database. I have a few
querys premade for the wife to use, but we have gotten to the point
where we need a solution for her to be able to run her own queries.
She is NOT about to learn SQL, and myPHPadmin is a little too
compicated. I looked at an
Hi,
i have a problem, with my one query, this query is OK, in mysql 3.23,
but i update my database to mysql 5.0 and one query having a error
SELECT count( p.products_id ) AS total
FROM products_description pd, products p, products_to_categories p2c
LEFT JOIN manufacturers m
USING (
[EMAIL PROTECTED] wrote:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '.manufacturers_id = m.manufacturers_id )
LEFT JOIN specials s
USING ( p.produc' at line 4
What's the error in the query?!!?
Hi all
The company that I'm work for use very intensive MySQL dB on 32 bit
platform.
because of the limitation of Innodb on linux 32bit (kernel2.6) we've
decided to buy a bladecenter of IBM with 14 blades to replace the
current configuration.
we thought of buying 64 bit Opteron dual core dual
Dilipan,
thank you.
I think there indeed is a slight unprotected access in:
0x8158a17 innobase_mysql_print_thd + 471
We will investigate if it has been fixed in 4.1.xx.
Again, SHOW INNODB STATUS\G shows a very light load inside InnoDB. You
would get more informative output if you would
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and p.products_id = p2c.products_id
[EMAIL PROTECTED] wrote:
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and
Hello list,
After running my mysql server 4.1.14 with replication over some
months without any problem, suddenly the slave's sql thread crashes.
The error log says:
051215 17:29:49 [ERROR] Slave: Query caused different errors on master
and slave. Error on master: 'Incorrect key file for table
I've never noticed anything like a BEEP command in MySQL but I've never
looked either :-)
If you don't find a facility like that in MySQL, may I suggest an
alternative that will give you more than a mere Beep: it will play any .wav
file you like.
I use Ant for most of my scripting needs.
Dotan Cohen wrote:
I keep a lot of personal information in a MySQL database. I have a few
querys premade for the wife to use, but we have gotten to the point
where we need a solution for her to be able to run her own queries.
She is NOT about to learn SQL, and myPHPadmin is a little too
On 12/16/05, Greg Maruszeczka [EMAIL PROTECTED] wrote:
Dotan Cohen wrote:
I keep a lot of personal information in a MySQL database. I have a few
querys premade for the wife to use, but we have gotten to the point
where we need a solution for her to be able to run her own queries.
She is
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files with queries to update a MySQL base
periodically.
These scripts are run from the mysql line with the \. command.
I would like to have a BEEP command at the end of the script to get
a signal that processing the
Well it works on Mac OS X!
While there is no beep command, you can possibly get it to beep by selecting
the character code for a terminal beep (this is what the mysql client uses
internally)
Try out:
SELECT char(7);
--
MySQL General Mailing List
For list archives:
Harrison Fisk [EMAIL PROTECTED] wrote on 12/16/2005 11:54:01 AM:
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files with queries to update a MySQL base
periodically.
These scripts are run from the mysql line with the \. command.
I would like to have a
Greetings,
Thank you Dahl and Xiaobo. Here it is working for all to see. I
particularly like that it doesn't try to use a key again once it is
deleted.
Joe.
mysql use names;
Database changed
mysql create table people ( id mediumint unsigned not null
auto_increment,
- first
it work on xp :-)
On 12/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Harrison Fisk [EMAIL PROTECTED] wrote on 12/16/2005 11:54:01 AM:
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files with queries to update a MySQL base
periodically.
These
- Original Message -
From: Harrison Fisk [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, December 16, 2005 11:54 AM
Subject: Re: is there any BEEP command ?
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files
I am trying to maintain one master list of countries and the states
within those countries. I'd like to keep this info in a common
database, to be used by 2 or three other databases on the same host,
using foreign keys to make sure that all the country/state data matches
up to the master
sol beach wrote:
Why in the world are you trying to keep multiple copies of the data?
Why can't you just access the 'master database'?
On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote:
I am trying to maintain one master list of countries and the states
within those countries. I'd like to
Scott Plumlee wrote:
sol beach wrote:
Why in the world are you trying to keep multiple copies of the data?
Why can't you just access the 'master database'?
On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote:
I am trying to maintain one master list of countries and the states
within those
I've got a table on a mysql server (4.1.10a-nt) that I want to query
against some search criteria. The table contains approx. 9, 000
records, and will eventually grow to hundreds of thousands.
Here are the fields in the table...
id int(unsigned) auto_increment
firstName varchar(30)
lastName
Greetings,
I need to get a tool to create reports using mysql databases. It would be
great if the resultant reports could be run by themselves (not inside the
report development environment).
Anybody have any recommendations ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives:
JamesDR wrote:
Scott Plumlee wrote:
sol beach wrote:
Why in the world are you trying to keep multiple copies of the data?
Why can't you just access the 'master database'?
On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote:
I am trying to maintain one master list of countries and the
Hello,
Depending the level of sophistication you require, you might want to take a
look at:
- JasperSoft (Open Source)
- Crystal Reports
- If you're running Microsoft Reporting Services somewhere in your shop, I
think you can use it to plug into any JDBC compliant DB, but I might be
wrong.
If
Eric Grau wrote:
JamesDR wrote:
Scott Plumlee wrote:
sol beach wrote:
Why in the world are you trying to keep multiple copies of the data?
Why can't you just access the 'master database'?
On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote:
I am trying to maintain one master list of
I need to do this just once...
I have table zip_codes and table hardiness_zones
In this case, the key will be the actual zip codes.
hardiness_zones has two fields, zone_start and zone_end, these are all empty
in the zip_codes table. I just need to move the data over, where the zip
codes are ==.
Scott Haneda [EMAIL PROTECTED] wrote on 12/16/2005 08:46:29 PM:
I need to do this just once...
I have table zip_codes and table hardiness_zones
In this case, the key will be the actual zip codes.
hardiness_zones has two fields, zone_start and zone_end, these are all
empty
in the
I'm trying to import a large amount of data from an Access database containing
information about 9,000+ students in a school system. I've created a table
'student_list' to hold the data and issued the following command:
LOAD DATA INFILE 'home/karl/Student_List.csv' into table student_list
I think it might have something to do with the fact that I'm running the
NDB engine. I'm not sure... It doesn't seem to have the same problem
on Inno (another transaction-safe engine)
I think I need to send MySQL some info so they can try to duplicate it.
I'm wondering if anyone else
33 matches
Mail list logo