从…开始
memberID LastFirstName LastName FirstName-------- ------------- -------- --------- 1 Doe, John
查询
UPDATE Members SET LastName = Trim(Left(LastFirstName, InStr(LastFirstName, ",") - 1)), FirstName = Trim(Mid(LastFirstName, InStr(LastFirstName, ",") + 1))
将导致
memberID LastFirstName LastName FirstName-------- ------------- -------- --------- 1 Doe, John Doe John
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)