Hi, I took the MySQL core and professional certification exams and failed both, so now
I want to go again, but does anyone have any tips or techniques for studying that
they've found useful?
-
Do you Yahoo!?
Express yourself with Y! Messenger! Fre
You can't use a value calculated in the SELECT clause as a constraint in
the WHERE clause (its a chicken & egg problem); the WHERE clause is what
determines the values in the SELECT clause. What you want is the HAVING
clause which is applied *after* all matching rows have been found:
SELECT p.nam
What version of MySQL are you running? Version 4.1.x and 5.0.x offer many
more potential solutions than the earlier versions, which don't support
subqueries.
Rhino
- Original Message -
From: "Laszlo Thoth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 24, 2004 10:31
I'm trying to construct a query and running into either a limitation of the SQL
language or (more probably) a limitation in my *comprehension* of the SQL
language. Here's a simplified version of my data set:
===
CREATE TABLE people (
name varc
At 03:28 PM 9/24/2004, you wrote:
Hello,
I have a C++ application which spits out data continuously which I need to
load into a database. The data rate is roughly 50,000 rows * 50 bytes/row
per second. I use LOAD DATA INFILE (the quickest way I can find
to load data into the db) to load these data
Thanks Jim. Great suggestions.
I will try both to see which one is better for my
case.
Appreciated your help.
Monet
--- Jim Grill <[EMAIL PROTECTED]> wrote:
> > Yeah. I am moving data from mysql server to sql
> > server.
> > Because I have single quote in some strings, it
> > generated errors whe
> > I've been searching long and hard and have come across
> > a few techniques for changing text entries with lower
> > case (entered by web user) and changing them to have
> > first letter capitalized.
> >
> > in php. ucfirst
> > in java capitalize
> >
> > But I'm not having success on t
Hello,
I have a C++ application which spits out data continuously which I need to
load into a database. The data rate is roughly 50,000 rows * 50 bytes/row
per second. I use LOAD DATA INFILE (the quickest way I can find
to load data into the db) to load these data into MyISAM tables which is
ac
> Yeah. I am moving data from mysql server to sql
> server.
> Because I have single quote in some strings, it
> generated errors when I ran mysqldump scripts in sql
> server to import data in.
> i.e. strings Here's, Martin's ,... caused trouble.
> Does that mean sql didn't recognize escaped single
>
>
> Brian J.S. Miller wrote:
>
>>
>>Walt,
>>
>>The tables are ISAM type. These are some seriously old tables
>> (originally
>>from version 3.21) and were never updated to type MyISAM. Despite
>>frequent updates to mysqld.
>>
>>There is a program isamchk which is similar to myisamchk, but it ret
Brian J.S. Miller wrote:
Walt,
The tables are ISAM type. These are some seriously old tables (originally
from version 3.21) and were never updated to type MyISAM. Despite
frequent updates to mysqld.
There is a program isamchk which is similar to myisamchk, but it returns
the error "___ is not a
within Java, you'll need to create a new String object, like
String textCapitalized = new String;
and
then when you receive the web text input (say you call it webText)
you do the capitalize function on webText and set it to textCapitalized,
like
textCapitalized = capitalizeFCT(webText);
and then
Brian J.S. Miller wrote:
Brian J.S. Miller wrote:
Hello,
I've read over every archived posting I can find about this problem and
havne't found a solution that seems to work for me.
Here is the deal:
I had a server crash. Hard.
I re-built the server (i686, Debian install, kernel 2.4.18).
I rest
Yeah. I am moving data from mysql server to sql
server.
Because I have single quote in some strings, it
generated errors when I ran mysqldump scripts in sql
server to import data in.
i.e. strings Here's, Martin's ,... caused trouble.
Does that mean sql didn't recognize escaped single
quote?
Thank
> Brian J.S. Miller wrote:
>
>>Hello,
>>
>>I've read over every archived posting I can find about this problem and
>>havne't found a solution that seems to work for me.
>>
>>Here is the deal:
>>I had a server crash. Hard.
>>I re-built the server (i686, Debian install, kernel 2.4.18).
>>I restored t
> Is there nothing you can do with
> --fields-terminated-by=...
> --fields-enclosed-by=...
> --fields-optionally-enclosed-by=...
> --fields-escaped-by=...
> --lines-terminated-by=...
As I mentioned, those options **only** apply when using the "-T" option which creates
a tab delimited dump fi
Heikki,
I was collecting information about the incident and preparing a detailed
bug report, when decided to repeat the whole process from within
the mysql client, (I mean the original text mode client that comes with
the server installation)
I was surprised to see that problem DOES NOT occur fro
Jim - He needs to change the format because he isn't exporting from one
MySQL database to another His destination database doesn't like the
escaped single quotes.
Here is the manual page for mysqldump:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Is there nothing you can do with
--fie
Sebastian Geib wrote:
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodid<>cds.cds_catalog.prodid;
Whenever I'm running it, it pro
Brian J.S. Miller wrote:
Hello,
I've read over every archived posting I can find about this problem and
havne't found a solution that seems to work for me.
Here is the deal:
I had a server crash. Hard.
I re-built the server (i686, Debian install, kernel 2.4.18).
I restored the data for 1 database f
> Hello everyone,
>
> In mysqldump output txt file, all datetime, varchar,
> text fields value are surrounding by single quotes. Is
> there any way that the single quotes can be replaced
> by double quotes in the txt file?
> Furthermore, if you have a single quote in text field,
> it will automatic
You have two good opportunities to fix your text before it hits the
database. Your first chance is on the submitting form. Use JavaScript to
modify the submitted data.
Your second opportunity is server-side and is in the script on the page
that handles your form's submission. That's also the pa
Hello everyone,
In mysqldump output txt file, all datetime, varchar,
text fields value are surrounding by single quotes. Is
there any way that the single quotes can be replaced
by double quotes in the txt file?
Furthermore, if you have a single quote in text field,
it will automatically replaced b
> I've been searching long and hard and have come across
> a few techniques for changing text entries with lower
> case (entered by web user) and changing them to have
> first letter capitalized.
>
> in php. ucfirst
> in java capitalize
>
> But I'm not having success on the database side.
I've been searching long and hard and have come across
a few techniques for changing text entries with lower
case (entered by web user) and changing them to have
first letter capitalized.
in php. ucfirst
in java capitalize
But I'm not having success on the database side.
Everything the
* Seena Blace
> How to migrate mysql database from one box to another box ?
You could use mysqldump on the source box, and the standard client to import
the dumped file on the target box:
http://dev.mysql.com/doc/mysql/en/mysqldump.html >
There are other options, depending on the table handler u
Hi people,
Well, I managed to set apache (1.3.31) + php (5.0.1) + mysql (5.0.1) on
my laptop and it works find :-)
I am tried the same set up on my desktop and I could not get it to work.
I can get Apache(1.3.31) + PHP (4.3.8) to work together and mysql
(5.0.1) and php can see mysql but every
Hi,
How to migrate mysql database from one box to another box ?
thanks
-Seena
-
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
Always CC the list. That way everyone gets a chance to help. Problems like
I had yesterday with my mail router won't slow down a response as everyone
will have seen it. Understand?
This latest post is rather disjointed...
You show us a sample SELECT statement but tell us that an EXPLAIN SELECT
Hello,
I've read over every archived posting I can find about this problem and
havne't found a solution that seems to work for me.
Here is the deal:
I had a server crash. Hard.
I re-built the server (i686, Debian install, kernel 2.4.18).
I restored the data for 1 database from tapes to use for te
On Fri, 2004-09-24 at 11:05, Jim Grill wrote:
> > Hi!
> >
> > I sent this question to the mysql license email, but it's been more than
> > 3 days since then and I haven't received a answer... So I will ask it
> > again here, to see if someone can clarify this issue.
> >
>
> Are you actually distri
> Hi!
>
> I sent this question to the mysql license email, but it's been more than
> 3 days since then and I haven't received a answer... So I will ask it
> again here, to see if someone can clarify this issue.
>
Are you actually distributing MySQL with your application? Or are you just
using inst
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodid<>cds.cds_catalog.prodid;
Whenever I'm running it, it produces the error mentio
* DeRyl
> * Roger Baklund
> The first thing to notice: "Using temporary"... this is to be avoided, if
> possible.
>
> ## how is the correct way to avoid that?
Depends, in this case I think it is because of the DISTINCT.
> The first table read is klientslowo based on the criteria
> klientslowo.kli
Hi,
Is there any way to handle backup in the mysql 4.0 classic with out
innoDB?. And may i know the differences between transaction - safe and transaction
-full locks ?. And what is the best way to confirm whether innodb is running or not in
mysql 4.0?.
Thanks,
Narasimha
-
Hi!
I sent this question to the mysql license email, but it's been more than
3 days since then and I haven't received a answer... So I will ask it
again here, to see if someone can clarify this issue.
We are small hardware store. We have developed our own POS software to
fill our necessities
Hello,
I have a very short question
I was wondering if there are any differences in how MySQL behaves on
Windows and Linux.
(i.e. difference in performance, slightly different syntaxetc)
If anyone has a link to such documentation it would be greatly appreaciated.
Thanks,
--
Yves Arse
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
Nevermind my last post, I found the workaround to disable foregin_key_checks
during import; interesting.
Here is a small example:
set foreign_key_checks=0;
CREATE TABLE
Thank you for valuable feedback!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_
How about:
update table1 set beds1=(@TEMP:=beds1), beds1=beds2, [EMAIL PROTECTED]
Seems to work for me.
= original message follows ==
To: [EMAIL PROTECTED]
From: zzapper <[EMAIL PROTECTED]>
Subject: Re: A query to swap the data in two fields
Date: Thu, 23 Sep 2004 20:01:09
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
This will help us determine if it's a bug and fix if it is.
Thanks, this hit a pretty interesting nail for me: I can dump it, but I can't load
the dump into the datab
On Sep 24, 2004, at 4:03 AM, MaFai wrote:
Dear [EMAIL PROTECTED]:
Here's my setting:
innodb_data_file_path = ibdata1:10M:autoextend
Now the ibdata1 has been grow up to 1.3G
We try to add more ibdata file to store the data by the following
setting.
innodb_data_file_path = ibdata1:1500M;ibdata2:1500
Hi there,
I'm using mysql on a Mandrake 9.2 server. As I wanted to move to InnoDB
tables and the standard mysql-4.0.15 on Mandrake doesn't have that
compiled in, I obtained the most recent (4.0.21) version from mysql.com,
uninstalled the Mandrake version and installed the mysql.com one. I
assumed
At 02:04 AM 9/24/2004, Egor Egorov wrote:
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>> > And we've had good but limited experiences so far with 64 bit FreeBSD
>> > 5 on amd64 (also a quad w/32GB).
>>
>> Somewhere in this list I've seen controversial reports about
FreeBSD/amd64.
>> Seems like it's
Hi,
I found that the Intel C++ version needed some libraries which weren't on my
RH9.0 system (this was when upgrading to 4.1.4g):
libcprts.so.5
libcxa.so.5
libunwind.so.5
This seems to have been reported many times e.g.
http://bugs.mysql.com/bug.php?id=4408
The resolve was to get the lib
"Jim McAtee" <[EMAIL PROTECTED]> wrote:
The link to manual was already suggested, but I may also suggest you
to try run the application on 4.0 anyway. It should work seamlessly.
> Can I run two different versions of MySQL on the same server? I've got a
> commercial application for which the v
Juri Shimon <[EMAIL PROTECTED]> wrote:
> Using 'int not null' make next enum (using cp1251) corrupted in
> mysqldump output on W2000.
> Is this a known issue?
Spasibo, the bug is posted as http://bugs.mysql.com/bug.php?id=5728
I'm not sure if this is a known issue, but I let the developers inve
Better download the official binaries from
http://dev.mysql.com/downloads/mysql/4.1.html
There are RPM builts for AMD64.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/
Hi,
I have alot of data and im trying to speed things up by making some summary tables.
My summary_totals table has:
id, websiteid, hits, visitors
This will contain the websiteid, total hits and total visitors.
My hits table has (there are many more fields, but they are not relevant to this)
id,
Unreal HSHH <[EMAIL PROTECTED]> wrote:
> Making all in sql
> make all-recursive
> Making all in share
> ../../extra/comp_err -C./charsets/ danish/errmsg.sys
> Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile
> *** Error code 255
>
> what's this error?
Something wrong which is uncl
FayeC SQL <[EMAIL PROTECTED]> wrote:
rpm -qa | grep -i mysql
then remove all MySQL packages, which are likely to be
MySQL-shared, MySQL-server, MySQL-client and/or similar names if
not the official RPMs where installed.
To remove a package, do rpm --erase --force --nodeps
Then
rm -rf /var/l
Suresh <[EMAIL PROTECTED]> wrote:
> I am porting from 4.0.0-alpha-nt to 4.0.1-alpha-nt. In which i have a
> table with two primary key, my older mysql server insert all the records
> except the duplicate fields(Primary Key). Whereas in the new mysql
> server it exits whenever it sees a duplicate
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
This will help us determine if it's a bug and fix if it is.
Thank you!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.n
Haitao Jiang <[EMAIL PROTECTED]> wrote:
> We want to test our MYSQL (4.1.4g) server's query performance, and I
> just wondering if there is a tool that enable us sending a list of
> queries over HTTP or JDBC repeatedly and gather/display the
> statistics?
Honetsly, it's almost always better to wr
Tim Johnson <[EMAIL PROTECTED]> wrote:
>Installing MySQL-server-4.0.21-0.i386.rpm
> on Red Hat 9.0
>
> Getting the following:
> error: Failed dependencies:
>libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
>libmysqlclient.so.10 is needed by (installed) perl-D
See http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
You are interested in "interactive_timeout" and "wait_timeout"
system variables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__
Tim Johnson <[EMAIL PROTECTED]> wrote:
The simpliest way:
Download and install MySQL Official Binary RPMs from www.mysql.com.
They will install on your server and run fine.
You'd also want to install the shared-compat RPM in case you have
something compiled with older libmysqlclient.
The lin
Luciano Barcaro <[EMAIL PROTECTED]> wrote:
>>>I'm trying to backup the 'binary log' and don't know which file is it.
>>>
>>>these are the files I see in my datadir
>>>
>>>-rw-rw 1 mysql users175K Sep 14 14:21 hrrgp01-bin.07
>>>-rw-rw 1 mysql users345K Sep 14 15:03
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
> I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
> machine"), whenever I try to connect to MySQL server from any client by
> using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
> This has happened on three m
Hi,
> I was able to get the binary storate I needed in a TinyBlob
> but I can't set this to a primary key.
Can be done:
mysql> CREATE TABLE tb
-> (
-> id TINYBLOB NOT NULL,
-> PRIMARY KEY (id(255))
-> );
Query OK, 0 rows affected (0.00 sec)
You need to say how many chars you
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>> > And we've had good but limited experiences so far with 64 bit FreeBSD
>> > 5 on amd64 (also a quad w/32GB).
>>
>> Somewhere in this list I've seen controversial reports about FreeBSD/amd64.
>> Seems like it's not yet stable and may give unpredictable
"Alexander Newald" <[EMAIL PROTECTED]> wrote on 23/09/2004 19:28:09:
> >
> > Does
> >select count(id) from test where id like "d%" ;
> > work any better? I would expect it to make better use of the index.
> >
> >Alec
> >
>
> Hello,
>
> yes it works better for sets of data with ve
Dear [EMAIL PROTECTED]:
Here's my setting:
innodb_data_file_path = ibdata1:10M:autoextend
Now the ibdata1 has been grow up to 1.3G
We try to add more ibdata file to store the data by the following setting.
innodb_data_file_path = ibdata1:1500M;ibdata2:1500M:autoextend
innodb_data_file_path = ibd
63 matches
Mail list logo
