티스토리 뷰

공부

[mysql] ALTER TABLE `t` MODIFY COLUMN `c` DECIMAL(4,2);

승가비 2023. 8. 20. 12:33
728x90

https://stackoverflow.com/questions/19773164/mysql-how-do-i-update-the-decimal-column-to-allow-more-digits

 

MySQL - How do I update the decimal column to allow more digits?

I'm a beginner in MySQL, and I accidentally created a table with a column named (price decimal(2,2)); It needs to be decimal(4,2) to allow 4 digits. Since I've already created it, what is the ea...

stackoverflow.com

https://stackoverflow.com/questions/120083/how-do-i-alter-the-precision-of-a-decimal-column-in-microsoft-sql-server

 

How do I alter the precision of a decimal column in Microsoft SQL Server?

Is there a way to alter the precision of an existing decimal column in Microsoft SQL Server?

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[mysql] * * * * * rm -rf /var/lib/mysql/binlog*  (0) 2023.08.20
[reactjs] npm install --save-dev env-cmd; ./node_modules/.bin/env-cmd -f ./stage.env npm build  (0) 2023.08.20
[macosx] adb (android-platform-tools)  (0) 2023.08.20
[sh] kill -9 `pgrep -f ${PRODUCT_CODE}`  (0) 2023.08.20
[maxosx] 미러링 전환 (cmd + f1)  (0) 2023.08.20
댓글