📝 SQL 建表语句生成 HTML 表单SQL CREATE TABLE to HTML Form
根据 CREATE TABLE 语句自动生成 HTML 表单：按字段类型选择输入控件（数字、日期、下拉、复选框、多行文本），带必填、最大长度和中文标签，可选原生 HTML 或 Bootstrap 5 样式并实时预览。Generate an HTML form from a CREATE TABLE statement: inputs are chosen by column type (number, date, select, checkbox, textarea) with required, maxlength and labels from comments, in plain HTML or Bootstrap 5, with a live preview.
预览Preview
使用说明与常见问题How-to & FAQ
「SQL 建表语句生成 HTML 表单」是什么？What is the SQL CREATE TABLE to HTML Form tool?
根据 CREATE TABLE 语句自动生成 HTML 表单：按字段类型选择输入控件（数字、日期、下拉、复选框、多行文本），带必填、最大长度和中文标签，可选原生 HTML 或 Bootstrap 5 样式并实时预览。Generate an HTML form from a CREATE TABLE statement: inputs are chosen by column type (number, date, select, checkbox, textarea) with required, maxlength and labels from comments, in plain HTML or Bootstrap 5, with a live preview.
如何使用「SQL 建表语句生成 HTML 表单」？How do I use the SQL CREATE TABLE to HTML Form?
粘贴 CREATE TABLE 语句，选择样式，下方生成表单代码并预览。自增主键和创建时间这类自动字段会被跳过；ENUM 生成下拉框，tinyint(1) 生成复选框，名称含 email/password 的字段使用对应输入类型；字段注释作为标签文字。Paste a CREATE TABLE statement and choose a style; the form code and a preview appear below. Auto fields such as auto-increment keys and created timestamps are skipped; ENUM becomes a select, tinyint(1) a checkbox, and columns named email/password get matching input types. Column comments become labels.
生成的表单能直接提交到数据库吗？Can the form post straight to the database?
不能。表单只负责收集数据，提交后仍需要后端程序校验（前端 required、maxlength 可以被绕过）并使用参数化查询写入数据库，防止 SQL 注入。No. The form only collects data; your back end must still validate it (front-end required/maxlength can be bypassed) and write it with parameterised queries to prevent SQL injection.
字段类型是怎么对应到输入框的？How are column types mapped to inputs?
整数和小数→number（按小数位设置 step），date→日期，datetime/timestamp→日期时间，time→时间，text/json→多行文本，enum/set→下拉框，tinyint(1)/bool/bit→复选框；字段名包含 email、password、phone、url 时使用对应的输入类型。Integers and decimals → number (step from scale), date → date, datetime/timestamp → datetime-local, time → time, text/json → textarea, enum/set → select, tinyint(1)/bool/bit → checkbox; names containing email, password, phone or url get those input types.
「SQL 建表语句生成 HTML 表单」免费吗？数据会上传吗？Is the SQL CREATE TABLE to HTML Form free? Is my data uploaded?
「SQL 建表语句生成 HTML 表单」完全免费，无需注册或安装，手机和电脑都能用；所有处理都在你的浏览器本地完成，输入的内容和文件不会上传到服务器。The SQL CREATE TABLE to HTML Form is completely free with no sign-up or install and works on phones and desktops; everything runs locally in your browser and nothing you enter is uploaded.