Mbatis select update delete insert tag attribute set

<select id="selectUser" //Method corresponding to PersonMapper.java interface parameterType="int" //Input parameter format resultType="hashmap" //Return data type. When multiple parameters are returned, resultMap is recommended. resultMap="userResultMap" //The data type returned is equivalent to encapsulating resultT ...

Posted by eheia on Tue, 19 Mar 2019 03:15:26 -0700

sys.master_files still have record problems after SQL Server removes transaction logs

After removing the transaction log file in SQL Server, when checking with sys.master_files, it is found that the corresponding transaction log file record information still exists in sys.master_files, except that the state_desc is OFFLINE. It will take some time for this record to disappear from the system view.   DECLARE @db_name NVARCHAR(32) ...

Posted by uatec on Tue, 19 Mar 2019 01:54:27 -0700

Questions about Left Join to Inner Join in SQL

conclusion From the following test results, it is easy to see that the left-related query statement will be transformed into an internal correlation as long as there is a WHERE filter condition. 1. Creating tables Demonstrate the use of random creation of two tables --Class table CREATE TABLE T_CLASS( class_id NUMBER not null, class_name VA ...

Posted by cyronuts on Mon, 18 Mar 2019 20:36:26 -0700

Using Data Lake Analytics + OSS to analyze TPC-H datasets in CSV format

Introduction to Data Lake Analytics (DLA) For more reading about the concept of Data Lake, you can refer to:https://en.wikipedia.org/wiki/Data_lake And AWS and Azure's interpretation of Data Lake:https://amazonaws-china.com/big-data/datalakes-and-analytics/what-is-a-data-lake/https://azure.microsoft.com/en-us/solutions/data-lake/ Finally, Al ...

Posted by crazydip on Mon, 11 Mar 2019 01:51:25 -0700

Query table A and table B has records at the same time, table A exists and table B does not have records, table B exists and table A does not have records.

1. problem Query table A and table B has records at the same time, table A exists and table B does not have records, table B exists and table A does not have records. As shown above, where: Area A is a collection of old tables and new tables. The C region is a collection of new tables and old tables. Area B is a common set of old an ...

Posted by php_gromnie on Thu, 14 Feb 2019 17:06:18 -0800

Powershell 5.1 scripted configuration Windows 2016 & SQL Server 2016 domain-Free Always On AG

Environment: Virtual Machine Windows Server 2016 (powershell 5.1) + SQL Server 2016 CTP3 Basically using Powershell script configuration. Here, when creating certificates and endpoints, we use SQL commands. In fact, PS has related commands to complete. This script is just a personal whim to try to script the way to configure AG, are the basic ...

Posted by ecko on Thu, 14 Feb 2019 01:36:18 -0800

Using reflection to implement sql query of mysql database to return List<E> generic (persistent) objects

Using reflection to realize sql query and get persistent objects The Title can't think of simple words. If you want to find out the relevant information, you should first see if the method structure is in line with your appetite. public static <E> List<E> getObjectBySql(String sql,E e) { List<E> list = new ArrayList ...

Posted by ckuipers on Wed, 13 Feb 2019 20:54:18 -0800

In python mysql, you cannot select some values of the same table in the same sql statement, and then update the table.

Example: First, create a new table and insert values: DROP TABLE IF EXISTS table_score_one; CREATE TABLE table_score_one ( id INT (10) NOT NULL PRIMARY KEY auto_increment, student_no VARCHAR (10) NOT NULL, student_name VARCHAR (10) NOT NULL, class_no VARCHAR (10) NOT NULL, class_name VARCHAR (10) NOT NULL, score IN ...

Posted by webmaster1 on Wed, 13 Feb 2019 04:48:19 -0800

Learning for Application - Excel Connecting Oracle to Generate iKB Report - Part 2 (Excel Daily Automated Data Conversion and User Interface)

Take the last part. Staying up late may hurt, but it's surprisingly efficient. Originally, it can be very happy to do one thing without distraction. This Excel Daily will be a powerful supplement to my iKB system. iKB system is similar to business transaction system for me to carry out daily knowledge base management; Excel Daily also allows ...

Posted by Zanne on Wed, 13 Feb 2019 02:42:18 -0800

Accessing MS SQL Server 2005 database (including C test source) using FreeTDS under Linux

(1) Installing freeTDS FreeTDS provides an open source client of TDS protocol for Linux system. Because MS SQL and Sybase use the TDS protocol, they can connect MS SQL with FreeTDS in Linux.Official website: http://www.freetds.orgDownload: wget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgzInstallation:[root@vm01 ~]# ta ...

Posted by ypkumar on Wed, 13 Feb 2019 02:18:20 -0800