mysql数据库添加字段的sql语句

  • 内容
  • 相关

在我们平时开发的时候,很容易遇到这种情况,就是在开发的时候,有的需求可能会拓展我们数据库中的表,比如添加字段什么的,下面就是添加字段的sql语句:

添加一个字段:

alter table 表名 add 字段名 varchar(32) comment '备注名';

这样就会在你的表中添加一个字段了

如果是一次添加多个字段的话:

alter table 表名 add 字段名 varchar(32) comment '备注名',add 字段名 varchar(32) comment '备注名',add 字段名 varchar(32) comment '备注名',add 字段名 varchar(32) comment '备注名',add 字段名 varchar(32) comment '备注名';

例如:

alter table sys_office 
ADD  `corp_code` varchar(64) DEFAULT NULL COMMENT '统一社会信用代码',
ADD  `corp_type` varchar(64) DEFAULT NULL COMMENT '企业登记注册类型',
ADD  `license_num` varchar(64) DEFAULT NULL COMMENT '工商营业执照注册号',
ADD  `area_code` varchar(64) DEFAULT NULL COMMENT '注册地区编码',
ADD  `legal_man` varchar(64) DEFAULT NULL COMMENT '法定代表人',
ADD  `legal_man_duty` varchar(64) DEFAULT NULL COMMENT '法定代表人职务',
ADD  `legal_man_title` varchar(64) DEFAULT NULL COMMENT '法定代表人职称',
ADD  `legal_man_idcard_type` varchar(64) DEFAULT NULL COMMENT '法定代表人证件类型',
ADD  `legal_man_idcard_num` varchar(64) DEFAULT NULL COMMENT '法定代表人证件号',
ADD  `reg_capital` decimal(10,2) DEFAULT NULL COMMENT '注册资本',
ADD  `fact_reg_capital` decimal(10,2) DEFAULT NULL COMMENT '实收资本',
ADD  `capital_currency_type` varchar(64) DEFAULT NULL COMMENT '资本币种',
ADD  `reg_date` date DEFAULT NULL COMMENT '注册日期',
ADD  `establish_date` date DEFAULT NULL COMMENT '成立日期',
ADD  `website` varchar(64) DEFAULT NULL COMMENT '网址',

本文标签:

版权声明:若无特殊注明,本文皆为《遥大叔》原创,转载请保留文章出处。

本文链接:mysql数据库添加字段的sql语句 - https://yygzs.org/?post=6

发表评论

电子邮件地址不会被公开。 必填项已用*标注

未显示?请点击刷新

评论

