1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=UPDATE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">UPDATE</a> edtt_implements <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SET&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">SET</a> author_name = REPLACE ( author_name, 'aa', '梁瑞彬' ) <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=WHERE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">WHERE</a> book_name <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=LIKE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">LIKE</a> '%十万个为什么:%'; <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=SELECT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">SELECT</a> * <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=FROM&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">FROM</a> edtt_implements <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=WHERE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">WHERE</a> book_name <a style="color: #0000ff;" href="http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=LIKE&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99">LIKE</a> '%十万个为什么:%'; |
edtt_implements为表名 author_name为要更改的字段 book_name为模糊匹配已知的字段。
二〇一四年五月八日 14:54:11