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

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

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

2012-08-13 Thread MID.night
der how they do this?...>_; : 2012??8??13??(??) 8:48 ??: "MID.night"<693893...@qq.com>; : "673575760"<673575...@qq.com>; "mysql"; : Re: Hi, how did u do de-emphasis of sql statements? - Original Message - > From

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, thoug

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. De-emphas

hi all

2012-07-23 Thread Zhigang Zhang
Dear: A open source development community for unix-like systems. 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-

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

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 a

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 help to take backup-mysql-windows-xp

2010-02-02 Thread John Daisley
IPAQ mobile device -Original Message- From: muralikrishna g 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-coomunity-nt i have tried by

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

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

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 Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kuna Cc: Subject: Re: hi help to take backup-mysql-windows-xp hi

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 d

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 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

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 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:

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 o

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 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

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 in the

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* ID<http://localhost/phpmyadmin/sql.php?db=totallyairports&table=country&sql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASC&token=48055f87d08d88620138b58feb711be2> Name<http://localhost/phpmyadmin/sql.php?db=totallyairports&am

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

HI, I am Annam Srinivas

2006-07-21 Thread Annam Srinivas

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 s

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 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

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, 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

RE: Hi, newbie question on a select statement

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

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 agen

RES: RES: Hi all

2005-10-31 Thread Fabricio Mota
EMAIL 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 o

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
-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 h

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 > develo

RES: Hi all

2005-10-31 Thread Fabricio Mota
ricio 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

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 V

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]

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: >> Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected >> because it does not a

[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: Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 ht

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 Rod

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 b

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: http://lists.mys

Re: Hi, a problem about selecting...

2004-10-14 Thread Rhino
PROTECTED] 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.

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 way to do this?      Gokce AKKAYA HAZAROGLU OptikNet Bilgisayar [EMAIL PROTECTED] http

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]

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 USERID,NAME,L

Re: Hi all.

2004-01-27 Thread Chris Nolan
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. The database I have created needs to store Documents and I have used Blob type co

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 q

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

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=6375961&m=5319&rr=y&source=aole999 OR Copy and paste the above link into your web browser's "address" window. Thank you for using AOL E-Cards! -- MySQL General Mai

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-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 necessari

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 = max_use

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 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 proc

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 th

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 ha

RE: Hi,All ,About mysqldump and mysqlimport

2003-03-30 Thread Cal Evans
ged 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 h

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

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

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-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 j

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]

@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

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-ma

Re: Hi and why

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

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] >

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 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 th

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
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

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 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

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(5

re: hi

2002-11-02 Thread Egor Egorov
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; --

Re: hi

2002-11-01 Thread Peter Brawley
> 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 ---

Re: hi

2002-11-01 Thread Lutz Maibach
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

hi

2002-11-01 Thread Daya Krishan Dubey
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. Thanks in advance Regards D K Dubey - Before posting, please check: http://www.mysql.com/manual.php

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 th

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 e

Re: Hi CPU on FreeBSD

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

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 change

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 ra

Hi CPU on FreeBSD

2002-05-27 Thread Simon Green
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) then at 2am cpu went back up to 99%. Has any body know why FreeBSD

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 immed

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 > e

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

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 the

RE: Hi

2002-02-26 Thread savaidis
2002 4:38 PM > To: '[EMAIL PROTECTED]' > 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 populatin

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 t

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 t

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

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

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) err

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-adm

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 > > ---

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 pos

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 th

  1   2   >