mysql数据库支持多少个字段

mysql数据库支持多少个字段？sqlserver？oracle？

您好,之前同事测试过mysql一个表单最多支持120个字段左右，其他的数据库支持多少个字段您可以去百度。这个部分跟平台本身没有直接的关系。
另外,如果您的一个表单中的字段过多,结合某种特定的操作等可能会对性能这部分产生影响,请问您具体是什么需求??

回复 2# bess


    表单中有95个字段，点击“一键生成视图”会出现以下错误：

我删除了8个字段后，点击“一键生成视图”没有出现错误。不知道哪里出现错误？

您好，根据您前台的报错并没有看出什么来，请问您后台的有报错嘛？

回复 4# spiral


    图片就是后台报错。都不能生成视图，没有涉及前台。

在jsp页面红色的提示是前台报错信息，后台是指tomcat控制台，如下图

回复 6# spiral


    17:49:33,624  INFO AbstractDocStaticTblDAO:1060 - MY SQL: SELECT COUNT(*)  FROM
(SELECT d.* FROM TLK_借款表单 d WHERE 1 = 1 AND  d.AUTHOR ='11e1-bf66-7be83389-b
ae8-b33df3d0c98a') doc WHERE doc.DOMAINID ='11e1-bf33-9aa99d89-bae8-b33df3d0c98a
'
java.lang.Exception: org.hibernate.exception.DataException: Could not execute JD
BC batch update
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:131)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doCreate(AbstractDes
ignTimeProcessBean.java:40)
        at cn.myapps.core.dynaform.view.ejb.ViewProcessBean$$EnhancerByCGLIB$$c7
9d9dd.CGLIB$doCreate$18(<generated>)
        at cn.myapps.core.dynaform.view.ejb.ViewProcessBean$$EnhancerByCGLIB$$c7
9d9dd$$FastClassByCGLIB$$2abe5454.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.protection.util.WarpProcessFactory.intercept(WarpProcessFac
tory.java:272)
        at cn.myapps.core.dynaform.view.ejb.ViewProcessBean$$EnhancerByCGLIB$$c7
9d9dd.doCreate(<generated>)
        at cn.myapps.core.dynaform.form.ejb.BaseFormProcessBean.oneKeyCreateView
(BaseFormProcessBean.java:808)
        at cn.myapps.core.dynaform.form.ejb.FormProcessBean$$EnhancerByCGLIB$$d2
97341d.CGLIB$oneKeyCreateView$22(<generated>)
        at cn.myapps.core.dynaform.form.ejb.FormProcessBean$$EnhancerByCGLIB$$d2
97341d$$FastClassByCGLIB$$1b346fc6.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.protection.util.WarpProcessFactory.intercept(WarpProcessFac
tory.java:272)
        at cn.myapps.core.dynaform.form.ejb.FormProcessBean$$EnhancerByCGLIB$$d2
97341d.oneKeyCreateView(<generated>)
        at cn.myapps.core.dynaform.form.action.FormAction.doOnekeycreview(FormAc
tion.java:290)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:217)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:191)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:155)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java
:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:852)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:584)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
08)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch u
pdate
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDA
O.java:755)
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:129)
        ... 53 more
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for col
umn 'COLUMNXML' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2016)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1452)
        at sun.reflect.GeneratedMethodAccessor750.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at $java.sql.Wrapper$$EnhancerByProxool$$4069bfb2.executeBatch(<generate
d>)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 62 more
17:50:16,042  INFO LoginHelper:256 - Logout system: loginno=xqy, ip=192.168.116.
131
17:50:20,731  INFO Task:569 - ************ Execute Start *************
17:50:23,701  INFO AbstractDocStaticTblDAO:1254 - MY SQL: SELECT * FROM tlk_sche
dule WHERE item_isremaind is not null and TIMESTAMPDIFF(second,ITEM_remindtime,s
ysdate()) BETWEEN 0 and 60;
17:50:23,716  INFO Task:617 - ************ Execute End *************

存储视图列信息对应数据库中位置是select COLUMNXML from obpm.t_view
在mysql数据库中该列使用的是类型是text，它的长度是有上限的，所以存储过多的东西的时候会报错
请问您具体的业务是什么呢？  一个视图放80.90个列，并不符合一般的业务需求
所以建议您列比较多的情况下不要是使用”一键生成视图“，而是根据实际需求选择需要显示的列

回复 8# spiral

解决了。谢谢哦！

感谢楼主告知结果!