RE: Hi, how did u do de-emphasis of sql statements?

2012-08-20 Thread Rick James
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

Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
Hey man, I would like to ask a question about de-emphasis of sql statements? I Mean mysql engines have to be aware of which two statements are exactly the same Despite of variables?? values at runtime. Because in slow log, the execution counter is Maintained for each sql statement.

Re: Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread Johan De Meersman
- 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

?????? Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
this?..._/// -- -- ??: Johan De Meersmanvegiv...@tuxera.be; : 2012??8??13??(??) 8:48 ??: MID.night693893...@qq.com; : 673575760673575...@qq.com; mysqlmysql@lists.mysql.com; : Re: Hi, how did u do de-emphasis of sql

hi all

2012-07-23 Thread Zhigang Zhang
Dear: A open source development community for unix-like systems. http://dev.unix-like.net http://dev.unix-like.net/ Thanks.

buf/buf0buf.c:597 hi count

2010-11-11 Thread Claudio Nanni
Anyone has idea if this is normal? I have a rather hi count on some mutexes on one of my servers: Find below: - server status - last section of mutex status - full innodb status. Thanks Claudio mysql status; -- mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu

Re: hi.. is it possible

2010-02-08 Thread Shawn Green
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

hi.. is it possible

2010-02-06 Thread MuraliKrishna
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.

Re: hi.. is it possible

2010-02-06 Thread Thiyaghu CK
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

RE: hi help to take backup-mysql-windows-xp

2010-02-02 Thread John Daisley
IPAQ mobile device -Original Message- From: muralikrishna g muralikrishn...@gmail.com Sent: 02 February 2010 06:45 To: mysql@lists.mysql.com Subject: 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

hi help to take backup-mysql-windows-xp

2010-02-01 Thread muralikrishna g
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

Re: hi help to take backup-mysql-windows-xp

2010-02-01 Thread Suresh Kuna
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

Re: hi help to take backup-mysql-windows-xp

2010-02-01 Thread muralikrishna g
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

Re: hi help to take backup-mysql-windows-xp

2010-02-01 Thread sureshkumarilu
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 muralikrishn...@gmail.com Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kunasureshkumar...@gmail.com Cc: mysql

RE: hi help to take backup-mysql-windows-xp

2010-02-01 Thread Parikh, Dilip Kumar
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

Re: Hi Query Optimization steps

2009-08-26 Thread Joerg Bruehe
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

RE: Hi Query Optimization steps

2009-08-26 Thread Jerry Schwartz
-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

Re: Hi Query Optimization steps

2009-08-25 Thread bharani kumar
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

Re: Hi Query Optimization steps

2009-08-24 Thread mos
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

Hi Query Optimization steps

2009-08-22 Thread bharani kumar
Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query This sort of very basic things please tell me ... Also tell me , in the optimization view ,, which database engine is best Thanks Bharanikumar

Hi query with more relation

2009-07-16 Thread bharani kumar
Hi all *country* IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 Namehttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A

Re: Hi,I want to know how big to configurate the max-connections parameter in my.cnf?

2007-12-21 Thread Peng
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]

Hi mysql.list.server

2007-08-17 Thread Manivannan Palanichamy
hi -- View this message in context: http://www.nabble.com/Hi-mysql.list.server-tf4287546.html#a12205370 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: hi, I am not able view all the records in the tabel

2006-07-26 Thread Chris
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

hi, I am not able view all the records in the tabel

2006-07-21 Thread Annam Srinivas
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 showing (able to view

HI, I am Annam Srinivas

2006-07-21 Thread Annam Srinivas

hi how to merge data of various sql files

2006-05-17 Thread VenuGopal Papasani
hi all, I have got a problem.I have data entered in different machines in a database now i have got all the data in different .sql files.Now i was importing the same files in order to merge them in a same database.Herethere was a problem in merging, There were some tables which does´not change

Re: hi how to merge data of various sql files

2006-05-17 Thread Dilipkumar
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

Re: hi how to merge data of various sql files

2006-05-17 Thread Dilipkumar
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

Re: Hi, newbie question on a select statement

2006-02-20 Thread sheeri kritzer
Perhaps you were using CAST() incorrectly? What was your attempt? my test table: show create table ultimas_repuestas; +---+-+ | Table | Create Table

Hi, newbie question on a select statement

2006-02-16 Thread Ariel Sánchez Mora
I searched the other lists and couldn't find one that was more appropiate for this question; if there is, please tell me so :) I am monitoring networking equipment and so far I'm saving all my data in a MySQL database (hence an email to this list). I'm using only VARCHARs because the SNMP

RE: Hi, newbie question on a select statement

2006-02-16 Thread Logan, David (SST - Adelaide)
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

Re: Hi all

2005-10-31 Thread Stewart Smith
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

RES: Hi all

2005-10-31 Thread Fabricio Mota
Mota -Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 05:08 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: Re: Hi all On Sun, 2005-10-30 at 00:14 -0300, Fabricio Mota wrote

Re: RES: Hi all

2005-10-31 Thread Stewart Smith
On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop

RES: RES: Hi all

2005-10-31 Thread Fabricio Mota
-Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 23:14 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: Re: RES: Hi all On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have

RE: RES: Hi all

2005-10-31 Thread Logan, David (SST - Adelaide)
Hi Fabricio, You can find a lot of information in the manual, more specifically at http://dev.mysql.com/doc/refman/5.0/en/example-storage-engine.html This would be a very good place to start. Otherwise, as suggested, ask questions on the internals list. Regards David Logan Database

RES: RES: Hi all

2005-10-31 Thread Fabricio Mota
PROTECTED]; [EMAIL PROTECTED] Assunto: RE: RES: Hi all Hi Fabricio, You can find a lot of information in the manual, more specifically at http://dev.mysql.com/doc/refman/5.0/en/example-storage-engine.html This would be a very good place to start. Otherwise, as suggested, ask questions

