I use MySQL database with utf8 character set and utf8_czech_ci
collation.
It works well on Linux server but when I try to
export the data and import into the same database but running on XP machine the
utf8 is
gone.Instead of a proper coding there are some strange characters.
I used
mysqldum
I can't get my head around this, but I think I should be able to do it
using just SQL without writing a program.
I have a simple table that looks like:
Rcd_Id: Integer;
Sale_Date: Date;
Sale_Amt: Double;
Each date will have 1 row with the total sales for that day.
and I want to sum the weekly
On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote:
> On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
> > Hi,
> >
> > just wondering if there a quick way to determine the # of rows in a
> > mysql table.
> >
> > I know I can do a count(*) but that would entail a table scan etc.
>
On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
> Hi,
>
> just wondering if there a quick way to determine the # of rows in a
> mysql table.
>
> I know I can do a count(*) but that would entail a table scan etc.
>
> I found out that I can do the query into the information_schema table,
> howe
Hi,
just wondering if there a quick way to determine the # of rows in a
mysql table.
I know I can do a count(*) but that would entail a table scan etc.
I found out that I can do the query into the information_schema table,
however, I don't get a consistent reading.
executing it multiple times, I
Glenn Kawesch
Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern
California's most experienced refractive surgery facilities. We have been
specializing in refractive surgery since 1989 and have completed
approximately 25,000 procedures.
Dr. Kawesch attended medical school at
Tej Kohli, Software
http://www.tejkohlifund.com
http://www.tej-kohli-foundation.com
http://www.tejkohlimagazine.com
http://www.tej-kohli-magazine.com
http://www.tejkohli-news.com
http://www.tejkohlionline.com
http://www.tejkohli-online.com
http://www.tejkohlitoday.com
Today noted entrepreneur an
Hi,
Initially i thought it solved the problem but then i realized that the
encoding done by PERL and this mysql function is different.I compated and
found that the difference is in a new line , in this function the encoded
output is all in one line and the same done via PERL via MIME::Base64 modu
In the last episode (Oct 27), David Hillman said:
> On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
> >MySQL is just giving you as much information as it can without
> >actually running the query. It knows how it will go about running
> >the query (so "type" is known absolutely), but it doesn't kn
Chris, it should be noted that a BLOB is binary data, not character
data like VARCHAR. BLOBs will act differently in terms of
case-sensitivity for example. The TEXT data type might be more what
you're looking for.
See http://dev.mysql.com/doc/refman/5.0/en/blob.html
for some more info on BLOB a
On Fri, 27 Oct 2006, Ferindo Middleton wrote:
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have
On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
MySQL is just giving you as much information as it can without
actually
running the query. It knows how it will go about running the query
(so
"type" is known absolutely), but it doesn't know exactly what it
will get
(so "rows" is only a gues
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much of a performance
difference between BLOB and VARCHAR(255)?
Thanks,
Chris.
--
MySQL General
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have a trigger on it, I'd like to iterate
through ind
In the last episode (Oct 27), David Hillman said:
> On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote:
> >My understanding of what is happening here is this:
> >
> >The 'rows' column of EXPLAIN output is an estimate of how many rows
> >MySQL thinks it will likely have to examine in a table to get you
On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote:
> Ow Mun Heng wrote:
> > Hi,
> >
> > I'm trying to load some data from a primary MySQL DB into a VMware image
> > for R&D purposes.
> > Instead of doing a mysqldump of nearly 10G of data, I would like to just
> > select a subset of it and l
On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote:
My understanding of what is happening here is this:
The 'rows' column of EXPLAIN output is an estimate of how many rows
MySQL thinks it will likely have to examine in a table to get your
answer. When there's an index, it will hopefully be able to
Ow Mun Heng wrote:
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for R&D purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into the VMware image.
man mysqldump
You will find it supports a where c
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for R&D purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into the VMware image.
I'm facing a snag with regard to NULL values.
I've tried doing
$mysql
A DECIMAL data type would probably be faster than a CHAR when doing
arithmetic, and an integer type would be faster yet. I don't know about
JOINs on indexed columns. I also don't know about substring and LIKE
operations with DECIMAL types, but they should be a lot faster with CHAR
than with integer
10061 means actively refused. Maybe check your event log around the same
time to see if mysql died?
On 27/10/06, mos <[EMAIL PROTECTED]> wrote:
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get
an error message "Can't connect to MySQL server on 'localhost' (10061)
Socke
I'll second what Chris said, which is that all the joined columns
should be of the same type for speed.
Also, your substring and LIKE comparisons are going to be problematic,
as those are string operations, not numeric, and MySQL is having to
convert all the decimal values to strings before compa
I run CHECK commands against all tables nightly. Our dataset is
small, so it's quick & easy; for large and/or static datasets daily
might be impractical. However, if you don't run CHECK regularly, you
don't know your data is good, and it's possible you might have
corruption for a long time befor
23 matches
Mail list logo
