鏁版嵁搴撲腑Decimal绫诲瀷鎬庝箞浣跨敤
鏁版嵁搴撲腑鐨凞ecimal绫诲瀷鏄竴绉嶇簿纭殑鍗佽繘鍒舵暟绫诲瀷锛岀敤浜庡瓨鍌ㄩ渶瑕佷繚鐣欏皬鏁颁綅鏁扮殑鏁板€笺€?/p>
鍦ㄥぇ澶氭暟鏁版嵁搴撶鐞嗙郴缁熶腑锛孌ecimal绫诲瀷閫氬父闇€瑕佹寚瀹氫袱涓弬鏁帮細绮惧害锛坧recision锛夊拰灏忔暟浣嶆暟锛坰cale锛夈€傜簿搴﹁〃绀烘暣涓暟鍊肩殑浣嶆暟锛屽寘鎷暣鏁板拰灏忔暟浣嶆暟锛岃€屽皬鏁颁綅鏁拌〃绀哄皬鏁扮殑浣嶆暟銆?/p>
浠ヤ笅鏄竴浜涘父瑙佺殑鏁版嵁搴撲腑浣跨敤Decimal绫诲瀷鐨勭ず渚嬶細
- MySQL锛?/li>
鍦∕ySQL涓紝鍙互浣跨敤DECIMAL鍏抽敭瀛楁潵瀹氫箟Decimal绫诲瀷鐨勫垪銆備互涓嬫槸涓€涓垱寤鸿〃鏃朵娇鐢―ecimal绫诲瀷鐨勭ず渚嬶細
CREATE TABLE my_table (
id INT PRIMARY KEY,
value DECIMAL(10, 2)
);
- SQL Server锛?/li>
鍦⊿QL Server涓紝鍙互浣跨敤DECIMAL鎴朜UMERIC鍏抽敭瀛楁潵瀹氫箟Decimal绫诲瀷鐨勫垪銆備互涓嬫槸涓€涓垱寤鸿〃鏃朵娇鐢―ecimal绫诲瀷鐨勭ず渚嬶細
CREATE TABLE my_table (
id INT PRIMARY KEY,
value DECIMAL(10, 2)
);
- PostgreSQL锛?/li>
鍦≒ostgreSQL涓紝鍙互浣跨敤DECIMAL鎴朜UMERIC鍏抽敭瀛楁潵瀹氫箟Decimal绫诲瀷鐨勫垪銆備互涓嬫槸涓€涓垱寤鸿〃鏃朵娇鐢―ecimal绫诲瀷鐨勭ず渚嬶細
CREATE TABLE my_table (
id INT PRIMARY KEY,
value DECIMAL(10, 2)
);
- Oracle锛?/li>
鍦∣racle涓紝鍙互浣跨敤NUMBER鍏抽敭瀛楁潵瀹氫箟Decimal绫诲瀷鐨勫垪銆備互涓嬫槸涓€涓垱寤鸿〃鏃朵娇鐢―ecimal绫诲瀷鐨勭ず渚嬶細
CREATE TABLE my_table (
id NUMBER PRIMARY KEY,
value NUMBER(10, 2)
);
浠ヤ笂鏄竴浜涘父瑙佺殑鏁版嵁搴撲腑浣跨敤Decimal绫诲瀷鐨勭ず渚嬶紝鍏蜂綋鐨勮娉曞拰鍙傛暟鍙兘浼氬洜鏁版嵁搴撶鐞嗙郴缁熻€屾湁鎵€涓嶅悓銆傝鏍规嵁鎮ㄦ墍浣跨敤鐨勬暟鎹簱绠＄悊绯荤粺鐨勬枃妗ｈ繘琛屽叿浣撶殑鎿嶄綔銆?/p>