Hi all

2005-10-29 Thread Fabricio Mota
Hi all, Anybody has worked as a developer to MySQL Database Server features? Thank you Fabricio Mota -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]

2005-07-12 Thread Gleb Paharenko
auto_parser wrote: Glen, Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This

Re: [Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]

2005-07-12 Thread Jochem van Dieten
On 7/12/05, Gleb Paharenko wrote: auto_parser wrote: Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it

just hi

2005-05-11 Thread Ezequiel Rodriguez
well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before ask  thnx :D -- MySQL General Mailing List For list archives:

Re: just hi

2005-05-11 Thread Johan Höök
Hi Ezequiel, see: http://dev.mysql.com/doc/ /Johan Ezequiel Rodriguez wrote: well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before

Re: just hi

2005-05-11 Thread Nestor Florez
Ezequiel, Tambien hay una lista de mysql en Espagnol. :-) -Original Message- From: Johan H��k [EMAIL PROTECTED] Sent: May 11, 2005 4:35 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: just hi Hi Ezequiel, see: http://dev.mysql.com/doc/ /Johan Ezequiel Rodriguez wrote

Hi, a problem about selecting...

2004-10-14 Thread Gokce Hazaroglu
I've a table and many fields. I want to search something in all fields. - select * from table where table.* like '%something%' did not work.. Is there a wayto dothis? Gokce AKKAYA HAZAROGLU OptikNet Bilgisayar [EMAIL PROTECTED] http://www.optiknet.com.tr

Re: Hi, a problem about selecting...

2004-10-14 Thread Rhino
] Sent: Thursday, October 14, 2004 12:42 PM Subject: Hi, a problem about selecting... I've a table and many fields. I want to search something in all fields. - select * from table where table.* like '%something%' did not work.. Is there a way to do

Hi!

2004-03-03 Thread miguel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Hi all.

2004-01-27 Thread Andy Fletcher
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,LNAME Where DOC contains what ever

RE: Hi all.

2004-01-27 Thread Ugo Bellavance
-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

Re: Hi all.

2004-01-27 Thread Chris Nolan
] 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. 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,LNAME Where DOC

Re: Hi all.

2004-01-27 Thread mos
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

Hi, I sent you a greeting from AOL E-Cards

2003-12-31 Thread [EMAIL PROTECTED]
To view your greeting, choose from the options below. Click on the following link: http://www.pickup.aol.egreetings.com/view.pd?i=6375961m=5319rr=ysource=aole999 OR Copy and paste the above link into your web browser's address window. Thank you for using AOL E-Cards! -- MySQL General Mailing

Re: Hi CPU on FreeBSD

2003-06-09 Thread Lalo Castro
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

Re: Hi CPU on FreeBSD

2003-06-09 Thread Jeremy Zawodny
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

Re: Hi CPU on FreeBSD

2003-06-09 Thread Gustavo A. Baratto
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 =

Re: Hi CPU on FreeBSD

2003-06-09 Thread Jeremy Zawodny
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

Re: Hi CPU on FreeBSD

2003-06-09 Thread Gustavo A. Baratto
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,

Re: Hi CPU on FreeBSD

2003-06-08 Thread Gunnar Helliesen
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

Re: Hi CPU on FreeBSD

2003-06-08 Thread Jeremy Zawodny
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

Hi,All ,About mysqldump and mysqlimport

2003-03-30 Thread Li Yang
Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but how I can load the test.sql to create the same database to another server?? Thanks! Best Regards Li Yang

RE: Hi,All ,About mysqldump and mysqlimport

