Category: QUERY
-
how to working with two database in php/mysql?
//connection file //tested in php 5.3.5 & mysql 5.5.8 //make sure database username & database host are same at same place… $host=”localhost”; $dbnm=’db1′; $dbunm=’root’; $dbpass=”; $conn=mysql_connect($host,$dbunm,$dbpass); $db=mysql_select_db($dbnm,$conn); //==================================================================// $host_=”localhost”; $dbnm_=’db2′; $dbunm_=’root’; $dbpass_=”; $conn_=mysql_connect($host_,$dbunm_,$dbpass_); mysql_select_db($dbnm_,$conn_) or die(mysql_error()); //============== Example =============================// $sql=”select * from db1.test”; $re=mysql_query($sql) or die(mysql_error()); $sql_=”select * from db2.test”; $re_=mysql_query($sql_); //join query between two database’s tables….…
-
Convert Varchar to Date Format in mysql
SELECT * FROM `tMembers` where str_to_date(sBirthDay,”%m/%d/%Y”) between str_to_date(’12/15/1985′,”%m/%d/%Y”) and str_to_date(’09/22/1987′,”%m/%d/%Y”)
-
INNER JOIN in MYSQL
SELECT * FROM shipping_name as sn INNER JOIN region_shipping as rs ON (rs.ship_id=sn.id) where rs.reg1!=” and rs.reg_1!=” or rs.reg2!=” and rs.reg_2!=” or rs.reg3!=” and rs.reg_3!=” or rs.reg4!=” and rs.reg_4!=” or rs.reg5!=” and rs.reg_5!=” or rs.reg6!=” and rs.reg_6!=” and sn.ship_price!=”