SQL

抽出
IN句
最大の日付を抽出

テーブルの結合
$sql = "SELECT Medjicaldt.MDCD, Medjicalmst.MDNM, Medjicalmst.FROM, ";
$sql .= "Medjicalmst.TO, Medjicaldt.ATAI, Medjicaldt.HL ";
$sql .= "FROM Medjicaldt INNER JOIN Medjicalmst ";
$sql .= "ON Medjicaldt.MDCD = Medjicalmst.MDCD ";
$sql .= "WHERE Medjicaldt.YMD = '$YYMMDD' ORDER BY Medjicaldt.MDCD";

$sql = "SELECT Medjicalmst.MDCD, Medjicalmst.MDNM, Medjicalmst.FROM, Medjicalmst.TO, ";
$sql .= "A.ATAI, A.HL ";
$sql .= "FROM Medjicalmst LEFT JOIN ";
$sql .= "(SELECT Medjicaldt.MDCD ,Medjicaldt.ATAI ,Medjicaldt.HL FROM Medjicaldt ";
$sql .= "WHERE Medjicaldt.YMD = '$YYMMDD') as A ";
$sql .= "ON A.MDCD = Medjicalmst.MDCD ";
$sql .= "ORDER BY Medjicalmst.MDCD";

レコードの件数
$sql = "SELECT COUNT(*) AS cnt FROM Hospitalmst";

レコードの追加
レコードの追加

レコードの修正
$sql = "UPDATE Hospitalmst SET ";
$sql .= "Hospitalnm = '$inHospitalnm', ";
$sql .= "Hospitaladd = '$inHospitaladd', ";
$sql .= "Hospitaltel = '$inHospitaltel' ";
$sql .= "WHERE Hospitalcd = $inHospitalcd";
レコードの削除
レコードの削除

PHP Menuに戻る