DJames23的博客

项目中需要动态增加和删除字段，并上传对应的数据，以下是代码记录1.动态增加、删除字段mapper.xml <!--修改表结构，增加列--> <update id="AlterTableAddField"> ALTER TABLE population_info ADD (${columnName} VARCHAR(255) NOT NULL DEFAULT '0') </update> <!--修改表结构，删除

参考博客：SQL注入详解

参考博客：Ubuntu16.04上安装MySQL（详细过程）$ mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 6Server version: 5.7.33-0ubuntu0.16.04.1 (Ubuntu)Copyright (c) 2000, 2021, Oracle and/or its affili

https://dev.mysql.com/downloads/connector/j/

在navicat中运行函数时报错，报错信息如下：[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)参考博客：怎么解决执行MySQL函数时

1.新建表并插入值CREATE TABLE [dbo].[test2]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [nchar](10) NULL, [age] [int] NULL)insert into [dbo].[test] (name,age) values ('张tt',16)2.在一张表中添加字段ALTER TABLE [dbo].[土地规划Features] ADD [土地使用权人] [varchar](32) NULL,

参考博客：sqlserver查询数据的所有表名和行数1.查看所有表的行数SELECT a.name, b.rowsFROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.idWHERE (a.type = 'u') AND (b.indid IN (0, 1))ORDER BY a.name,b.rows DESC查询结果：2.查看所有表名select name from sysobjects where xtype='u

参考博客：配置SQLServer，允许远程连接

参考博客：sql server 2012导出mdb文件或者.accdb文件扩展名