Hi
Thanks for the test, I try it and could get it worked ... so I dig a little
deeper and found that I had defined a unique index on data ! and doing
something like concat(data, ' copy') in the insert query solved the problem !
Thanks a lot for helping !
François
-Original Message-
I create a table using the follow statement:
CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM
3));
But server allow a insert statement as follow,why?
insert into test_check values(1,1,1,1);
Because MySQL does not support CHECK constraints.
Yes, it parses
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
After
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
Hi,
I am using Mysql
4.1.15(mysql-standard-4.1.15-sun-solaris2.8-sparc-64bit)on
a solaris machine. My application is running on
weblogic8.1 sp2.
I have configured the mysql connection pool on
weblogic and tested from configuration wizard. I am
facing issues when connecting to Mysql pool from my
Hi all,
We have a MySQL server used for a queueing system. It worked fine so far
but now we are experiencing some load problems couple with crashes.
The load ( around 5-7 ) is due, according to vmstat, to processes
waiting for the CPU. And it makes sense because the CPU is used 100%
most of
Hi
I need to update the 'products_id' field (shown below) by copying data from
a separate table but I can't use the 'UPDATE' query as each 'product_id'
entry relates to a specific 'products_model' row.
id / assembly_no / products_id / products_model
1 / 2313 / *** / CASEACERENTRY2
2 / 2313 /
Hi Cory - nice to see a fellow Lasso user here!
I've not use transactions myself but I think you might be having a problem with
autocommit.
http://dev.mysql.com/doc/refman/5.0/en/commit.html
HTH,
James Harvard
At 12:44 am -0700 15/12/05, Cory @ SkyVantage wrote:
I have a transaction that is
This should be working.
You can respond directly to me with schema and SQL that you are using and I
can try to reproduce in-house.
Thanks,
Jonathan Miller
Austin, Texas USA
Senior Quality Assurance Developer
MySQL AB www.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
/
Hello.
In what section of my.ini have you put default_character_set? You have
had to put it into [client] sections. Check that your program reads my.ini.
Now,i use default_character_set=utf8 in my.ini.
When i restart my server,character_set_database and
character_set_server change
I am designing an intranet for a law firm. Everything works fine. My problem
is that they need to include the documents that are relative to specific
cases in their database. These documents are on a different computer and I
cannot find how to link to them at their current location. I have found
On Thursday 15 December 2005 15:01, Darrell Troth wrote:
I am designing an intranet for a law firm. Everything works fine. My
problem is that they need to include the documents that are relative to
specific cases in their database. These documents are on a different
computer and I cannot find
Hi. If you place these documents in the appropriate directory on the
remote machine, a directory in which they can be served over the internet,
then you should be able to link to them using a hyperlink reference (i.e.
http://). The other option is to have PHP grab these documents for you
using
The document says it evaluates the 'expr', so I'm guessing it is only
function calls and arithmetic evaluation. Although I have tried selects
without any luck. It could probably be documented a little more clearly,
or event better yet...a supported feature.
Ed
-Original Message-
From:
Hi I need some optimization help.
I currently have this query SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch
I'm trying to think of the ways I can accomplish having a master
database of countries and states/provinces that I can reference in
several other databases.
I'd like to have a table of countries available for selection by the
users in a web app, but I'm not sure of the best way to then allow
Dilipan,
can you please post the complete .err log that also contains information
about the crashes. If there are stack traces, please resolve them.
The workload inside InnoDB does not look that big if what you have posted is
a typical SHOW INNODB STATUS\G. Is that the case?
What does
Hi;
Is there a formula I can go by in order to estimate how long it would
take to change over from innodb to myisam. Say for a 100meg file, a 5
gig table, etc.
Thank you;
-nat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Roberto Rodriguez Garrido wrote:
MySQL hangs every 30 minutes, it start to make a big process and when I
make a
show variables I get that values:
I don't use Linux myself but I read a post on the Postgres list a while back
about the Linux Out-of-memory Process Killer. This needs to be
Hello.
Please, could you provide the CREATE statement for you tables
and describe the relationships between their fields (it will
be good if you include sample data as well).
Matthew Batt wrote:
Hi
I need to update the 'products_id' field (shown below) by copying data
from a
Hello.
In your query BENCHMARK() doesn't execute the query, it is
passed just like a string to the second argument of the BENCHMARK().
Raimundo Sierra wrote:
It is not clear to me what benchmark really does. Example:
SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like
Hello.
Have you used bulk inserts or single line inserts?
In case of single inserts check your tests with bulk inserts
and increase the max_allowed_packet (both for server and client).
PgmHelmi wrote:
So no answer is an answer too!
As nobody wants to answer me, I have to suppose
Hello.
server version: 4.0.18-log ( I know it's old but we can't update for
the moment )
MySQL shouldn't die even under huge load, it is bad that you can't
update, and work with old version which has lots of bugs. Do you have
a stack trace in the error log? Please, resolve and send it
Hello.
In my opinion, master shouldn't have any problems, but slave can have
different data than master.
What would happen if i call a non-deterministic function that have been
declared deterministic.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection
Hi all,
The documentation states: MySQL has two Unicode character sets. You
can store text in about 650 languages using these character sets.
and goes on to show collations for UCS-2 and UTF-8. Does that mean
that UTF-16 and UTF-32 are not supported in MySQL (aside from MaxDB
supporting
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to automatically assign a unique sequence
number to each person. Is there a way to do this easily?
idname
1 bob jones
2 larry smith
3 henry rogers
Thanks for you help,
On Wednesday 14 December 2005 16:31, Joseph Alotta wrote:
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to automatically assign a unique sequence
number to each person. Is there a way to do this easily?
idname
1 bob jones
2
Howdy all.
I need to define a cursor in a stored procedure but I
don't know what the nature of the select statement is
going to be until runtime. I need to do something like
the code below:
IF (INSTR(city_name, ',') 0) THEN
DECLARE cur_neighborhood CURSOR FOR
SELECT DISTINCT neighborhood
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Gleb,
I should mention that I get no log errors and I even have it set to warn
does this mean mysql could die and not log the error? I have gone
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am adding to MySql
database. I would like to
Oops, forgot ',' at the end of the 3rd line.
Try this:
CREATE TABLE tablename (
`id` mediumint(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ''
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Greetings,
I have a bunch of names and addresses that I am
Gleb,
I watched the server during this error, the server continued to run...
it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam filter is better
Hi Stephen,
Unfortunately this is not a moderated list. Basically anybody can join,
send an email and then vanish. Nothing much to be done about it. I would
however note, this is only about the third time in a couple of years
listening that I've seen anything.
Regards
David Logan
Database
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where it
only returns just the date. What do i need to do to get it where is
(2005-12-11) and for that matter switch the date to us format. Here the
sql
on 12/15/05 4:51 PM, Payne at [EMAIL PROTECTED] wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where it
only returns just the date. What do i need to do to get it where is
(2005-12-11) and for
Payne wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where
it only returns just the date. What do i need to do to get it where is
(2005-12-11) and for that matter switch the date to us format.
Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting.
Payne
Sameer wrote:
Payne wrote:
Hi,
I having a problem doing a simple count with the way date is format
2005-12-11 21:49:36, what I am wanting to do is a simple count where
it only returns just the date. What do i
NO,no.
I want to say,if i my funciton is a non-deterministic function.But i define
then function with deterministic option.
for example:
-
create function test()
return int
DETERNINISTIC
routine_body
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' (Got timeout reading communication packets)
Any idea what this error is ? the interfaces show no errors from a
network
On Friday 16 December 2005 00:34, Stephen Cook wrote:
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Did the spam actually come through the list, or did it just fake the From to
make
43 matches
Mail list logo