Re: Reg: MYSQL Mail Agent

When i use mssql, i used the mail agent, so similar one expecting in MYSQL, On Mon, Apr 8, 2013 at 4:02 PM, Johan De Meersman wrote: > - Original Message - > > From: "Bharani Kumar" > > > > How to enable mail agent service in MYSQL. and what are the n

Re: join query for sale report

any suggestion, for my question plz On Fri, Dec 24, 2010 at 10:57 PM, bharani kumar < bharanikumariyer...@gmail.com> wrote: > I want to take the sale report, > > Group by catID , > > Daily report , > > table name : tblbasket BID Auto Incre, Prim Key > >

join query for sale report

I want to take the sale report, Group by catID , Daily report , table name : tblbasket BID Auto Incre, Prim Key BID int(20), BasketSessionID varchar(100),ProductCode varchar(50), CatID int(10), Quantity int(20), AfterDiscount double,purchasedate datetime, Status int(3) table name

Re: Alphabetical pagination mysql regexp query problem

ition, it is implied. Try this: > > [php] > SELECT * FROM tbl where Fname REGEXP '^[abcd]' > [/php] > > - michael dykman > > On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar > wrote: > > Hi , > > > > Am just trying alphabetical pagination , > &g

Alphabetical pagination mysql regexp query problem

Hi , Am just trying alphabetical pagination , Yes there is lot of pager class there for this , but in my requirement little but diff , that is totally 4 sets , A-DE-H I-PQ-S (Assume there are pager links) When user click the A-D , then it should show all the customer name starting

normalization

Frankly speaking , Am looking very simple example for 5NF , Even i looked the lot of site , in most of the site they given clear information upto 3NF , But can u please tell me , 5NF with example, Regards Bharanikumar

Re: query returning empty row

thanks for reply, problem fixed, On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson wrote: > In the last episode (Jan 17), bharani kumar said: > > SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE > > cCurstatus!='completed' AND cMmrcashworker = '

query returning empty row

SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE cCurstatus!='completed' AND cMmrcashworker = '2' AND (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND updateDate between '2010-01-01' and '2010-01-28' order by id desc I have one patient entry,and his up

Re: Render row without duplicates

t null > union > select Hospital2Code from tab where Hospital2Code is not null > union > select Hospital3Code from tab where Hospital3Code is not null > order by 1 > > Jim > > > > On Sun, Jan 3, 2010 at 2:50 AM, bharani kumar < > bharanikumariyer...@gmail.com&

Split query result into two part

Hi , Working in PHP,MYSQL project, i have student table , i want to list the student name from the table, the table contains around 1 records,i want to display all this 1 records into TWO Div, I dont want to execute query twice, image markup link here, Image Markup

Before alter Field name in table, Things Need to check

Hi For example , Student_TBL Student_id Student_Name Student_regNo , Am going to Alter the StudentregNo To StudentRegister_No , Am not sure who are all used this field , that any of the views depend this StudentRegister_No , How to check it , Is there any function Do this, Thanks

Re: Mysql Certification exams

Hi , Look dummies , look mysql basic's, not sure, but google with keyword mysql dump On Mon, Jan 4, 2010 at 11:36 AM, machiel.richards < machiel.richa...@gmail.com> wrote: > Good day all > > > >I hope that someone can help me out with some resources. > > > >Due

Re: Render row without duplicates

IT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5&token=160eb1977a91a41f9027141

Re: Render row without duplicates

> select Hospital3Code from tab where Hospital3Code is not null > ) A order by 1 > > Jim > > > > > > > > On Sat, Jan 2, 2010 at 6:43 AM, bharani kumar < > bharanikumariyer...@gmail.com> wrote: > >> Hi >> >> My field

Render row without duplicates

Hi My fields something like hospital1,hospital2,hospital3,patientname, Exact table look like PatientName Hospital1Code Hospital2Code Hospital3Code Bharani 1234NULL NULL Kumar 56781234 NULL Senthil

Export as csv

hi friend Am working in php and mysql, i want to write the join query from the 4 table, Am very confused how to do , Here is the atachment , Please tell me , How to to Master table is CREATE TABLE `med_patient` ( `id` bigint(20) NOT NULL auto_increment, `cInitial` varchar(5) default

Special for you!

http://cfi.iflywestwind.com/nEACWal3iJ.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Query :: Finding Date Difference

courier_id consignor_name consignor_address consignor_destination consignor_phone consignee_name consignee_address consignee_destination consignee_phone s_date s_date_mm s_date_ss r_date r_date_mm r_date_ss consignment_description no_packages weight frieght_charges loading_charges unloading_charges

Free SMS Gateway

Hi All , If any one know free sms gateway server, Please share the details , Thanks

_Present

http://cfi.iflywestwind.com/nEACWal3iJ.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Hi Query Optimization steps

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

Hi Query Optimization steps

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

Write IF condition in Query , and mysql Search function

Hi All , Am working on the autosuggestion program SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) > 0 OR locate('$q', $field1) > 0 order by locate('$q', $field2), $field2 limit " . ($pagesize * $page) . "," . $pagesize This is my query , Example in my Database tab

Hi query with more relation

Hi all *country* ID Name

Re: how to fetch and calculate data from remote database and insert into local database

u asking any scripts On 6/25/09, John Daisley wrote: > Depending on what you mean by 'Calculate the data', you could try using a > tool like Talend (www.talend.com). > >> What exactly do you want to calculate? >> >> Generally, export (mysqldump cmd) and import (mysql cmd) of data is done >> as >

Re: safe query prevent sites from hijacker

, but > > it was only a matter of time before people on this list start typing > > what I was thinking. But for starter, check out http://shiflett.org/ > > and read his Essential PHP Security book. > > > > On Fri, Jun 19, 2009 at 10:03 AM, walter harms wrote: > >&

safe query prevent sites from hijacker

Hi All , This is one general question , How to write the safe query , which prevent the site from hijacker , Share your idea's Thanks B.S.Bharanikumar

Left join query

Airport table SlNoName Code AuthLocation status 1 ChennaiCHN Yes India 1 2. Hydarabed HYD Yes India 0 3 walkerWAK Yes uk1 common table SlNoName Code

Re: I need some example

Sorry ya, not for my project , just i wat to know Thanks 2009/5/25 Martin Gainty : > cannot help with implementation details unless we see your DB schema e.g. > mysql>use DB > mysql>show tables > msqyl>desc table1 > mysql>desc table2 > > Martin Gainty > _

I need some example

Hi All , Can u please tell me example which contain , Two having and Two group by in a single query , Thanks B.S.Bharanikumar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

innodb vs myisam

Hi all , Am not much knowledgeable person in mysql , but i know the query and all, But dont know the history and all about mysql , But i like to know , Can u please tell me , Here is difference what i know , innodb = suport concurrency , row level locking , rollback, commit myisam = support

row level lock

Hi all How to use the row level locaking in innodb , i dont know, even in my friend circle also , they are not worked in the row level locking and all , Can u please tell som brifly also with some example snippet's thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPIN

Diff Mysql and mysqli

Hi All, Can u please tell me the difference between mysql and mysqli , Thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPINION http://bharanikumariyerphp.site88.net/bharanikumar/

Re: If condition in select query / insert /update

| high | > +--+---+ > 3 rows in set (0.06 sec) > > Take a look at the documentation for IF(), > http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html > > All the best, > -Janek, CMDEV 5.0. > StudyLink. Helping Peop

If condition in select query / insert /update

Hi all , Can u give one example query , Which contain the IF condition , Because here before am not used the IF and all , Thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPINION http://bharanikumariyerphp.site88.net/bharanikumar/