2003-03-30 Thread Cal Evans
into your audience -Original Message- From: Li Yang [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 8:10 PM To: mysql Subject: Hi,All ,About mysqldump and mysqlimport Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but how I can

re: hi

2003-03-28 Thread Egor Egorov
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.

Re: hi

2003-03-28 Thread Martin Gainty
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

hi

2003-03-27 Thread Hridyesh Pant
Hi all, i am just new for MySql,can any body tell be from where i have to start learn MySql for Unix or Linux. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: hi

2003-03-27 Thread Prabu Subroto
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

@hi, need sync mysql users password with LDAP3.x

2003-03-09 Thread Miroslav Ris SA of iNet
Hi, I very need sync password for same mysql users with LDAP (or *nix passwd file). Any idea? -- Miroslav Ris System Administrator iNet System iNet WebMail System - Before posting, please

Hi and why

2003-01-21 Thread Valdir Stiebe Junior
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 columns, ID_TEST int(11) and NAME varchar(50).. and added

Re: Hi and why

2003-01-21 Thread Paul DuBois
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

Re: Hi and why

2003-01-21 Thread Valdir Stiebe Junior
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

Re: Hi and why

2003-01-21 Thread Valdir Stiebe Junior
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

Re: Hi and why

2003-01-21 Thread Paul DuBois
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

Re: Hi and why

2003-01-21 Thread Valdir Stiebe Junior
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

Re: Hi and why

2003-01-21 Thread Paul DuBois
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 =

RE: Hi and why

2003-01-21 Thread Dean Harding
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

Re: Hi and why

2003-01-21 Thread gerald_clark
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

Re: Hi and why

2003-01-21 Thread Gelu Gogancea
Hi, Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x) However ,if you use : select * from test_table where NAME='2'; you will have the correct result. Regards, Gelu ___ G.NET SOFTWARE COMPANY Permanent e-mail address

Hi, I have question about the User Privileges system

2002-08-12 Thread Jason
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 without running grant statements for

Re: Hi, I have question about the User Privileges system

2002-08-12 Thread Paul DuBois
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

Re: Hi CPU on FreeBSD

2002-06-23 Thread Jeremy Zawodny
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,

Re: Hi CPU on FreeBSD

2002-06-22 Thread Jeremy Zawodny
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

Re: Hi CPU on FreeBSD

2002-06-22 Thread mos
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

RE: Hi I'm a Newbie

2002-04-15 Thread Sampson, Peter
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

Re: hi

2002-03-22 Thread blue man
--- [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

Hi

2002-03-02 Thread cherian
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 databse otherwise in the offline mode the client machine will update the local MS Access databse, and later on when ever the network comes back

Re: Hi

2002-03-02 Thread Tony Buckley
- 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

2002-02-26 Thread Battini, Chandrashekar
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 single

RE: Hi

2002-02-26 Thread Battini, Chandrashekar
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

RE: Hi

2002-02-26 Thread Battini, Chandrashekar
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

RE: Hi

2002-02-26 Thread savaidis
]' Subject: Hi 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

Hi, Help!

2002-02-05 Thread Victoria Reznichenko
Erin, Tuesday, February 05, 2002, 12:37:33 AM, you wrote: EL Hi, this is Erin Lilly, I've used support before with you all for EL bodyconsultant.com and you were extremely helpful. I'm installing mysql on EL erinlilly.net and have run into that common /tmp/mysql.sock (111) error EL version

Re: Hi, Help!

2002-02-04 Thread Fred van Engen
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

Hi, Help!

2002-02-04 Thread Erin Lilly
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 version: 3.23.45-pc-linux To telnet in as root: erinlilly.net log-admin pw-paws

Hi Folks!

2002-01-06 Thread Sebastian Grewe
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 - Before

Re: Hi Folks!

2002-01-06 Thread Van
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

Re: Hi. Here is the An-san City of the South Korea.

2001-12-29 Thread Durga_Prasad
Placed At : À̼º°è [EMAIL PROTECTED] on 12/29/2001 12:48:50 PM Please respond to À̼º°è [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Durga Prasad/Satyam) Subject: Hi. Here is the An-san City of the South Korea. Hi. Here

Hi. Here is the An-san City of the South Korea.

2001-12-28 Thread
Hi. Here is the An-san City of the South Korea. We are the company which is developing the programs #8211; ERP(ENTERPRISE RESOURCE PLANNING) and has been concerned with MY_SQL DATABASE. Recently, we suggested to the client of Korea that we want to develop the programs(ERP, MIS, MRP

Hi all,

2001-09-26 Thread Dan Liu
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

Re: Hi all,

2001-09-26 Thread Paul DuBois
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

hi.

2001-09-25 Thread kurelli rajashaker
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 the database. Right now there are only 1000 records and it is taking quiet an amount of time to

Re: hi.

2001-09-25 Thread Marco Bizzarri
-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

  1   2   >