there is much less need for a cache than 'they' have.
> -Original 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 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, thoug
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:
http://dev.mysql.com/doc/refman/5.1/en/multiple-s
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 I
nal 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 pro
Hi Murali,
You have to execute it outside mysql prompt i.e command prompt.
Thanks
Suresh Kuna
MySQL DBA
Sent from BlackBerry® on Airtel
-Original Message-
From: muralikrishna g
Date: Tue, 2 Feb 2010 12:17:24
To: Suresh Kuna
Cc:
Subject: Re: hi help to take backup-mysql-windows-xp
hi
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 mural
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
wrote:
> 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 d
>-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:
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 diff
Then which DB engine is better.
Thanks
On Mon, Aug 24, 2009 at 8:16 PM, mos 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
>>
>
> Hu
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 Whe
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 sh
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 wa
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 in
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.test>show 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
V
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 assum
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 USERID,NAME,L
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
> -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 deve
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 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 necessari
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 = max_use
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
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 proc
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 th
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 ha
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 i
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
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.
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,ca
il address : [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
t;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/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and
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]
>
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'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 th
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
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, 2
> 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
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 column
Daya,
Friday, November 01, 2002, 12:41:57 PM, you wrote:
DKD> Can naybody tell me how can i get the last 10 inserted record in the table
DKD> in MySql. Is MySql uses rowid like Oracle.
You can use f.e. AUTO_INCREMENT column and then
SELECT ORDER BY auto_increment_field DESC LIMIT 10;
--
> Can naybody tell me how can i get the last 10 inserted record in the table
> in MySql. Is MySql uses rowid like Oracle.
>
> Thanks in advance
> Regards
> D K Dubey
How about ...
SELECT ... ORDER BY id DESC LIMIT 10
PB
---
Hi,
> Can naybody tell me how can i get the last 10 inserted record in the
table
> in MySql. Is MySql uses rowid like Oracle.
Yep, you can use _rowid and a user variable to get what you want:
select @startrow:=count(*)-10 from mytable
select * from mytable where _rowid>@startrow
Greetings
Lutz
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 th
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
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
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)
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 immed
--- [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
> e
- 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
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 PRO
> 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 fo
> 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 f
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 m
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 w
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 ma
-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
>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 ho
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, pl
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 Sa
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 mys
Try phpmyadmin in www.phpwizard.com
>From: "Denis Mettler" <[EMAIL PROTECTED]>
>To: "j.urban" <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL
>Date: Mon, 26 Feb 2001 17:13:55 +0100
>
>Hi,
>
>Check out MysqlGUI at www.mysql.com
>I think it's the best
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
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 del
70 matches
Mail list logo
