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
http://www.generatedata.com
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"
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 (548.59 and 548
"Shawn Green (MySQL)" 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 username@localhost and it
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 "
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
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" pisze:
> Thanks , but there is no trigger on tables.
>
> Even I solved the problem after googling a link but cannot unders
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" pisze:
> You are seeing *NIX error messages. You need to increase the operating system
> settings that control
"Hal Vaughan" 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 ...]
Transaction isolati
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
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
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 [mailto:neil.tompk...@
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 qu
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; 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 [mailto:neil.tompk...@
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 b
rali_kris...@arthaoptions.com]
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
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 valu
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 [mailto:
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 0
> 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.
'FAA' and 'PZZ'
On Wed, Nov 4, 2009 at 10:15 AM, misiaQ wrote:
> Try this:
> select * from country where LEFT(Name, 1) between 'F' and 'P';
>
> Regards,
> m.
>
> -Original Message-
> From: Dave M G [mailto:d..
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 quest
23 matches
Mail list logo
