Technology Sharing

MySQL common commands

2024-07-12

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

1. Add fields to table

ALTER TABLE ${database}.${table} ADD COLUMN ${word} ${type} DEFAULT '${default}' COMMENT '${comment}';

  • 1

如: ALTER TABLE testdatabase.testtable ADD COLUMN testword varchar(255) DEFAULT ‘’ COMMENT ‘’;

Personal profile

I have devoted myself to the research of technology for more than 30 years. I am proficient in various languages ​​such as Java, Linux, JavaScript, PHP, CSS, etc. I have made many contributions in the field of open source. I have established a developer documentation site to share some problems in technology development for everyone to read.

my contact information

Mail