[

자주 사용하는 Mysql Query문(php와 관련하여)

· 2004-11-29 (월) 00:21:57 · 4537
********** 데이타 삽입시
$QUERY_STR = "
INSERT INTO TableName(FieldName1,FieldName2,....,FieldNamen)
VALUES('FieldValue1','FieldValue2',....,'FieldValuen')";


********** 데이타 수정시
$QUERY_STR = "UPDATE TableName SET
FieldName1='FieldValue1',
FieldName2='FieldValue2',
.................
FieldNamen='FieldValuen'

WHERE UID='$UID'";


********** 데이타 수정시[카운팅 올리기]

$SqlStr = "UPDATE wizMall SET Count = Count+1 WHERE UID='$no'";
mysql_query($Sqlstr,$DB_CONNECT) or die(mysql_error());


********** 데이타 삭제시
$QUERY_STR ="DELETE FROM TableName WHERE FieldName='FieldValue'";<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
04-11-29 조회 3,839
04-11-29 조회 4,257
04-11-29 조회 6,078
04-11-29 조회 3,446
04-11-29 조회 5,758
04-11-29 조회 3,435
04-11-29 조회 4,047
04-11-29 조회 8,519
04-11-29 조회 4,761
04-11-29 조회 4,144
04-11-29 조회 5,659
04-11-29 조회 3,840
04-11-29 조회 7,165
04-11-29 조회 5,397
04-11-29 조회 6,715
04-11-29 조회 4,538
04-11-29 조회 6,907
04-11-28 조회 4,040
04-11-28 조회 3,773
04-11-28 조회 3,556
04-11-28 조회 3,363
04-11-28 조회 3,564
04-11-28 조회 3,583
04-11-28 조회 4,822
04-11-28 조회 3,821
04-11-28 조회 3,431
04-11-28 조회 3,259
04-11-28 조회 4,106
04-11-28 조회 4,136
04-11-28 조회 3,407
04-11-28 조회 3,560
04-11-28 조회 3,943
04-11-28 조회 3,260
04-11-28 조회 3,663
04-11-28 조회 3,055
04-11-28 조회 3,299
04-11-28 조회 3,597
04-11-24 조회 3,276
04-11-24 조회 3,108
04-11-23 조회 3,071
04-11-23 조회 3,225
04-11-23 조회 2,829
04-11-23 조회 2,820
04-11-23 조회 3,048
04-11-23 조회 3,275
04-11-17 조회 5,492
04-11-17 조회 3,638
04-11-17 조회 3,058
04-11-12 조회 3,131
04-11-12 조회 3,096
04-11-12 조회 3,343
04-11-12 조회 3,487
04-11-12 조회 2,683
04-11-12 조회 4,968
04-11-12 조회 4,767
04-11-10 조회 3,919
04-11-10 조회 3,823
04-10-12 조회 6,225
04-09-16 조회 5,059
04-08-24 조회 5,388
04-08-23 조회 4,438
04-08-10 조회 6,832
04-08-10 조회 4,023
04-08-10 조회 6,975
07-10-24 조회 4,502
04-08-10 조회 4,558
04-08-10 조회 5,165
04-08-10 조회 4,741
04-08-10 조회 5,113
04-08-10 조회 7,607
04-08-10 조회 5,663
04-08-10 조회 7,908
04-08-09 조회 5,082
04-08-08 조회 3,503
04-08-08 조회 5,917
04-08-08 조회 4,341
04-08-08 조회 4,815
04-08-07 조회 4,476
04-08-06 조회 4,347
04-08-06 조회 4,889
04-08-05 조회 6,082
04-08-05 조회 5,689
04-08-05 조회 6,615
04-08-05 조회 5,031
04-08-05 조회 5,788
04-08-05 조회 5,642
04-08-05 조회 4,134
03-09-26 조회 5,268