[原創] mysql表欄位多少限定
我們知道在Oracle中一個表上的欄位最多隻能有1000個,那麼在mysql,一個表上能有多少個欄位呢?
今天在PUB上看到一個貼子(http://www.itpub.net/thread-1045069-1-1.html)於是查了下文件,沒有發現相關說明.
測試了一下,發現了一個"奇怪"的數字--2599,不知和版本是否有關係?
測試過程
1.建立一個測試表
mysql> select version();
+-----------------+
| version() |
+-----------------+
| 5.0.26-standard |
+-----------------+
1 row in set (0.00 sec)
mysql> create table t1(id int) ;
Query OK, 0 rows affected (0.02 sec)
mysql> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
2.書寫一個測試指令碼
[root@dbatest1 shell]# cat add_col.sh
#!/bin/sh
x=1
while [ $x -le 3000 ]
do
mysql -uroot -pabc123 -Ddb1 << EOF >> /root/shell/add_col_log.log
alter table t1 add column f$x char(1);
EOF
x=`expr $x + 1`
done
[root@dbatest1 shell]#
3.發現新增到2598是可以成功的.到2599時就失敗了
+ x=2598
+ '[' 2598 -le 3000 ']'
+ mysql -uroot -pabc123 -Ddb1
++ expr 2598 + 1
+ x=2599
+ '[' 2599 -le 3000 ']'
+ mysql -uroot -pabc123 -Ddb1
ERROR 1117 (HY000) at line 1: Too many columns
4.DESC表,確認.最多還是2599列
mysql> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| f1 | char(1) | YES | | NULL | |
| f2 | char(1) | YES | | NULL | |
| f3 | char(1) | YES | | NULL | |
| f4 | char(1) | YES | | NULL | |
| f5 | char(1) | YES | | NULL | |
| f6 | char(1) | YES | | NULL | |
| f7 | char(1) | YES | | NULL | |
| f8 | char(1) | YES | | NULL | |
| f9 | char(1) | YES | | NULL | |
| f10 | char(1) | YES | | NULL | |
| f11 | char(1) | YES | | NULL | |
| f12 | char(1) | YES | | NULL | |
| f13 | char(1) | YES | | NULL | |
| f14 | char(1) | YES | | NULL | |
| f15 | char(1) | YES | | NULL | |
| f16 | char(1) | YES | | NULL | |
| f17 | char(1) | YES | | NULL | |
| f18 | char(1) | YES | | NULL | |
| f19 | char(1) | YES | | NULL | |
| f20 | char(1) | YES | | NULL | |
| f21 | char(1) | YES | | NULL | |
| f22 | char(1) | YES | | NULL | |
| f23 | char(1) | YES | | NULL | |
| f24 | char(1) | YES | | NULL | |
| f25 | char(1) | YES | | NULL | |
| f26 | char(1) | YES | | NULL | |
| f27 | char(1) | YES | | NULL | |
| f28 | char(1) | YES | | NULL | |
| f29 | char(1) | YES | | NULL | |
| f30 | char(1) | YES | | NULL | |
| f31 | char(1) | YES | | NULL | |
| f32 | char(1) | YES | | NULL | |
| f33 | char(1) | YES | | NULL | |
| f34 | char(1) | YES | | NULL | |
| f35 | char(1) | YES | | NULL | |
| f36 | char(1) | YES | | NULL | |
| f37 | char(1) | YES | | NULL | |
| f38 | char(1) | YES | | NULL | |
| f39 | char(1) | YES | | NULL | |
| f40 | char(1) | YES | | NULL | |
| f41 | char(1) | YES | | NULL | |
| f42 | char(1) | YES | | NULL | |
| f43 | char(1) | YES | | NULL | |
| f44 | char(1) | YES | | NULL | |
| f45 | char(1) | YES | | NULL | |
| f46 | char(1) | YES | | NULL | |
| f47 | char(1) | YES | | NULL | |
| f48 | char(1) | YES | | NULL | |
| f49 | char(1) | YES | | NULL | |
| f50 | char(1) | YES | | NULL | |
| f51 | char(1) | YES | | NULL | |
| f52 | char(1) | YES | | NULL | |
| f53 | char(1) | YES | | NULL | |
| f54 | char(1) | YES | | NULL | |
| f55 | char(1) | YES | | NULL | |
| f56 | char(1) | YES | | NULL | |
| f57 | char(1) | YES | | NULL | |
| f58 | char(1) | YES | | NULL | |
| f59 | char(1) | YES | | NULL | |
| f60 | char(1) | YES | | NULL | |
| f61 | char(1) | YES | | NULL | |
| f62 | char(1) | YES | | NULL | |
| f63 | char(1) | YES | | NULL | |
| f64 | char(1) | YES | | NULL | |
| f65 | char(1) | YES | | NULL | |
| f66 | char(1) | YES | | NULL | |
| f67 | char(1) | YES | | NULL | |
| f68 | char(1) | YES | | NULL | |
| f69 | char(1) | YES | | NULL | |
| f70 | char(1) | YES | | NULL | |
| f71 | char(1) | YES | | NULL | |
| f72 | char(1) | YES | | NULL | |
| f73 | char(1) | YES | | NULL | |
| f74 | char(1) | YES | | NULL | |
| f75 | char(1) | YES | | NULL | |
| f76 | char(1) | YES | | NULL | |
| f77 | char(1) | YES | | NULL | |
| f78 | char(1) | YES | | NULL | |
| f79 | char(1) | YES | | NULL | |
| f80 | char(1) | YES | | NULL | |
| f81 | char(1) | YES | | NULL | |
| f82 | char(1) | YES | | NULL | |
| f83 | char(1) | YES | | NULL | |
| f84 | char(1) | YES | | NULL | |
| f85 | char(1) | YES | | NULL | |
| f86 | char(1) | YES | | NULL | |
| f87 | char(1) | YES | | NULL | |
| f88 | char(1) | YES | | NULL | |
| f89 | char(1) | YES | | NULL | |
| f90 | char(1) | YES | | NULL | |
| f91 | char(1) | YES | | NULL | |
| f92 | char(1) | YES | | NULL | |
| f93 | char(1) | YES | | NULL | |
| f94 | char(1) | YES | | NULL | |
| f95 | char(1) | YES | | NULL | |
| f96 | char(1) | YES | | NULL | |
| f97 | char(1) | YES | | NULL | |
| f98 | char(1) | YES | | NULL | |
| f99 | char(1) | YES | | NULL | |
| f100 | char(1) | YES | | NULL | |
| f101 | char(1) | YES | | NULL | |
| f102 | char(1) | YES | | NULL | |
| f103 | char(1) | YES | | NULL | |
| f104 | char(1) | YES | | NULL | |
| f105 | char(1) | YES | | NULL | |
| f106 | char(1) | YES | | NULL | |
| f107 | char(1) | YES | | NULL | |
| f108 | char(1) | YES | | NULL | |
| f109 | char(1) | YES | | NULL | |
| f110 | char(1) | YES | | NULL | |
| f111 | char(1) | YES | | NULL | |
| f112 | char(1) | YES | | NULL | |
| f113 | char(1) | YES | | NULL | |
| f114 | char(1) | YES | | NULL | |
| f115 | char(1) | YES | | NULL | |
| f116 | char(1) | YES | | NULL | |
| f117 | char(1) | YES | | NULL | |
| f118 | char(1) | YES | | NULL | |
| f119 | char(1) | YES | | NULL | |
| f120 | char(1) | YES | | NULL | |
| f121 | char(1) | YES | | NULL | |
| f122 | char(1) | YES | | NULL | |
| f123 | char(1) | YES | | NULL | |
| f124 | char(1) | YES | | NULL | |
| f125 | char(1) | YES | | NULL | |
| f126 | char(1) | YES | | NULL | |
| f127 | char(1) | YES | | NULL | |
| f128 | char(1) | YES | | NULL | |
| f129 | char(1) | YES | | NULL | |
| f130 | char(1) | YES | | NULL | |
| f131 | char(1) | YES | | NULL | |
| f132 | char(1) | YES | | NULL | |
| f133 | char(1) | YES | | NULL | |
| f134 | char(1) | YES | | NULL | |
| f135 | char(1) | YES | | NULL | |
| f136 | char(1) | YES | | NULL | |
| f137 | char(1) | YES | | NULL | |
| f138 | char(1) | YES | | NULL | |
| f139 | char(1) | YES | | NULL | |
| f140 | char(1) | YES | | NULL | |
| f141 | char(1) | YES | | NULL | |
| f142 | char(1) | YES | | NULL | |
| f143 | char(1) | YES | | NULL | |
| f144 | char(1) | YES | | NULL | |
| f145 | char(1) | YES | | NULL | |
| f146 | char(1) | YES | | NULL | |
| f147 | char(1) | YES | | NULL | |
| f148 | char(1) | YES | | NULL | |
| f149 | char(1) | YES | | NULL | |
| f150 | char(1) | YES | | NULL | |
| f151 | char(1) | YES | | NULL | |
| f152 | char(1) | YES | | NULL | |
| f153 | char(1) | YES | | NULL | |
| f154 | char(1) | YES | | NULL | |
| f155 | char(1) | YES | | NULL | |
| f156 | char(1) | YES | | NULL | |
| f157 | char(1) | YES | | NULL | |
| f158 | char(1) | YES | | NULL | |
| f159 | char(1) | YES | | NULL | |
| f160 | char(1) | YES | | NULL | |
| f161 | char(1) | YES | | NULL | |
| f162 | char(1) | YES | | NULL | |
| f163 | char(1) | YES | | NULL | |
| f164 | char(1) | YES | | NULL | |
| f165 | char(1) | YES | | NULL | |
| f166 | char(1) | YES | | NULL | |
| f167 | char(1) | YES | | NULL | |
| f168 | char(1) | YES | | NULL | |
| f169 | char(1) | YES | | NULL | |
| f170 | char(1) | YES | | NULL | |
| f171 | char(1) | YES | | NULL | |
| f172 | char(1) | YES | | NULL | |
| f173 | char(1) | YES | | NULL | |
| f174 | char(1) | YES | | NULL | |
| f175 | char(1) | YES | | NULL | |
| f176 | char(1) | YES | | NULL | |
| f177 | char(1) | YES | | NULL | |
| f178 | char(1) | YES | | NULL | |
| f179 | char(1) | YES | | NULL | |
| f180 | char(1) | YES | | NULL | |
| f181 | char(1) | YES | | NULL | |
| f182 | char(1) | YES | | NULL | |
| f183 | char(1) | YES | | NULL | |
| f184 | char(1) | YES | | NULL | |
| f185 | char(1) | YES | | NULL | |
| f186 | char(1) | YES | | NULL | |
| f187 | char(1) | YES | | NULL | |
| f188 | char(1) | YES | | NULL | |
| f189 | char(1) | YES | | NULL | |
| f190 | char(1) | YES | | NULL | |
| f191 | char(1) | YES | | NULL | |
| f192 | char(1) | YES | | NULL | |
| f193 | char(1) | YES | | NULL | |
| f194 | char(1) | YES | | NULL | |
| f195 | char(1) | YES | | NULL | |
| f196 | char(1) | YES | | NULL | |
| f197 | char(1) | YES | | NULL | |
| f198 | char(1) | YES | | NULL | |
| f199 | char(1) | YES | | NULL | |
| f200 | char(1) | YES | | NULL | |
| f201 | char(1) | YES | | NULL | |
| f202 | char(1) | YES | | NULL | |
| f203 | char(1) | YES | | NULL | |
| f204 | char(1) | YES | | NULL | |
| f205 | char(1) | YES | | NULL | |
| f206 | char(1) | YES | | NULL | |
| f207 | char(1) | YES | | NULL | |
| f208 | char(1) | YES | | NULL | |
| f209 | char(1) | YES | | NULL | |
| f210 | char(1) | YES | | NULL | |
| f211 | char(1) | YES | | NULL | |
| f212 | char(1) | YES | | NULL | |
| f213 | char(1) | YES | | NULL | |
| f214 | char(1) | YES | | NULL | |
| f215 | char(1) | YES | | NULL | |
| f216 | char(1) | YES | | NULL | |
| f217 | char(1) | YES | | NULL | |
| f218 | char(1) | YES | | NULL | |
| f219 | char(1) | YES | | NULL | |
| f220 | char(1) | YES | | NULL | |
| f221 | char(1) | YES | | NULL | |
| f222 | char(1) | YES | | NULL | |
| f223 | char(1) | YES | | NULL | |
| f224 | char(1) | YES | | NULL | |
| f225 | char(1) | YES | | NULL | |
| f226 | char(1) | YES | | NULL | |
| f227 | char(1) | YES | | NULL | |
| f228 | char(1) | YES | | NULL | |
| f229 | char(1) | YES | | NULL | |
| f230 | char(1) | YES | | NULL | |
| f231 | char(1) | YES | | NULL | |
| f232 | char(1) | YES | | NULL | |
| f233 | char(1) | YES | | NULL | |
| f234 | char(1) | YES | | NULL | |
| f235 | char(1) | YES | | NULL | |
| f236 | char(1) | YES | | NULL | |
| f237 | char(1) | YES | | NULL | |
| f238 | char(1) | YES | | NULL | |
| f239 | char(1) | YES | | NULL | |
| f240 | char(1) | YES | | NULL | |
| f241 | char(1) | YES | | NULL | |
| f242 | char(1) | YES | | NULL | |
| f243 | char(1) | YES | | NULL | |
| f244 | char(1) | YES | | NULL | |
| f245 | char(1) | YES | | NULL | |
| f246 | char(1) | YES | | NULL | |
| f247 | char(1) | YES | | NULL | |
| f248 | char(1) | YES | | NULL | |
| f249 | char(1) | YES | | NULL | |
| f250 | char(1) | YES | | NULL | |
| f251 | char(1) | YES | | NULL | |
| f252 | char(1) | YES | | NULL | |
| f253 | char(1) | YES | | NULL | |
| f254 | char(1) | YES | | NULL | |
| f255 | char(1) | YES | | NULL | |
| f256 | char(1) | YES | | NULL | |
| f257 | char(1) | YES | | NULL | |
| f258 | char(1) | YES | | NULL | |
| f259 | char(1) | YES | | NULL | |
| f260 | char(1) | YES | | NULL | |
| f261 | char(1) | YES | | NULL | |
| f262 | char(1) | YES | | NULL | |
| f263 | char(1) | YES | | NULL | |
| f264 | char(1) | YES | | NULL | |
| f265 | char(1) | YES | | NULL | |
| f266 | char(1) | YES | | NULL | |
| f267 | char(1) | YES | | NULL | |
| f268 | char(1) | YES | | NULL | |
| f269 | char(1) | YES | | NULL | |
| f270 | char(1) | YES | | NULL | |
| f271 | char(1) | YES | | NULL | |
| f272 | char(1) | YES | | NULL | |
| f273 | char(1) | YES | | NULL | |
| f274 | char(1) | YES | | NULL | |
| f275 | char(1) | YES | | NULL | |
| f276 | char(1) | YES | | NULL | |
| f277 | char(1) | YES | | NULL | |
| f278 | char(1) | YES | | NULL | |
| f279 | char(1) | YES | | NULL | |
| f280 | char(1) | YES | | NULL | |
| f281 | char(1) | YES | | NULL | |
| f282 | char(1) | YES | | NULL | |
| f283 | char(1) | YES | | NULL | |
| f284 | char(1) | YES | | NULL | |
| f285 | char(1) | YES | | NULL | |
| f286 | char(1) | YES | | NULL | |
| f287 | char(1) | YES | | NULL | |
| f288 | char(1) | YES | | NULL | |
| f289 | char(1) | YES | | NULL | |
| f290 | char(1) | YES | | NULL | |
| f291 | char(1) | YES | | NULL | |
| f292 | char(1) | YES | | NULL | |
| f293 | char(1) | YES | | NULL | |
| f294 | char(1) | YES | | NULL | |
| f295 | char(1) | YES | | NULL | |
| f296 | char(1) | YES | | NULL | |
| f297 | char(1) | YES | | NULL | |
| f298 | char(1) | YES | | NULL | |
| f299 | char(1) | YES | | NULL | |
| f300 | char(1) | YES | | NULL | |
| f301 | char(1) | YES | | NULL | |
| f302 | char(1) | YES | | NULL | |
| f303 | char(1) | YES | | NULL | |
| f304 | char(1) | YES | | NULL | |
| f305 | char(1) | YES | | NULL | |
| f306 | char(1) | YES | | NULL | |
| f307 | char(1) | YES | | NULL | |
| f308 | char(1) | YES | | NULL | |
| f309 | char(1) | YES | | NULL | |
| f310 | char(1) | YES | | NULL | |
| f311 | char(1) | YES | | NULL | |
| f312 | char(1) | YES | | NULL | |
| f313 | char(1) | YES | | NULL | |
| f314 | char(1) | YES | | NULL | |
| f315 | char(1) | YES | | NULL | |
| f316 | char(1) | YES | | NULL | |
| f317 | char(1) | YES | | NULL | |
| f318 | char(1) | YES | | NULL | |
| f319 | char(1) | YES | | NULL | |
| f320 | char(1) | YES | | NULL | |
| f321 | char(1) | YES | | NULL | |
| f322 | char(1) | YES | | NULL | |
| f323 | char(1) | YES | | NULL | |
| f324 | char(1) | YES | | NULL | |
| f325 | char(1) | YES | | NULL | |
| f326 | char(1) | YES | | NULL | |
| f327 | char(1) | YES | | NULL | |
| f328 | char(1) | YES | | NULL | |
| f329 | char(1) | YES | | NULL | |
| f330 | char(1) | YES | | NULL | |
| f331 | char(1) | YES | | NULL | |
| f332 | char(1) | YES | | NULL | |
| f333 | char(1) | YES | | NULL | |
| f334 | char(1) | YES | | NULL | |
| f335 | char(1) | YES | | NULL | |
| f336 | char(1) | YES | | NULL | |
| f337 | char(1) | YES | | NULL | |
| f338 | char(1) | YES | | NULL | |
| f339 | char(1) | YES | | NULL | |
| f340 | char(1) | YES | | NULL | |
| f341 | char(1) | YES | | NULL | |
| f342 | char(1) | YES | | NULL | |
| f343 | char(1) | YES | | NULL | |
| f344 | char(1) | YES | | NULL | |
| f345 | char(1) | YES | | NULL | |
| f346 | char(1) | YES | | NULL | |
| f347 | char(1) | YES | | NULL | |
| f348 | char(1) | YES | | NULL | |
| f349 | char(1) | YES | | NULL | |
| f350 | char(1) | YES | | NULL | |
| f351 | char(1) | YES | | NULL | |
| f352 | char(1) | YES | | NULL | |
| f353 | char(1) | YES | | NULL | |
| f354 | char(1) | YES | | NULL | |
| f355 | char(1) | YES | | NULL | |
| f356 | char(1) | YES | | NULL | |
| f357 | char(1) | YES | | NULL | |
| f358 | char(1) | YES | | NULL | |
| f359 | char(1) | YES | | NULL | |
| f360 | char(1) | YES | | NULL | |
| f361 | char(1) | YES | | NULL | |
| f362 | char(1) | YES | | NULL | |
| f363 | char(1) | YES | | NULL | |
| f364 | char(1) | YES | | NULL | |
| f365 | char(1) | YES | | NULL | |
| f366 | char(1) | YES | | NULL | |
| f367 | char(1) | YES | | NULL | |
| f368 | char(1) | YES | | NULL | |
| f369 | char(1) | YES | | NULL | |
| f370 | char(1) | YES | | NULL | |
| f371 | char(1) | YES | | NULL | |
| f372 | char(1) | YES | | NULL | |
| f373 | char(1) | YES | | NULL | |
| f374 | char(1) | YES | | NULL | |
| f375 | char(1) | YES | | NULL | |
| f376 | char(1) | YES | | NULL | |
| f377 | char(1) | YES | | NULL | |
| f378 | char(1) | YES | | NULL | |
| f379 | char(1) | YES | | NULL | |
| f380 | char(1) | YES | | NULL | |
| f381 | char(1) | YES | | NULL | |
| f382 | char(1) | YES | | NULL | |
| f383 | char(1) | YES | | NULL | |
| f384 | char(1) | YES | | NULL | |
| f385 | char(1) | YES | | NULL | |
| f386 | char(1) | YES | | NULL | |
| f387 | char(1) | YES | | NULL | |
| f388 | char(1) | YES | | NULL | |
| f389 | char(1) | YES | | NULL | |
| f390 | char(1) | YES | | NULL | |
| f391 | char(1) | YES | | NULL | |
| f392 | char(1) | YES | | NULL | |
| f393 | char(1) | YES | | NULL | |
| f394 | char(1) | YES | | NULL | |
| f395 | char(1) | YES | | NULL | |
| f396 | char(1) | YES | | NULL | |
| f397 | char(1) | YES | | NULL | |
| f398 | char(1) | YES | | NULL | |
| f399 | char(1) | YES | | NULL | |
| f400 | char(1) | YES | | NULL | |
| f401 | char(1) | YES | | NULL | |
| f402 | char(1) | YES | | NULL | |
| f403 | char(1) | YES | | NULL | |
| f404 | char(1) | YES | | NULL | |
| f405 | char(1) | YES | | NULL | |
| f406 | char(1) | YES | | NULL | |
| f407 | char(1) | YES | | NULL | |
| f408 | char(1) | YES | | NULL | |
| f409 | char(1) | YES | | NULL | |
| f410 | char(1) | YES | | NULL | |
| f411 | char(1) | YES | | NULL | |
| f412 | char(1) | YES | | NULL | |
| f413 | char(1) | YES | | NULL | |
| f414 | char(1) | YES | | NULL | |
| f415 | char(1) | YES | | NULL | |
| f416 | char(1) | YES | | NULL | |
| f417 | char(1) | YES | | NULL | |
| f418 | char(1) | YES | | NULL | |
| f419 | char(1) | YES | | NULL | |
| f420 | char(1) | YES | | NULL | |
| f421 | char(1) | YES | | NULL | |
| f422 | char(1) | YES | | NULL | |
| f423 | char(1) | YES | | NULL | |
| f424 | char(1) | YES | | NULL | |
| f425 | char(1) | YES | | NULL | |
| f426 | char(1) | YES | | NULL | |
| f427 | char(1) | YES | | NULL | |
| f428 | char(1) | YES | | NULL | |
| f429 | char(1) | YES | | NULL | |
| f430 | char(1) | YES | | NULL | |
| f431 | char(1) | YES | | NULL | |
| f432 | char(1) | YES | | NULL | |
| f433 | char(1) | YES | | NULL | |
| f434 | char(1) | YES | | NULL | |
| f435 | char(1) | YES | | NULL | |
| f436 | char(1) | YES | | NULL | |
| f437 | char(1) | YES | | NULL | |
| f438 | char(1) | YES | | NULL | |
| f439 | char(1) | YES | | NULL | |
| f440 | char(1) | YES | | NULL | |
| f441 | char(1) | YES | | NULL | |
| f442 | char(1) | YES | | NULL | |
| f443 | char(1) | YES | | NULL | |
| f444 | char(1) | YES | | NULL | |
| f445 | char(1) | YES | | NULL | |
| f446 | char(1) | YES | | NULL | |
| f447 | char(1) | YES | | NULL | |
| f448 | char(1) | YES | | NULL | |
| f449 | char(1) | YES | | NULL | |
| f450 | char(1) | YES | | NULL | |
| f451 | char(1) | YES | | NULL | |
| f452 | char(1) | YES | | NULL | |
| f453 | char(1) | YES | | NULL | |
| f454 | char(1) | YES | | NULL | |
| f455 | char(1) | YES | | NULL | |
| f456 | char(1) | YES | | NULL | |
| f457 | char(1) | YES | | NULL | |
| f458 | char(1) | YES | | NULL | |
| f459 | char(1) | YES | | NULL | |
| f460 | char(1) | YES | | NULL | |
| f461 | char(1) | YES | | NULL | |
| f462 | char(1) | YES | | NULL | |
| f463 | char(1) | YES | | NULL | |
| f464 | char(1) | YES | | NULL | |
| f465 | char(1) | YES | | NULL | |
| f466 | char(1) | YES | | NULL | |
| f467 | char(1) | YES | | NULL | |
| f468 | char(1) | YES | | NULL | |
| f469 | char(1) | YES | | NULL | |
| f470 | char(1) | YES | | NULL | |
| f471 | char(1) | YES | | NULL | |
| f472 | char(1) | YES | | NULL | |
| f473 | char(1) | YES | | NULL | |
| f474 | char(1) | YES | | NULL | |
| f475 | char(1) | YES | | NULL | |
| f476 | char(1) | YES | | NULL | |
| f477 | char(1) | YES | | NULL | |
| f478 | char(1) | YES | | NULL | |
| f479 | char(1) | YES | | NULL | |
| f480 | char(1) | YES | | NULL | |
| f481 | char(1) | YES | | NULL | |
| f482 | char(1) | YES | | NULL | |
| f483 | char(1) | YES | | NULL | |
| f484 | char(1) | YES | | NULL | |
| f485 | c
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-438829/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- postgresql單個表可以有多少欄位SQL
- mysql表操作(alter)/mysql欄位型別MySql型別
- MySQL 更新同一個表不同欄位MySql
- 5_MySQL 表的欄位約束MySql
- mysql修改表欄位學習筆記MySql筆記
- MySQL 更新一個表裡的欄位等於另一個表某欄位的值MySql
- mysql建立表的時候對欄位和表新增COMMENTMySql
- 表單欄位
- MySQL：查詢欄位數量多少對查詢效率的影響MySql
- MySQL 欄位約束MySql
- MySQL8.0大表秒加欄位，是真的嗎？MySql
- Mysql多欄位大表的幾種優化方法MySql優化
- MySQL 欄位擷取拼接MySql
- MySQL 大欄位問題MySql
- MySQL-刪除欄位MySql
- mysql資料表按照某個欄位分類輸出MySql
- (原創)odoo17下 integer型別欄位格式化控制Odoo型別
- MySQL欄位新增註釋，但不改變欄位的型別MySql型別
- mySql刪除多個表 刪除多個欄位的SQLMySql
- MySQL 5.7使用pt-online-schema-change對大表加欄位MySql
- [升級需要用到的] mysql更新表 增加、刪除、修改表欄位MySql
- MySQL-建立計算欄位MySql
- MySQL欄位型別最全解析MySql型別
- MySQL欄位的取值範圍MySql
- MySQL中修改一個資料庫下包含有某個相同欄位的所有表的欄位長度MySql資料庫
- 鮮為人知的HTTP協議頭欄位詳解大全「原創」HTTP協議
- MySQL如何檢視新增修改表以及欄位註釋資訊MySql
- MyBatis實現MySQL表欄位及結構的自動增刪MyBatisMySql
- 查詢mysql某張表中的所有資料（欄位）型別MySql型別
- 查詢資料庫表及表欄位資料庫
- MySQL 中 JSON 欄位的使用技巧MySqlJSON
- MySQL中JSON欄位的使用技巧MySqlJSON
- SQLServer2012刪除表欄位SQLServer
- oracle 修改表欄位的長度Oracle
- 共有的表單欄位屬性
- mysql資料表插入資料後，獲取自增欄位值的方法MySql
- mysql資料庫新增和修改欄位MySql資料庫
- mysql5.6生成排序欄位MySql排序
- 要慎用mysql的enum欄位的原因MySql