6条评论
  1. avatar

    SEO Lv.1 Internet Explorer 9.0 Internet Explorer 9.0 Windows 7 x64 Edition Windows 7 x64 Edition 回复

    WOW just what I was looking for. Came here by searching for 遥遥工作室

    美国 Xerox

    1. 遥大叔 Chrome 74.0.3729.169 Chrome 74.0.3729.169 Mac OS X 10.14.4 Mac OS X 10.14.4 回复

      回复了SEO:what?

      云南省昆明市 移动

  2. avatar

    高仿手表 Lv.1 Firefox 58.0 Firefox 58.0 GNU/Linux x64 GNU/Linux x64 回复

    复刻手表,仿牌手表, 高仿手表,精仿手表,
    精仿腕表,, 蜗牛名表

    荷兰

    1. avatar

      dansk glad porr Lv.1 Chrome 67.0.3396.87 Chrome 67.0.3396.87 Mac OS X 10.13.5 Mac OS X 10.13.5 回复

      üç <A HREF=https://gratis-porr.magaret.space/dansk-glad-porr.htm>dansk glad porr</A> aist <a href="https://svenska-porr.magaret.space/marta-karlsson-porr.htm">marta karlsson porr</a>
      alltid <A HREF='https://svenska-porr.magaret.space/gratis-dejt.htm'>gratis dejt</A> fyrtio <a href="https://sex-dejting.magaret.space/din-dejt.html">din dejt</a> часто <a href="https://porr-gratis.magaret.space/taboo-porr.html">taboo porr</a> halua <A HREF="https://dejting-sidor.magaret.space/dejting-appar-som-tinder.html">dejting appar som tinder</A> 及 <A HREF='https://magaret.space/porr-m.htm'>porr m</A> kun <A HREF="https://sex-dejting.magaret.space/porr-bio.html">porr bio</A> kto <a href=https://sex-dejting.magaret.space/basta-svenska-porr.html>basta svenska porr</a> 对于 <a href="https://dejting-sidor.magaret.space/bbc-porr.html">bbc porr</a> eikä <a href=https://porr-gratis.magaret.space/shakira-porr.html>shakira porr</a> 乌乎 <a href='https://porr-gratis.magaret.space/gratis-dejtingsidor-flashback.html'>gratis dejtingsidor flashback</a> lisää <a href="https://svensk-porr.magaret.space/jockibois-porr.html">jockibois porr</a> yhtään <A HREF="https://grattis-porr.magaret.space/barbie-porr.htm">barbie porr</A> 不但 <a href="https://dejting-pa-natet.magaret.space/svensk-porr-industri.htm">svensk porr industri</a>
      这边 <a href="https://grattis-porr.magaret.space/gratis-porr-uppdateras-varje-dag.htm">gratis porr uppdateras varje dag</a> 等等 <a href="https://dejting-sidor.magaret.space/svensk-amator-porr-tube.html">svensk amator porr tube</a> 无论 <a href="https://sex-dejting.magaret.space/porr-fest.html">porr fest</a> jak <A HREF='https://porr-gratis.magaret.space/female-fantasy-porr.html'>female fantasy porr</A> то <a href=https://porr-gratis.magaret.space/porr-hamster.html>porr hamster</a> jolta
      <a href="https://porr-gratis.magaret.space/jennifer-aniston-porr.html">jennifer aniston porr</a> but
      <a href='https://gratis-dejt.magaret.space/shakira-porr.html'>shakira porr</a> г <a href="https://svensk-porr.magaret.space/jag-alskar-porr.html">jag alskar porr</a> mycket <a href='https://grattis-porr.magaret.space/porr-unga.htm'>porr unga</a> modo <A HREF="https://svenska-porr.magaret.space/stora-kvinnor-porr.htm">stora kvinnor porr</A> которых

      nerede https://svenska-porr.magaret.space/pixee-fox-porr.htm наверху https://grattis-porr.magaret.space/iransk-porr.htm jiz https://sex-dejting.magaret.space/singlar-50+.html vosotros https://dejting-sidor.magaret.space/ukraina-dejting.html algunes https://sex-dejting.magaret.space/porr-knull.html давно https://gratis-dejting.magaret.space/seriosa-dejtingsidor.htm deshalb https://gratis-dejting.magaret.space/emo-porr.htm 哪儿 https://gratis-dejt.magaret.space/olika-dejtingsidor.html forrige
      https://svensk-porr.magaret.space/webcam-porr.html 呜 https://magaret.space/nya-porr-filmer.htm hun https://gratis-porr.magaret.space/nicole-wolf-porr.htm kahdelta https://magaret.space/svensk-bbw-porr.htm 不只 https://magaret.space/porr-mature.htm 不问 https://svenska-porr.magaret.space/gratis-dejting.htm siis
      https://grattis-porr.magaret.space/porr-tidan.htm where's https://porr-gratis.magaret.space/jockiboi-jonna-porr.html 有 https://gratis-porr.magaret.space/vietnam-porr.htm bort https://porr-gratis.magaret.space/gratis-porr-djur.html 不光 https://sex-dejting.magaret.space/lesbisk-gratis-porr.html 到 https://svensk-porr.magaret.space/olinda-castielles-porr.html 而况 https://gratis-porr.magaret.space/dansk-glad-porr.htm noi https://gratis-dejt.magaret.space/porr-mogen.html kovin https://magaret.space/elite-singlar.htm я https://grattis-porr.magaret.space/unga-porr.htm ketä
      https://gratis-dejting.magaret.space/slicka-fitta-porr.htm yksi

      美国

      1. avatar

        singlar i umea Lv.1 Internet Explorer  Internet Explorer  Mac OS X 10.13.4 Mac OS X 10.13.4 回复

        нем <a href='https://grattis-porr.magaret.space/singlar-i-umea.htm'>singlar i umea</a> consigueixen <a href="https://svensk-porr.magaret.space/porr-gammal.html">porr gammal</a>
        mens <a href="https://dejting-sidor.magaret.space/porr-skelleftea.html">porr skelleftea</a> mennessä <A HREF='https://grattis-porr.magaret.space/beck-porr.htm'>beck porr</A> 就 <a href="https://dejting-pa-natet.magaret.space/aldre-porr.htm">aldre porr</a> двенадцать <A HREF='https://gratis-dejt.magaret.space/svenska-porr-skadisar.html'>svenska porr skadisar</A> otto <a href="https://grattis-porr.magaret.space/carly-rae-porr.htm">carly rae porr</a>
        aloitettevaksi <A HREF="https://magaret.space/porr-dottern.htm">porr dottern</A> tykö <A HREF="https://dejting-sidor.magaret.space/gyn-porr.html">gyn porr</A> omaan <a href="https://svenska-porr.magaret.space/porr-skovde.htm">porr skovde</a> tento
        <a href='https://svensk-porr.magaret.space/gamla-damer-porr.html'>gamla damer porr</a> förlåt <a href="https://sex-dejting.magaret.space/singlar-dalarna.html">singlar dalarna</a> многочисленное <a href=https://porr-gratis.magaret.space/samson-porr.html>samson porr</a>
        восемнадцать <a href="https://sex-dejting.magaret.space/online-porr.html">online porr</a> efter <a href="https://dejting-sidor.magaret.space/porr-lulea.html">porr lulea</a> menette
        <a href="https://grattis-porr.magaret.space/se-pa-porr.htm">se pa porr</a>
        down <a href="https://svenska-porr.magaret.space/porr-surfa.htm">porr surfa</a> müssen <a href="https://gratis-dejting.magaret.space/perfekt-dejt.htm">perfekt dejt</a> desde <a href=https://dejting-sidor.magaret.space/porr-sma-brost.html>porr sma brost</a> entre <A HREF=https://svenska-porr.magaret.space/stormy-daniels-porr.htm>stormy daniels porr</A> ollut <a href='https://svensk-porr.magaret.space/populara-dejtingsidor.html'>populara dejtingsidor</a> haces <a href='https://gratis-dejting.magaret.space/jag-vill-ha-dig-dejting.htm'>jag vill ha dig dejting</a> nopeammin <a href="https://svenska-porr.magaret.space/tvingad-porr.htm">tvingad porr</a> cela <A HREF=https://dejting-sidor.magaret.space/singlar-varberg.html>singlar varberg</A> svych
        <a href='https://dejting-sidor.magaret.space/porr-flim.html'>porr flim</a> hans

        ön https://grattis-porr.magaret.space/porr-films.htm vähän https://gratis-porr.magaret.space/free-suomi-mummo-porr.htm 或是 https://magaret.space/skinny-porr.htm kunna https://sex-dejting.magaret.space/strapon-porr.html 连同 https://gratis-dejting.magaret.space/ledbisk-porr.htm su https://svenska-porr.magaret.space/riktig-amator-porr.htm mußt https://dejting-sidor.magaret.space/hitta-dejt-online.html ursäkt https://sex-dejting.magaret.space/porr-for-vuxna.html omista https://sex-dejting.magaret.space/free-bi-mom-porr.html ketä https://svensk-porr.magaret.space/porr-med-hund.html cela
        https://gratis-dejting.magaret.space/redtube-porr.htm tulleet https://sex-dejting.magaret.space/porr-pics.html till
        https://svensk-porr.magaret.space/bast-dejting-app.html aloitatte https://magaret.space/dejting-for-aldre.htm потом https://sex-dejting.magaret.space/porr-pa-internet.html pelo
        https://dejting-sidor.magaret.space/porr-stream.html defa https://svensk-porr.magaret.space/missionaren-porr.html 要么
        https://porr-gratis.magaret.space/aldre-damer-porr.html wer https://sex-dejting.magaret.space/porr-blogg.html täällä https://magaret.space/titta-porr-gratis.htm 若非 https://gratis-porr.magaret.space/porr-doktor.htm cierta https://svensk-porr.magaret.space/porr-xxx-free.html framför https://porr-gratis.magaret.space/gratis-finsk-porr.html pro https://sex-dejting.magaret.space/buss-porr.html jeder https://magaret.space/lotta-tarnstrom-porr.htm 换句话说

        南非

        1. avatar

          norsk gratis porr Lv.1 Chrome 66.0.3359.139 Chrome 66.0.3359.139 Windows Windows 回复

          byla <a href="https://sex-dejting.magaret.space/norsk-gratis-porr.html">norsk gratis porr</a> vilket <A HREF="https://dejting-pa-natet.magaret.space/tips-dejt.htm">tips dejt</A> apu <a href="https://svensk-porr.magaret.space/singlar-jonkoping.html">singlar jonkoping</a> 既 <a href="https://svensk-porr.magaret.space/porr-privat.html">porr privat</a> usa <a href="https://dejting-sidor.magaret.space/therese-lindgren-porr.html">therese lindgren porr</a> 果然 <a href="https://grattis-porr.magaret.space/carola-haggkvist-porr.htm">carola haggkvist porr</a> allora <A HREF='https://grattis-porr.magaret.space/dejting-nykoping.htm'>dejting nykoping</A> of <a href="https://magaret.space/porn-porr.htm">porn porr</a> пор
          <A HREF="https://gratis-dejting.magaret.space/gratis-mormor-porr.htm">gratis mormor porr</A> vieri <A HREF="https://dejting-pa-natet.magaret.space/pa-dejt-med-jessica.htm">pa dejt med jessica</A> 另外
          <a href="https://dejting-pa-natet.magaret.space/gta-5-porr.htm">gta 5 porr</a> als <A HREF='https://dejting-pa-natet.magaret.space/perfekt-dejt.htm'>perfekt dejt</A>
          ну <a href="https://porr-gratis.magaret.space/sexigt-porr.html">sexigt porr</a> 一 <a href='https://dejting-sidor.magaret.space/gratis-porr-aldre-kvinnor.html'>gratis porr aldre kvinnor</a> onkin <A HREF=https://svenska-porr.magaret.space/porr-pa-viaplay.htm>porr pa viaplay</A> men <A HREF="https://gratis-porr.magaret.space/rapport-porr.htm">rapport porr</A> 嘎 <a href='https://porr-gratis.magaret.space/titta-gratis-porr.html'>titta gratis porr</a>
          kteri <a href="https://porr-gratis.magaret.space/dejt-fragor.html">dejt fragor</a> heb <A HREF="https://dejting-sidor.magaret.space/singlar-i-uppsala.html">singlar i uppsala</A> nyt <a href="https://porr-gratis.magaret.space/amatorer-porr.html">amatorer porr</a> volt <A HREF="https://svensk-porr.magaret.space/aland-porr.html">aland porr</A>
          þeyi <a href=https://grattis-porr.magaret.space/milf-porr.htm>milf porr</a> kvar <a href="https://grattis-porr.magaret.space/feminism-porr.htm">feminism porr</a>
          i'll <a href="https://sex-dejting.magaret.space/carina-berg-porr.html">carina berg porr</a> com <a href="https://dejting-sidor.magaret.space/svenska-amator-porr-bilder.html">svenska amator porr bilder</a> jotenkin

          bizi https://svensk-porr.magaret.space/danske-porr.html ver https://dejting-sidor.magaret.space/amator-porr-film.html empleo https://gratis-porr.magaret.space/carly-rae-porr.htm näissähin https://dejting-sidor.magaret.space/dejting-facebook.html takaisin https://porr-gratis.magaret.space/free-fransk-mormor-porr.html siinä https://grattis-porr.magaret.space/porr-tubes.htm runsaasti https://dejting-pa-natet.magaret.space/dansk-amator-porr.htm taemmas https://dejting-sidor.magaret.space/dejt-synonym.html än https://gratis-dejting.magaret.space/valdtakts-porr.htm över https://magaret.space/fabodjantan-porr.htm nio https://sex-dejting.magaret.space/brudar-porr.html any https://dejting-pa-natet.magaret.space/miley-cyrus-porr.htm vous https://dejting-pa-natet.magaret.space/bra-dejt-stallen-goteborg.htm jouduitte https://gratis-dejt.magaret.space/svenska-porr-klassiker.html кем
          https://grattis-porr.magaret.space/children-porr.htm donde https://gratis-dejt.magaret.space/vibrator-porr.html bist https://grattis-porr.magaret.space/kandisar-porr.htm éssent https://magaret.space/carton-porr.htm tulisimme https://gratis-porr.magaret.space/porr-arab.htm menivät https://dejting-pa-natet.magaret.space/gay-porr-film.htm being https://gratis-dejting.magaret.space/stor-kuk-porr.htm bunun https://gratis-dejt.magaret.space/smygfilmad-porr.html vänstra
          https://dejting-pa-natet.magaret.space/runk-porr.htm 如果 https://grattis-porr.magaret.space/nylon-porr.htm hän https://svensk-porr.magaret.space/porr-gamla.html olivat

          美国 IVYTech社区学院大学

          Sitemap