... DELIMITER $$ CREATE TRIGGER TRG_INSERT_TELINK_SMS_REPORT_ROW AFTER UPDATE ON TELINK_SMS FOR EACH ROW BEGIN IF OLD.SMS_ST != NEW.SMS_ST And NEW.SMS_ST = '1' THEN INSERT INTO TELINK_SMS...
태그:
필드 명을 순서대로 2번 부터 나머지 전~부 출력을 하고 싶은데 어찌 해야하나요. mysqli 클래스를 사용하면 필드명을 추출하여...
태그:
... if (isset($_POST['edit_btn'])) { // for the database $bio = stripslashes($_POST... { $sql = "update users set username='$username',password='$password...
... 다음은 my.ini파일 내용입니다... the SQL mode to strict sql-mode="STRICT_TRANS_TABLES... indexes for each newly created table in a separate...
태그:
... // check for all in modules $result = $db->getAllLog1s(); if ($result != false) { echo... 구글에 sql 소계 라고 검색하시면 쿼리문들이 좀 나올거에요....
... ----- 오류 내용 ----- 심각: Servlet.service() for servlet [appServlet] in context with path [/mvcBoard] threw exception [Request processing failed;...
... https://stackoverflow.com/questions/5693259/how-can-a-query-multiply-2-cell-for-each-row-mysql https://www.tutorialspoint.com/multiply-values-of-two-columns-and-display-it-a-new-column-in-mysql...
태그:
$query = "SELECT DISTINCT a.goodsno, a.goodsnm, a.img_s, c.consumer, c.price FROM table_1 a INNER JOIN table_2 b ON a.goodsno = b.goodsno INNER JOIN table_3 c ON a.goodsno = c....
태그:
... CREATE TRIGGER tg_a_delete BEFORE DELETE ON a FOR EACH ROW BEGIN DELETE FROM test WHERE no1 = OLD.no AND Row1 = OLD.Row AND Class1 = OLD.Class; END; CREATE TRIGGER tg_b_delete BEFORE DELETE...
태그:
... for ( $i = 1 ; $i <= 10 ; $i++ ) { $this->{"add_frm".$i} = $mem["add_frm{$i}... // 그룹 아이디 $this->gid=$row[gid]; } elseif($this->mysql=="sql...
태그: