{"id":883,"date":"2015-08-09T17:57:39","date_gmt":"2015-08-09T09:57:39","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=883"},"modified":"2015-09-10T21:53:02","modified_gmt":"2015-09-10T13:53:02","slug":"mysql%e9%9a%90%e5%bc%8f%e8%bd%ac%e6%8d%a2","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=883","title":{"rendered":"MySQL\u9690\u5f0f\u8f6c\u6362"},"content":{"rendered":"
\n

mysql> create table users(num int not null, id varchar(30) not null, password varchar(30) not null, primary key(num));<\/p>\n

Query OK, 0 rows affected (0.00 sec)<\/p>\n

mysql> insert into users values(1, ‘admin’, ‘ad1234’);<\/p>\n

Query OK, 1 row affected (0.00 sec)<\/p>\n

mysql> insert into users values(2, ‘wh1ant’, ‘wh1234’);<\/p>\n

Query OK, 1 row affected (0.00 sec)<\/p>\n

mysql> insert into users values(3, ‘secuholic’, ‘se1234’);<\/p>\n

Query OK, 1 row affected (0.00 sec)<\/p>\n

mysql> select * from users where id=0;<\/p>\n

+—–+———–+———-+<\/p>\n

| num | id\u00a0 \u00a0 \u00a0 \u00a0\u00a0| password |<\/p>\n

+—–+———–+———-+<\/p>\n

|\u00a0\u00a0\u00a01 | admin\u00a0\u00a0 \u00a0\u00a0| ad1234\u00a0\u00a0\u00a0|<\/p>\n

|\u00a0\u00a0\u00a02 | wh1ant\u00a0 \u00a0\u00a0| wh1234\u00a0\u00a0\u00a0|<\/p>\n

|\u00a0\u00a0\u00a03 | secuholic | se1234\u00a0\u00a0\u00a0|<\/p>\n

+—–+———–+———-+<\/p>\n

3 rows in set, 3 warnings (0.00 sec)<\/p>\n

mysql> show warnings<\/p>\n

-> ;<\/p>\n

+———+——+———————————————–+<\/p>\n

| Level \u00a0 | Code | Message \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/p>\n

+———+——+———————————————–+<\/p>\n

| Warning | 1292 | Truncated incorrect DOUBLE value: ‘admin’ \u00a0 \u00a0 |<\/p>\n

| Warning | 1292 | Truncated incorrect DOUBLE value: ‘wh1ant’\u00a0 \u00a0 |<\/p>\n

| Warning | 1292 | Truncated incorrect DOUBLE value: ‘secuholic’ |<\/p>\n

+———+——+———————————————–+<\/p>\n

3 rows in set (0.00 sec)<\/p>\n

mysql> select * from users where id=’0′;<\/p>\n

Empty set (0.00 sec)<\/p>\n

mysql> select * from users where 0=id;<\/p>\n

+—–+———–+———-+<\/p>\n

| num | id\u00a0 \u00a0 \u00a0 \u00a0 | password |<\/p>\n

+—–+———–+———-+<\/p>\n

| \u00a0 1 | admin \u00a0 \u00a0 | ad1234 \u00a0 |<\/p>\n

| \u00a0 2 | wh1ant\u00a0 \u00a0 | wh1234 \u00a0 |<\/p>\n

| \u00a0 3 | secuholic | se1234 \u00a0 |<\/p>\n

+—–+———–+———-+<\/p>\n

3 rows in set, 3 warnings (0.00 sec)<\/p>\n

mysql> insert into users values(‘ucjmh’,’ucjmh’,’ucjmh’);<\/p>\n

Query OK, 1 row affected, 1 warning (0.00 sec)<\/p>\n

mysql> show warnings;<\/p>\n

+———+——+————————————————————+<\/p>\n

| Level\u00a0\u00a0\u00a0| Code | Message\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0|<\/p>\n

+———+——+————————————————————+<\/p>\n

| Warning | 1366 | Incorrect integer value: ‘ucjmh’ for column ‘num’ at row 1 |<\/p>\n

+———+——+————————————————————+<\/p>\n

1 row in set (0.00 sec)<\/p>\n

mysql> select * from users;<\/p>\n

+—–+———–+———-+<\/p>\n

| num | id\u00a0 \u00a0 \u00a0 \u00a0\u00a0| password |<\/p>\n

+—–+———–+———-+<\/p>\n

|\u00a0\u00a0\u00a00 | ucjmh\u00a0\u00a0 \u00a0\u00a0| ucjmh\u00a0 \u00a0\u00a0|<\/p>\n

|\u00a0\u00a0\u00a01 | admin\u00a0\u00a0 \u00a0\u00a0| ad1234\u00a0\u00a0\u00a0|<\/p>\n

|\u00a0\u00a0\u00a02 | wh1ant\u00a0 \u00a0\u00a0| wh1234\u00a0\u00a0\u00a0|<\/p>\n

|\u00a0\u00a0\u00a03 | secuholic | se1234\u00a0\u00a0\u00a0|<\/p>\n

+—–+———–+———-+<\/p>\n

4 rows in set (0.00 sec)<\/p>\n<\/div>\n

\u5982\u679c\u662f\u5728oracle\u4e2d\u76f4\u63a5\u4f1a\u62a5ora-01722<\/p>\n","protected":false},"excerpt":{"rendered":"

mysql> create table users(num int not null, id varch […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[27],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=883"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":891,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/883\/revisions\/891"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}