Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Monday, August 13, 2012 5:49 AM
To: MID.night
Cc: 673575760; mysql
Subject: Re: Hi, how did u do de-emphasis of sql statements?
- Original Message -
From: MID.night 693893...@qq.com
Like select * from table
- Original Message -
From: MID.night 693893...@qq.com
Like select * from table where name’A’ is just
The same as select * from table where name’B’.
The execution plan for both statements is indeed likely (but not guaranteed!)
to be the same. As far as I'm aware, though, MySQL
MuraliKrishna wrote:
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and client. please help me
regarding this.
Sure you can!
Read this and get back to us with questions:
Yes you can, but port has to be different.
Regards,
Thiyaghu CK
www.mafiree.com
On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna
murali_kris...@arthaoptions.com wrote:
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and
What error are you getting?
===
John Daisley
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer
Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.dais...@butterflysystems.co.uk
===
Sent via HP
Please paste the error and don't give the spave between -p and password.
On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g
muralikrishn...@gmail.comwrote:
hi to all..
i was in need to take backup of database..
i am using sql server version:5.0.27-coomunity-nt
i have tried by using
mysqldump
hi to all..
i was in need to take backup of database..
i am using sql server version:5.0.27-coomunity-nt
i have tried by using
mysqldump -u name -p password database_name backup.sql;
but i am getting error.. i am using windows xp system..
please help me
mysql mysqldump -u root -p dbadmin murali
@lists.mysql.com
Subject: Re: hi help to take backup-mysql-windows-xp
hi to all..
i was in need to take backup of database..
i am using sql server version:5.0.27-coomunity-nt
i have tried by using
mysqldump -u name -p password database_name backup.sql;
but i am getting error.. i am using windows xp
Message-
From: sureshkumar...@gmail.com [mailto:sureshkumar...@gmail.com]
Sent: Tuesday, February 02, 2010 12:22 PM
To: muralikrishna g
Cc: mysql@lists.mysql.com
Subject: Re: hi help to take backup-mysql-windows-xp
Hi Murali,
You have to execute it outside mysql prompt i.e command prompt.
Thanks
Hi!
bharani kumar wrote:
Then which DB engine is better.
Which fruit is better, an apple or a banana?
And if X is better, why do farmers still grow Y, and why do people buy it?
More serious:
Different engines offer different features, as described in the manual.
The most obvious
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: Wednesday, August 26, 2009 5:08 AM
To: mysql@lists.mysql.com
Cc: bharani kumar
Subject: Re: Hi Query Optimization steps
Hi!
bharani kumar wrote:
Then which DB engine is better.
Which fruit
Then which DB engine is better.
Thanks
On Mon, Aug 24, 2009 at 8:16 PM, mos mo...@fastmail.fm wrote:
At 05:01 AM 8/22/2009, you wrote:
Hi all
Tell Me few Query Optimization Tips
For example.. some people saying that , avoid using more of and condition
in
the query
Huh?
At 05:01 AM 8/22/2009, you wrote:
Hi all
Tell Me few Query Optimization Tips
For example.. some people saying that , avoid using more of and condition in
the query
Huh? You need to carefully plan your table structure and use indexes
sparingly on the columns you are using in the
On Dec 22, 2007 10:55 AM, Moon's Father [EMAIL PROTECTED] wrote:
how big your mysql connections's users.
How big users? don't know what you said.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Annam Srinivas wrote:
Hi,
Problem is like this. There is table with 'table_name-1' where, when I
am executing the query like ' select * from table_name-1;' it is showing
only 432 records but acctually there are 539 records in the table. when I
select individual records from the table it is
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key was found, keep old row)*_
VenuGopal Papasani wrote:
hi all,
I have got a problem.I have data entered in different machines
Hi,
In backup directory
cat *.sql | mysql -u root -p database
*
and
*Use import which is given below*
*
Dilipkumar wrote:
HI,
In this case if you want to import try to use force method.
mysqlimport -u root -p *-i* databasename filename.sql
_*(-i, --ignoreIf duplicate unique key
Perhaps you were using CAST() incorrectly? What was your attempt?
my test table:
show create table ultimas_repuestas;
+---+-+
| Table | Create Table
Hi Ariel,
It works fine for me
localhost.testshow create table mytest\G
*** 1. row ***
Table: mytest
Create Table: CREATE TABLE `mytest` (
`id` int(11) NOT NULL auto_increment,
`test_col` varchar(10) default NULL,
PRIMARY KEY (`id`)
)
On Sun, 2005-10-30 at 00:14 -0300, Fabricio Mota wrote:
Anybody has worked as a developer to MySQL Database Server features?
If you mean people who work for MySQL hacking on Cluster, then yes, we
exist.
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
Have a look at fulltext searches. This is described in the MySQL manual at
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html. If you put all of your columns
in the column list following the FULLTEXT keyword, you will be able to use MATCH
AGAINST expressions to find what you want.
I'm
-Message d'origine-
De : Andy Fletcher [mailto:[EMAIL PROTECTED]
Envoyé : Tuesday, January 27, 2004 4:42 AM
À : [EMAIL PROTECTED]
Objet : Hi all.
I am just starting to work with SQL and Mysql server language
and am embedding some queries into another program I am developing.
MySQL can help you out here, but there are many questions you need to
answer first.
1. What exactly is in the DOC column? Binary data of some disgusting,
inferior proprietary word
processor document format, plain text, XML, LaTeX files?
2. If you answered But I like Clippy! to the above, go to
At 03:41 AM 1/27/2004, you wrote:
I am just starting to work with SQL and Mysql server language and am
embedding some queries into another program I am developing.
The database I have created needs to store Documents and I have used Blob
type columns for this. If I want to:
Select
We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL
to work with Linux style threads seemed to work. The MySQLd process no
longer pops up to ~90% on each request. However, with the application
we're running that queries the database (Request Tracker 3), we still
get
On Mon, Jun 09, 2003 at 11:26:36AM -0700, Lalo Castro wrote:
We had the same problem. Upgrading Freebsd to 4.8 and recompiling
MySQL to work with Linux style threads seemed to work.
Great.
The MySQLd process no longer pops up to ~90% on each request.
However, with the application we're
the load average in my freebsd 5.0 (latest releng) compiled statically
with linuxthreads decreased 80% after I tunned these variables:
set-variable = key_buffer_size=100MB
set-variable = read_buffer_size=5M
set-variable = table_cache=500
set-variable = max_delayed_threads=0
set-variable =
On Mon, Jun 09, 2003 at 01:41:00PM +, Gustavo A. Baratto wrote:
the load average in my freebsd 5.0 (latest releng) compiled statically
with linuxthreads decreased 80% after I tunned these variables:
What about actual CPU usage? Did is increase similarly?
The load average isn't
CPU usage improved a lot as well... It's always above 90% free and
before it was 70-75% idle... here is a snapshot:
last pid: 58730; load averages: 0.09, 0.11, 0.08
up 9+20:59:57 17:11:24
216 processes: 1 running, 215 sleeping
CPU states: 0.0% user,
On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote:
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
We've managed to reproduce this pretty reliably at Yahoo and are
working to track and fix the bug. If we find a resolution, I'll post
a note here.
There have been a few
On Sun, Jun 08, 2003 at 03:37:17PM +0200, Gunnar Helliesen wrote:
On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote:
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
We've managed to reproduce this pretty reliably at Yahoo and are
working to track and fix the bug. If we
Edit the script created by mysqldump. Add
create database if not exists databaseName;
to the beginning of the script.
Or what I usually do is create the database first then use:
mysql -A databaseName test.sql
to load it.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged
On Thursday 27 March 2003 06:18, Hridyesh Pant wrote:
i am just new for MySql,can any body tell be from where i have to start
learn MySql for Unix or Linux.
Take this brand new Paul's book:
http://www.mysql.com/portal/books/item-75.html
It's really excellent. That will help.
Thanks.
The first step is to get a working example-
WARNING: you may have to compile the library to get it working on your
platform..
Good Luck,
Martin
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 2:08 AM
Subject: re: hi
On Thursday
See www.mysql.org. There you can find a complete
documentation for mysql.
You have a good decision to use mysql on linux. I
don't believe mysql on MS. MySQL on MS is not optimal
in my opinion.
Sorry if I am wrong.
--- Hridyesh Pant [EMAIL PROTECTED] wrote:
Hi all,
i am just new for MySql,can
At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two
I don't know why it returns the first two rows, but (assuming you didn't
really end your query with two question marks) what error are you
expecting
to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead of (2 or any different of zero) after the equal sign
the
Sorry, correcting my last email, the sql result the two rows when i use
'NAME = 0'.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Valdir Stiebe Junior [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 21, 2003 4:33 PM
Subject: Re: Hi and why
At 15:02 -0200 1/21
At 16:47 -0200 1/21/03, Valdir Stiebe Junior wrote:
I don't know why it returns the first two rows, but (assuming you didn't
really end your query with two question marks) what error are you
expecting
to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead
I'm stlll surprised that NAME = 2 returns anything. When I tried your
example, it returned no rows. I get two rows with NAME = 0, nothing
with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
NAME = 0 is a string-to-number conversion. MySQL converts the
At 18:11 -0200 1/21/03, Valdir Stiebe Junior wrote:
I'm stlll surprised that NAME = 2 returns anything. When I tried your
example, it returned no rows. I get two rows with NAME = 0, nothing
with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
NAME =
I just tried it myself and I get an empty set as expected.
What do you get when you do a 'select * from test'?
-Original Message-
From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 22 January 2003 5:48 am
To: [EMAIL PROTECTED]
Subject: Re: Hi and why
I don't
PROTECTED]
Sent: Tuesday, January 21, 2003 4:33 PM
Subject: Re: Hi and why
At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database.
So
i'm
: [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Valdir Stiebe Junior [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 21, 2003 8:47 PM
Subject: Re: Hi and why
I don't know why it returns the first two rows, but (assuming
At 21:39 -0500 8/12/02, Jason wrote:
I have been searching for a way to restrict access to a database. So
far all I see that is possible is to grant access to databases. What if
I want a user account to be able to access every database except for the
mysql database? There is no way to do this
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote:
We've managed to reproduce this pretty reliably at Yahoo and are
working to track and fix the bug. If we find a resolution, I'll post
a note here.
There have been a few threads regarding high CPU utilization on
FreeBSD systems.
Yeah,
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
For 3 days all ran fine (low cpu)
At 06:59 PM 6/22/2002, you wrote:
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
sql,query
I also looking for a good ASP 3.0 mailing list
Peter Sampson
http://www.cfcnet.co.uk
The information contained in this email is intended only for the person or
organization to which it is addressed. If you have received it by mistake, please
disregard and notify the sender
--- [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to
be either spam or
simply off topic to our filter. To bypass the filter
you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
entire
- Original Message -
From: cherian [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 1:12 PM
Subject: Hi
Hi,
I have an application that has got Oracle as the central databse, if all
the
client machines are online then it will update the central oracle
Hi ,
I am using Mysql in Linux OS. I created a table in Mysql. The table has
3 fields and one is Primary key among them. I have populated 40K entries
in the table. While populating the entries in the table, For each 500
entries that i populated in the table, i have searched for a
Hi ,
I am using Mysql in Linux OS. I created a table in Mysql. The table has
3 fields and one is Primary key among them. I have populated 40K entries
in the table. While populating the entries in the table, For each 500
entries that i populated in the table, i have searched for a
Are you adding the data in order ? If Btree is not balanced then it
matters. It search them all. But I don't believe it is not balanced.
Makis
-Original Message-
From: Battini, Chandrashekar
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 4:38 PM
To: '[EMAIL
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote:
Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common /tmp/mysql.sock (111) error
Hi, you just
Sebastian Grewe wrote:
I have a problem with my Website. I want to list only 25 results of a db query. When
the user klicks on Second Page he should see the next 25 results and so on.
How can I do that?
Thx for replies.
Sebastian
Just a thought.
It is a well known fact that MySQL is being used as the backend software for
Yahoo Finance.
However, the response as mentioned in this mail is also typical from a customer
looking at commercial application development.
How can the larger business community perception be changed
At 3:07 PM -0500 9/26/01, Dan Liu wrote:
Hi all,
I am running a query on mysql.The query is simple.It retrieves 2800
rows and 250 columns data.I created index for the query.But it still
takes over a minute.
Could somebody tell me what should I do?And why it is so slow?
Thanks!
Dan
You may get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 25 Sep 2001, kurelli rajashaker wrote:
Hello everyone,
We have been using the mysql
database for our placement division of our company. I
have been facing with the problem of slowness of
retrieving the results from
helo
anybody there to help me for my project
my project is on PERL and Mysql in Linux
please say me the procedure to
study those stuffs.
thanx in advance
Buy the book MySQL written by Paul DuBois.
Take a look at www.devshed.com and on webmonkey.
Bye,
B.
At 16:11 06/07/2001 +0800, rqhuang wrote:
Hi,
I would like to ask you a favour for to make a test when you not
are able to stop the slave. There is a tool called NETWATCH.EXE
from Microsoft to be used on Win9x machines, this tools it isn't
installed by the default and you can find instructions
Try link is with -L/path to your library -lmysqlclient
You need library libmysqlclient which is currently in
instaldir/lib/mysql/...
---
Dvoøáèek Michal mailto:[EMAIL PROTECTED]
-
Before posting,
What OS are you using?
Simon
-Original Message-
From: Morgan Sagmo [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 11:19
To: '[EMAIL PROTECTED]'
Subject: Hi!
I dont understand this. I am trying to make a database...Have not done it
before, and I have red about MySQL. I have downloaded
Well, if you're looking for an exe file, I would say you have downloaded the
wrong version. You will need to download the correct version for Windows
and read the manual on how to install. If you have other problems, you'll
need to be more specific.
- Original Message -
From: Morgan
What's your code? How are you trying to connect?
- Original Message -
From: "manikandan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 15:02
Subject: Hi help needed!
Hi All!
I am not able to connect to remote Mysql running on a Linux meachine .I
am
Hi Andy,
I dont think so to be honest it could be but i removed mysql and
reinstalled it several times
and each time, it works for a few times and then it collapses... any other
idea ???
murat,
At 19:13 10.02.2001 +0100, Dingfelder Andy wrote:
Hello Murrat,
is it possible, that someone
66 matches
Mail list logo
