Are both instances running the same MySQL version and release? Are they
MASTER and SLAVE, actively replicating? Are the InnoDB configurations
currently running on both servers the same?
--
*WB*
2014-09-06 6:00 GMT-03:00 Ajay Garg :
> Sorry, forgot to specify the engine.
> The table runs on InnoD
> Cc: mysql@lists.mysql.com
> Subject: Re: Strange Replication Behavior
>
> I believe the master.info and relay-log.info are only on the slaves and
> are specific to each slave (as each slave could be at a different point
> in the bin-log.)
>
> Thanks,
>
> Carl
&g
I believe the master.info and relay-log.info are only on the slaves and are
specific to each slave (as each slave could be at a different point in the
bin-log.)
Thanks,
Carl
On Jul 25, 2012, at 2:22 PM, Richard Reina wrote:
> I am trying to setup a new slave server and when I go to the master
Hello Lay,
On 2/22/2012 07:05, Lay András wrote:
Hi!
I have a table:
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL auto_increment,
`cucc` varchar(255) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `test` (`id`, `cucc
Thanks, it seems to be working now. I just discovered "WITH ROLLUP". It made me
very
happy on this project...
On 2/8/12 2:54 AM, Arthur Fuller wrote:
I'm not sure your method isn't working, but try changing changing the "to date" part to
"< '2012-02-08' " and see what you get.
HTH,
Arthur
I'm not sure your method isn't working, but try changing changing the "to
date" part to "< '2012-02-08' " and see what you get.
HTH,
Arthur
Try searching for a row that has a login_date of '-00-00 00:00:00'
- Derek
On Sep 9, 2011, at 8:52 AM, umapathi b wrote:
> Any update from anybody ?
>
>
> -- Forwarded message --
> From: umapathi b
> Date: Thu, Sep 8, 2011 at 4:28 AM
> Su
Nice Rik!
On Thu, Sep 8, 2011 at 3:19 PM, Rik Wasmus wrote:
> > I fired the update statement in a wrong way ..like this ..
> >
> > update user_info set login_date='2011-08-05 04:15:05' and user_id
> =16078845
> > limit 1 ;
> > ( I forgot to use where . instead of where I used and )
> > update us
> I fired the update statement in a wrong way ..like this ..
>
> update user_info set login_date='2011-08-05 04:15:05' and user_id =16078845
> limit 1 ;
> ( I forgot to use where . instead of where I used and )
> update user_info set login_date='2011-08-05 04:15:05' where user_id
> =16078845 limit
Here is the o/p after the update ..
user_id: 16078845
drivers_license: TEST1140DL
login_date: 2011-06-19 11:20:07
course_id: 1011
regulator_id: 10840
test_info:
completion_date: 2011-06-19 11:37:16
print_date: NULL
passwor
Can you lets us know what is the output of
select * from user_info where user_id=16078845;
On Thu, Sep 8, 2011 at 1:02 PM, umapathi b wrote:
> I wanted to change the login_date of one user . The original data of that
> user is like this ..
>
> select * from user_info where user_id = 16078845 \G
Your binary logging is set to statement format - the default, and the only one
available in older versions. Current versions also support row-based logging.
These formats have to do with safe replication, I recommend you check the
release notes and the online documentation for more information.
On 31.03.11 12.52, Andrew Braithwaite wrote:
Hi,
Mysql> select curdate() + interval 6 month - interval 6 month;
+-+
| curdate() + interval 6 month - interval 6 month |
+-+
| 2011-03-30
Hello,
There must have been some changes in the default interpretation
respective to foreign key attributes
If I add explicitly 'not null' to the columns host_id and admin_id
in test_nkomp_admin, it works like intended:
create table test_nkomp_admin
(
host_id int unsigned not null,
admin
Some more testing performed and it seems like problem with foreign key
reference indexing, see below:
create table test_nkomp_admin2
(
host_id int unsigned,
admin_id varchar(15),
foreign key (host_id) references test_nkomp (host_id) on delete
cascade on update cascade
)engine=innodb;
crea
On 10/28/2010 03:34 PM, misiaQ wrote:
Works fine on 5.0.87 (rows returned as expected).
Confirmed on 5.1.51-log.
Most likely problem with VARCHAR behavior, because this one works fine:
select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
The thing with the varchar was also
Works fine on 5.0.87 (rows returned as expected).
Confirmed on 5.1.51-log.
Most likely problem with VARCHAR behavior, because this one works fine:
select * from test_nkomp_admin where host_id=6 and trim(admin_id)='luke';
Regards,
m
-Original Message-
From: gregor kling [mailto:gregor.kl
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
sorry I went to sleep CEST here,
its created by default by MySQL
Cheers!
Claudio
On 8/1/2010 2:15 AM, Corey wrote:
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authenti
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
> login as root and remove 'empty' user ,issue:
>
> delete from mysql.user where user='';
> flush privileges;
>
> mysql authentication system is logging you on as 'empty' user.
>
> you will be ok after that ;)
>
Man, thanks a ton! That wa
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Claudio
On 8/1/2010 2:02 AM, Corey wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
> after login to mysql issue:
>
> select user();
> and
> select current_user();
> and post output
> you will see they dont match.
>
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
Enter password:
Welcome to the MySQL monitor. Command
after login to mysql issue:
select user();
and
select current_user();
and post output
you will see they dont match.
Claudio
On 8/1/2010 1:47 AM, Corey wrote:
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
Another thing I just noticed
In your first example you are using localhost, w
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
> Another thing I just noticed
>
> In your first example you are using localhost, which probably means you are
> connecting via network
>
> The second option you don't define a host, which means you're prolly using
> socket connection
Oh, whoo
Another thing I just noticed
In your first example you are using localhost, which probably means you are
connecting via network
The second option you don't define a host, which means you're prolly using
socket connection
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
On Saturday 31 July 2010 4:30:00 chaim rieger wrote:
> Just a stab but what's the max connect set to ?
>
Thanks a ton for the quick response - I'm at wits end, been working on
this for hours!
max_connections is set to 0.
(but it is also set to 0 on another server, which largely follows the
same
Just a stab but what's the max connect set to ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Steven,
On Wed, Jun 16, 2010 at 9:09 AM, Steven Staples wrote:
> Baron,
>
> Out of curiosity, do you (or anyone else) know what could be an issue with
> upgrading to even 5.0.93? or even the 5.1 branch?
>
> There are a lot of stored procedures/functions, as well as the fact that it
> is being re
il.com [mailto:baron.schwa...@gmail.com] On Behalf
> Of Baron Schwartz
> Sent: June 15, 2010 4:56 PM
> To: mysql@lists.mysql.com
> Subject: Re: Strange GREATEST() result in 5.0.32
>
> Steven,
>
> On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples wrote:
> > Hello all
> >
> >
Steven,
On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples wrote:
> Hello all
>
> I have a stored procedure that probably does a lot more than it should, but
> it works fine on my test server (which is running 5.0.67). When I moved it
> over to the production server, (which is running 5.0.32 and I
Does anyone have any sort of any idea on how to deal with this problem?
This is happening again and again and not all the time but randomly anytime.--Regards,Manasi Save
On Wed, 02 Jun 2010 06:46:56 -0400, Manasi Save
wrote:
Dear Venugopal, Here's the Sample
Java Code Which Calls stored procedur
Depending on your mysql version and environment, another solution might be
to switch to row-based binlogs. Make sure to read the documentation
thoroughly, though - there's a number of caveats.
On Wed, Jun 2, 2010 at 2:55 PM, Martin Gainty wrote:
>
> > In less technical terms, if the master goes
> In less technical terms, if the master goes faster than the slave, the slave
> will puke.
MG>then the master will have to teach the slave
MG>is the master the entrenched bureacucrat or is that the slave?
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington
Wed, Jun 2, 2010 at 2:22 PM, Jerry Schwartz wrote:
> >-Original Message-
> >From: machiel.richards [mailto:machiel.richa...@gmail.com]
> >Sent: Wednesday, June 02, 2010 3:56 AM
> >To: mysql@lists.mysql.com
> >Subject: RE: Strange errors / messages
>-Original Message-
>From: machiel.richards [mailto:machiel.richa...@gmail.com]
>Sent: Wednesday, June 02, 2010 3:56 AM
>To: mysql@lists.mysql.com
>Subject: RE: Strange errors / messages on slave server
>
>Hi All
>
> Just one other note on this issue ex
Dear Venugopal, Here's the Sample Java Code Which Calls
stored procedure :- //get the connection to databaseConnection dbConnection = getConnection(); //create the call
for procedureString procedureCallStmtStr = "Call XYZ()"; //create callable statement objectCallableStatement cs =
conn.prepareCal
Hi All
Just one other note on this issue experienced.
I used google to try and find some solutions / clues and all the
suggestions are to increase the innodb buffer pool size.
This was however recently done on the database to increase this to
4Gb already.
However
Stored procedures are not executed like a query.
They are executed thru a Call { procedure} method.
Please check the same or let us know how you are executing the Query/Calling
the Procedure.
Regards,
VR Venugopal Rao
--- On Fri, 28/5/10, Manasi Save wrote:
From: Manasi Save
Subject: Stran
mysql Version :- 5.1.42-community-log
mysql Connector/J Version :- mysql-connector-java-5.1.6-bin.jar
Sample Java Code Which Calls stored procedure :-
//get the connection to database
Connection dbConnection = getConnection();
//create the call for procedure
String procedureCallStmtStr =
Hello Manasi,
If possible can you please send in the code that you mentioned (procedure or
trigger).
Please give a detailed technical explanation explaining the query which you
used from command line and the query used in the procedure. Please mention
the table structure, show table status and fe
2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;
you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure (or
So, as a followup, I ran mysqldump on the actual server (with the output
directed over AFP to another machine on the network) -- as opposed to running
mysqldump on the destination server and connecting to the databases over TCP/IP
(both are running 5.1.39 PPC 64-bit). *That* dump file imported O
Except that, in my case, both machines are running 5.1.39. Mac "OS X" PPC
64-bit. I tried importing another, different dump file of the same database,
and this time mysql returned a different error:
Sat Nov 21 13:16:20 -- Minas-Tirith :: mysql -u root -p < dump_file.sql
Enter password:
ERROR
There is a bug in mysqldump that prevents mysql from version 5.0.80 from
importing dumps from a old version of mysqldump.
I had this verified by MySQL support.
You can have a look at this bug: http://bugs.mysql.com/bug.php?id=41486
Cheers
Claudio
2009/11/21 René Fournier
> It's just odd, bec
It's just odd, because that error was on 5.0. I'm running 5.1.39 -- surely
enough time for the MySQL devs to fix it right?
Could it be with extended inserts that the max statement length is greater than
the default 16MB max allowed packet? I'm increasing that value to 256 MB and
going to try ag
Yes, still exhibits this problem -- although at a different line in the file.
(Seems random.) I should also mention, the backup is running across a local
network. The machine the starts automysqlbackup (and internally, mysqldump)
connects over TCP/IP to the database server. I am going to try run
Have you tried dumping that table manually using mysqldump on the command line
to confirm it's not an issue with automysqlbackup?
Regards,
Gavin Towey
-Original Message-
From: René Fournier [mailto:m...@renefournier.com]
Sent: Friday, November 20, 2009 8:31 AM
To: mysql
Subject: Strange
Nicolas Sebrecht a écrit:
> mysql> CREATE DATABASE dbtest;
> mysql> DELIMITER $$
> mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
> mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
> -> BEGIN
> -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1));
> -> END$$
> It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
Hello,
Marten, in my experience, these are most often temporary files leftover
from an incomplete operation.
They might be from a long-running query that was canceled, or from a
table repair operation that errored out or was interrupted.
In my experience it is safe to delete them, provided
Marten, in my experience, these are most often temporary files leftover from
an incomplete operation.
They might be from a long-running query that was canceled, or from a table
repair operation that errored out or was interrupted.
In my experience it is safe to delete them, provided you take care
Baron Schwartz wrote:
On Dec 20, 2007 7:16 AM, Sharon <[EMAIL PROTECTED]> wrote:
Baron Schwartz wrote:
Hi,
On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
Hello all,
Given this table:
DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
CREATE TABLE `maprimary`.`tbl_locales_ip2l`
On Dec 20, 2007 7:16 AM, Sharon <[EMAIL PROTECTED]> wrote:
>
> Baron Schwartz wrote:
> > Hi,
> >
> > On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
> >> Hello all,
> >> Given this table:
> >> DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
> >> CREATE TABLE `maprimary`.`tbl_locale
Baron Schwartz wrote:
Hi,
On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
Hello all,
Given this table:
DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
CREATE TABLE `maprimary`.`tbl_locales_ip2l` (
`ipStart` int(10) unsigned zerofill NOT NULL default '00',
`ipEnd`
Hi,
On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote:
> Hello all,
> Given this table:
> DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`;
> CREATE TABLE `maprimary`.`tbl_locales_ip2l` (
>`ipStart` int(10) unsigned zerofill NOT NULL default '00',
>`ipEnd` int(10) unsig
I'll defer to you.
At 01:00 PM 5/28/2007, Baron Schwartz wrote:
>Dave Dyer wrote:
>>Thanks, it turns out you are exactly right. I rewrote
>>the query to keep the "on" immediately following the "left join"
>>and it now works as I wish.
>>I'll have to read up on "cross join", but if there
>>is a m
Dave Dyer wrote:
Thanks, it turns out you are exactly right. I rewrote
the query to keep the "on" immediately following the "left join"
and it now works as I wish.
I'll have to read up on "cross join", but if there
is a mysql bug here, it is that the parser that what I
wrote as "left join" was
Thanks, it turns out you are exactly right. I rewrote
the query to keep the "on" immediately following the "left join"
and it now works as I wish.
I'll have to read up on "cross join", but if there
is a mysql bug here, it is that the parser that what I
wrote as "left join" was turned into a cro
Dave Dyer wrote:
I'm trying to construct a join, but the effect I want seems
to be impossible to achieve. In this schema, the "uid"
field is unique in the "players" table, but not in the "ranking"
table (one player per uid, multiple rankings per player)
I want to select player names and rankin
Jason,
I assume that your principal databases are INNODB databases.
Regards
On 1/17/07, Jason J. W. Williams <[EMAIL PROTECTED]> wrote:
Hi Juan,
Just wanted to touchbase and see if you had any suggestions based on
the my.cnf and machine config. Thank you in advance.
Best Regards,
Jason
Hi Juan,
Just wanted to touchbase and see if you had any suggestions based on
the my.cnf and machine config. Thank you in advance.
Best Regards,
Jason
On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
Jason,
Send me a my.cnf in order to view your configuration ( using innodb storage
[EMAIL PROTECTED] ("Paul Halliday") wrote in
news:[EMAIL PROTECTED]:
> Could you expand a little on how that works?
USE test;
DROP TABLE IF EXISTS event;
CREATE TABLE event (timestamp DATETIME NOT NULL);
INSERT INTO event (timestamp) VALUES
('2007-01-09 20:02:15'),
('2007-01-09 20:02:15'),
('200
Could you expand a little on how that works?
I am starting to think that I wont be able to get the results I need
without post processing.
Looking at the results:
...
| 2007-01-09 20:02:15 |
| 2007-01-09 20:02:15 |
| 2007-01-09 20:03:20 |
| 2007-01-09 20:08:33 |
| 2007-01-09 20:08:33 |
| 2007-01
[EMAIL PROTECTED] ("Paul Halliday") wrote in
news:[EMAIL PROTECTED]:
> I am trying to deal with empty values so that I can graph data over a
> 24 hour period without gaps.
Have a look here:
http://forums.mysql.com/read.php?10,133603,133607#msg-133607
--
felix
--
MySQL General Mailing List
To
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
cc
Subject
Re: Strange query.
e.c1?
Giving me errors..
On 1/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
> Try something like this:
>
> SELECT
> SUM(CASE when e.c1 is null then 0 else 1 end) as counts, HOURS
01-11
04:00:00' AND sid=1
group by HOURS.hour
Donna
"Paul Halliday" <[EMAIL PROTECTED]>
01/10/2007 09:48 AM
To
"Brent Baisley" <[EMAIL PROTECTED]>
cc
mysql@lists.mysql.com
Subject
Re: Strange query.
That query doesn't return empty values. Ju
Ugh. My perl isn't quite right there. Here's a bit better (e.g.
working) example:
If you create the table, then put this in "populate_hours.pl":
BEGIN
#!/usr/bin/perl
$counter = 0;
while ($counter < 100) {
print "INSERT INTO all_hours (date_hour) VALUES (
DATE_ADD('2000-01-01 00:00:00'
One of the most puzzling and challenging things to do with SQL can be
to show what's NOT there, as you're trying to do.
Many people opt to do such a report in their favorite scripting
language for this reason, as one can easily increment timestamps by a
given amount and re-do the query. Can be r
That query doesn't return empty values. Just to clarify what I want as
the result:
My initial query was this,
mysql> select count(*),DATE_FORMAT(timestamp,'%H') AS hour FROM event
WHERE timestamp between '2007-01-10 04:00:00' and '2007-01-11
04:00:00' AND sid=1 GROUP BY hour;
+--+--+
You can't join on the result of calculations in the field selection. The result is not associated with any table. So the problem
isn't so much with the date_format statement, but that you are joining on HOURS.hour the timestamp, not HOURS.hour the DATE_FORMAT.
I would think you would be getting a
Hi Mark,
Thank you very much for replying! I did open a bug for this last night
after I e-mailed:
http://bugs.mysql.com/?id=25460
As for reproducing, we're working on that at the moment. This happened
on a production system, so we worked first to stop the hemorrhaging.
Currently, we moved the h
Hi Jason,
Jason J. W. Williams wrote:
Hello,
We've been getting random crashes on our MySQL servers running MyISAM
tables for the last month, its gotten very bad in the last two weeks.
This has occurred on both 5.0.27, 5.1.11 and 5.1.15-nightly20070103.
It crashes the tables with high queries
LOL - Now I feel silly.
Thanks that worked.
R
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, December 15, 2006 5:37 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: RE: Strange table problem
At 03:44 AM 12/15/2006, Ruan wrote:
>Hi,
>
>
At 03:44 AM 12/15/2006, Ruan wrote:
Hi,
The dump revealed this:
+
| View | Create View
| test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY
DEFINER VIEW `test` AS select `beta_users`.`user_id` AS `user_id`,`b
PROTECTED]
Sent: Friday, December 15, 2006 10:43 AM
To: Ruan
Cc: mysql@lists.mysql.com
Subject: Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
>Hi everyb
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop i
Hi,
Guys! Stange!!!
I am replying to my own post just to tell you that after posting the
previously message, I restarted my system and ran my VB6 program. To
my surprise, MySQL__IS__ executing the same stored procedure,
that it was previously complaining about, again and not complaining
flyerheaven - Barry Krein napsal(a):
Dušan Pavlica schrieb:
Barry napsal(a):
Dušan Pavlica schrieb:
Hello,
could someone help me to explain and resolve this error? Or maybe
it is a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_
Dušan Pavlica schrieb:
Hello,
could someone help me to explain and resolve this error? Or maybe it is
a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_cs NOT NULL default '',
`CisloProvozu` char(6) collate latin2_czech_cs NOT NULL
So what you are doing here is sending some sql statements from the dump to
mysql CLI, so all that in going into the pipe is just plain text output from
the dump, it does pass in any auth parameters, so for your script to run
just add the required user, pwd etc as arguments to the mysql cli utility,
What does SHOW CREATE TABLE give you?
-Sheeri
On 3/11/06, Holger Sunke <[EMAIL PROTECTED]> wrote:
> Hallo,
>
> is there a way of maintaining Memory tables or rebuilding indexes?
>
> I have a "big" memory table with about 300k rows, 12 Attributes, 7
> BTREE-Indexes and a PRIMARY KEY (Hash index).
Sorry I apologize, it has to do something with my apache.
-Original Message-
From: James Harvard [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 11:46 AM
To: Ngim
Cc: mysql@lists.mysql.com
Subject: Re: Strange insert
I assume you did not intend to post to this list, but
I assume you did not intend to post to this list, but if you did then this is a
problem with your application code, not with MySQL, so I'm afraid this list is
not the best place to ask.
James Harvard
At 11:19 am -0600 5/1/06, Ngim wrote:
>Hi all,
>
>I have an one insert statement in my hub pag
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE SET = -1
when the is 0 gives me
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
> mysql 5.0.15-standard
> UPDATE SET = -1
> when the is 0 gives me 4294967295
> is integer(10) unsigned...
>
> maybe it would be more logical the expression to evaluate as 0, insted 2^3
mysql 5.0.15-standard
UPDATE SET = -1
when the is 0 gives me 4294967295
is integer(10) unsigned...
maybe it would be more logical the expression to evaluate as 0, insted 2^32
..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
I don't think that this behaviour is very surprising. If you carry out a
mathmaticical operation that returns a result outside the data type's range
then it _must_ give you an incorrect result. The only alternative would be to
throw an error.
I know that the manual documents that after an auto_
Hello.
On both 4.1.16 and 5.0.17 I've got the same results, however not 2^32,
but 18446744073709551615. 4.0 is deprecated and its results could be
different. Please provide exact SQL statement which you're using if you
still think that MySQL behaves weirdly with unsigned integers. In the
man
(response interspersed)
Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote on 10/17/2005 07:49:36 PM:
> Just recently (possibly since upgrading to MySQL 5.0.13 RC), I've been
> getting the following error with queries like the one below.
>
> Unknown column 'photos.id' in 'on clause' (1054)
>
> SEL
Claire Lee wrote:
> This simplified my second expression in the if
> statement. Thank you. But the query still doesn't sort
> by the numbers, here's the result:
>
> mysql> select distinct secname, date from optresult
> where secname like 'swap%' a
> nd date like '2005-09-2%' order by if (secname l
This simplified my second expression in the if
statement. Thank you. But the query still doesn't sort
by the numbers, here's the result:
mysql> select distinct secname, date from optresult
where secname like 'swap%' a
nd date like '2005-09-2%' order by if (secname like
'swap%',abs(substring(secnam
[EMAIL PROTECTED] wrote:
Claire Lee <[EMAIL PROTECTED]> wrote on 09/27/2005 03:48:11 PM:
I need to order a few names by the number following
the main name. For example swap2, swap3, swap10 in the
order of swap2, swap3, swap10, not in swap10, swap2,
swap3 as it will happen when I do an order
Claire Lee wrote:
> I need to order a few names by the number following
> the main name. For example swap2, swap3, swap10 in the
> order of swap2, swap3, swap10, not in swap10, swap2,
> swap3 as it will happen when I do an order by.
... ORDER BY ABS(SUBSTRING(secname,5)) ...
will insure tha
Claire Lee <[EMAIL PROTECTED]> wrote on 09/27/2005 03:48:11 PM:
> I need to order a few names by the number following
> the main name. For example swap2, swap3, swap10 in the
> order of swap2, swap3, swap10, not in swap10, swap2,
> swap3 as it will happen when I do an order by.
>
> So I came up w
Try this
mysql> select distinct secname, date
-> from optresult
-> where secname like 'swap%'
->and date like '2005-09-2%'
-> order by if(secname like 'swap%',
-> (mid(secname,5,20)+0),
-> secname);
+--++
| secname | d
Harald Falkenberg wrote:
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db tabl
[snip]
Hello. Yes, there are. In fact, other records have more data for this
field in them and inserts for those records never threw an error.
[/snip]
Is the data for the other fields larger than usual? This field may be
smaller, but the cumulative row length (the combined size of every
field) is
Hello. Yes, there are. In fact, other records have more data for this
field in them and inserts for those records never threw an error.
- Asad
On Tue, 10 May 2005, Jay Blanchard wrote:
> [snip]
> Hello. I am receiving the following error when trying to insert into a
> field of type text:
>
> #1
> #1030 - Got error 139 from storage engine
>
> The data to be inserted should fit easily into a text field. In fact, this
> error only occurs for a particular record and other records with much
> larger data sets are not throwing the same error. Has anyone experienced
> something similar? I checke
1 - 100 of 350 matches
Mail list logo
