在控制臺輸入Update-Database -verbose后 然后執行了這個事務
set @columnType := (select case lower(IS_NULLABLE) when 'no' then CONCAT(column_type, ' not null ') when 'yes' then column_type end from information_schema.columns where table_name = 'Address' and column_name = 'Address' and table_schema = DATABASE());
set @sqlstmt := (select concat('alter table `Address` change `Address` `Address1` ' , @columnType));
prepare stmt from @sqlstmt;
execute stmt;
deallocate prepare stmt;
看不懂什么意思,然后出現了一個報錯
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
求解決辦法!
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/188497.html
上一篇：WCF服務端所有方法都用Task.Factory.StartNew封裝，是否是錯誤的做法？
下一篇：資料上傳下發，同步問題