Skip to main content

Mysql join query in mysql and php

Mysql join query in mysql and php


<?php
$sql="select id ,name , address, city  from  table1  , table2  where table1.id=table2.cusid ";
?>
inner join
<?php
$sql="select id ,name , address, city  from table1 INNER JOIN table2 ON table1.id=table2.cusid ";
?>
left join
<?php
$sql="select id ,name , address, city  from table1 LEFT JOIN table2 ON table1.id=table2.cusid ";
?>
right join
<?php
$sql="select id ,name , address, city  from table1 RIGHT JOIN table2 on table1.id=table2.cusid ";
?>
full join
<?php
$sql="select id ,name , address, city  from table1 FULL JOIN table2 on table1.id=table2.cusid ";
?>

Labels:

Comments

Post a Comment

Popular posts from this blog

Minimum and maximum number with - and + 500 in Mysql and Sql query and Find out table scheema of our database in Mysql and sql query and Find out all table name of our database in Mysql and sql query and Find out current date and time in mysql and sql help of sql query

Minimum and maximum number with - and + 500 in Mysql and Sql query:- syntax:-  SELECT MIN(Used)-500 , max(Used)+500 FROM audit Find out current date and time in mysql and sql help of sql query:- syntax:- SELECT now() Find out database name in Mysql and sql query:- syntax:-  SELECT DATABASE(); Find out all table name of our database in Mysql and sql query:- syntax:- SHOW TABLES; Find out   table scheema   of our database in Mysql and sql query:- syntax:- DESCRIBE <table name>;
Post a Comment
Find more ----»

PHP STRING FUNCTION WITH OUTPUT AND EXAMPLE

PHP STRING FUNCTION  WITH OUTPUT AND EXAMPLE  <?php   $var="my name is saddam hussain saifi ";   print_r(explode("a",$var)); //output:Array ( [0] => my n [1] => me is s [2] => dd [3] => m huss [4] => in s [5] => ifi )       echo crypt($varws);//output:-$1$m5/.1//.$KRawtTgnzzScShDJN3aHa.     echo crc32($var);//output:-1732983884  echo count_chars($var ,4);//output;-!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`bcgjklopqrtvwxz{|}~€ ‚ƒ„…†‡ˆ‰Š‹Œ Ž ’“”•–—˜™š›œ žŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ    echo convert_uuencode($var);//output:-@;7D@;F%M92!I      echo convert_uudecode($var);// output:d4P L@M     echo convert_cyr_string($var,'m','a');       echo chunk_split($var,2,"(sam)");//output:-my(sam) n(sam)am(sam)e (sam)is(sam) s(sam)ad(sam)da(sam)m (sam)hu(sam)ss(sam)ai(sam)n (sam)s...
Post a Comment
Find more ----»
Form validation html and javascript <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style> .main { height:auto;//100px; width:300px; //border:1px solid #FF0000; } .msg { height:20px; width:200px; //border:1px solid black; color:red; display:none; } </style> <script language="javascript" type="text/javascript"> function hide() { document.getElementById('m').style.display="none"; document.getElementById('m1').style.display="none"; } function check() { var f=document.getElementById('fn').value; var l=document.getElementById('ln').value; if...
Post a Comment
Find more ----»