Hi,
If you don't care to much how the data look like - just run once of update and
replace it with some random stings. If you do however, and you still want to
telephone numbers looks like telephone numbers, what I can suggest is to use a
data generator like this one
Older MySQL Exams to Retire
https://blogs.oracle.com/certification/entry/0875_01
regards,
m
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com;
Sent: 6:37 PiÄ…tek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation
( ... cut ...)
but, my desktop calculator gives the result 548.60
1. your desktop calculator is wrong
2. correct result is 548.595, variations
Shawn Green (MySQL) shawn.l.gr...@oracle.com pisze:
(...)
You can be the correct
user, using the correct password but you may not be allowed (by the host
pattern) to login from the machine from which you are attempting to login.
It could be the case you got your account setup as
h...@tbbs.net wrote:
2011/05/12 15:15 +0200, misiaq
h...@tbbs.net wrote:
(...)
Is the optimizer so clever as to set that test outside the expression, and
only then evaluate it when houmuch and SharePrice are not equal?
Try it yourself:
mysql explain extended select * from
h...@tbbs.net wrote:
(...)
Is the optimizer so clever as to set that test outside the expression, and
only then evaluate it when houmuch and SharePrice are not equal?
Try it yourself:
mysql explain extended select * from table1;
and then
mysql show warnings;
You will see the
Corrupted table and / or index.
A number of reasons could cause this issue:
http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html
Regards,
m
Adarsh Sharma adarsh.sha...@orkash.com pisze:
Thanks , but there is no trigger on tables.
Even I solved the problem after googling a
Hi,
It's quite simple and quick change in *nix. But would recommend to check your
server performance first (processlist, tmp tables, slow query log etc).
Regards,
m
Jerry Schwartz je...@gii.co.jp pisze:
You are seeing *NIX error messages. You need to increase the operating system
settings
Hal Vaughan h...@halblog.com wrote:
I'm having the strangest issue. I am using a Perl program to test out some
other Perl programs and all the Perl connections with MySQL are normal, as
in I use the standard interface. But in the test program I'm just using this:
[... cut ...]
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
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;
I don't think that SUM will work for varchar columns.
If I got your point right - you need to use WITH ROLLUP grouping
http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
see second example on that page.
regards,
m
-Original Message-
From: Tompkins Neil
select ci.*, ct.* from (select name, countrycode from city) ci, country ct
where ci.countrycode = ct.code
Regards,
m
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 1:23 PM
To: [MySQL]
Subject: Retrieve three columns in sub
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
The entire page is highly recommended due to the number of helpful
information.
Regards,
m
-Original Message-
From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com]
Sent: Tuesday, April 13, 2010 10:56 AM
To: River wubx
Cc: mysql;
For such strongly database related logic sometimes its handy to keep all the
update and insert queries inside the stored procedures. All the validation
you mention in that case should be also build in the procedure.
Regards,
m
-Original Message-
From: Tompkins Neil
You mean the SET data type..?
http://dev.mysql.com/doc/refman/5.0/en/set.html
Regards,
m
-Original Message-
From: muralikrishna g [mailto:muralikrishn...@gmail.com]
Sent: Friday, February 05, 2010 10:38 AM
To: mysql@lists.mysql.com
Subject: how to update entire column with different
]
Sent: Friday, February 05, 2010 10:55 AM
To: 'misiaQ'
Subject: RE: how to update entire column with different values
Whats the set data type I don't know... what I have to do is.. I have to
update the years... for a entire column... like
Update table1
Set year= if(id=1, then 2005
Instead of:
- else 2003
- where id between 1 and 6;
Try
- else 2003
- end
- where id between 1 and 6;
Or maybe even:
mysql update table1
- set year=case when id IN (1, 2, 4) then 2000
- when id IN(2, 4, 6) then 2001
- else 2003
- end
- where id between 1
If ID column is primary key and auto increment as you said, it cant be equal
to zero.
You got a query which reads:
UPDATE columns WHERE false
There is no chance for any updates.
http://dev.mysql.com/doc/refman/5.0/en/update.html
Regards,
m
-Original Message-
From: Victor Subervi
Hi,
If the efficiency is the key factor I would suggest to create a trigger on
insert and update and mark the rows in a separate column instead of
executing some fancy string checks during select.
Regards,
m.
-Original Message-
From: nikos [mailto:ni...@qbit.gr]
Sent: 19 November 2009
Try this:
select * from country where LEFT(Name, 1) between 'F' and 'P';
Regards,
m.
-Original Message-
From: Dave M G [mailto:d...@articlass.org]
Sent: 04 November 2009 14:52
To: mysql@lists.mysql.com
Subject: Alphabetical search to and from
MySQL,
This should be a fairly simple
'
On Wed, Nov 4, 2009 at 10:15 AM, misiaQ mis...@poczta.fm wrote:
Try this:
select * from country where LEFT(Name, 1) between 'F' and 'P';
Regards,
m.
-Original Message-
From: Dave M G [mailto:d...@articlass.org]
Sent: 04 November 2009 14:52
To: mysql@lists.mysql.com
Subject
Or :
alter table users add first_f_name char(1) not null;
create index first_f_name_idx on users (first_f_name);
update users set first_f_name = left(first_name,1);
... and don't forget the trigger on insert, update to keep that new column
always up to date.
Regards,
m.
23 matches
Mail list logo