UPDATE center SET No = '4',GroupID = '4',ID ='4', Tel= '4',EndNo = '4', RFTime = STR_TO_DATE('07-00-00','%H-%i-%s'),Time1 =STR_TO_DATE('07-00-00','%H-%i-%s'),Time2 = STR_TO_DATE('07-00-11','%H-%i-%s'),Check = '0' WHERE No = '2';
1 No VARCHAR 4
2 GroupID VARCHAR 11
3 ID VARCHAR 11
4 Tel VARCHAR 11
5 EndNo VARCHAR 5
6 RFTime TIME
7 Time1 TIME
8 Time2 TIME
9 Check CHAR 2
이런식의 테이블에
UPDATE center SET No = '4',GroupID = '4',ID ='4', Tel= '4',EndNo = '4', RFTime = STR_TO_DATE('07-00-00','%H-%i-%s'),Time1 =STR_TO_DATE('07-00-00','%H-%i-%s'),Time2 = STR_TO_DATE('07-00-11','%H-%i-%s'),Check = '0' WHERE No = '2';
쿼리를 이렇게 날렸습니다...
변하지가 않네요 ㅠㅠ
왜그런지 ㅠㅠ
도와주세요 ㅠㅠ
|