Programming VIP

Requirement: the exchange code of excel is imported into mysql, with a total of 30W pieces of data. Navicat has its own functions. It can directly import excel data into mysql. There are too many databases and manual operation is very troublesome. A script is written with python. Use pip to import xlrd,pymysql library. ...

As a part of ETL, sometimes you need to generate the Insert script of the data, and then copy the human flesh to another place for execution. Students who are familiar with SMSS all know that there is a task of generating scripts, which can generate database create scripts, and in fact can also produce data in tables. Automatic ETL can't even e ...

_Copyright Statement: This is an original article created by a blogger and may not be reproduced without the permission of the blogger. SQL Server series software is a relational database management system introduced by Microsoft.At a conference in San Francisco on April 16, 2014, Microsoft CEO Satia Nadela officially launched "SQL Ser ...

JDBC JDBC(Java Database Connectivity) Java database connection specification (a set of interfaces) provided by Sun company JDBC core class DriverManager create connection Connection connection class Statement execute sql statement ResultSet result set JDBC connection steps 1. Registration driver 2. ...

There are two methods to execute SQL statements in PDO:    1. exec() is used to process statements that do not return SQL results, such as insert update delete create, etc., but it will return the number of affected rows If you are executing an insert statement, you can use the lastinsertid() method to get t ...

When exporting, backing up and restoring Mysql database from the master database to the slave database, you need to pay attention to whether to enable GTID mode for the database. If you enable it, you should add the parameter -- set GTID purged = off to mysqldump data. See reprint for details: Here are the first 30 lines of a.sql exported with ...

In the absence of visualization tools to monitor database performance, common scripts come in handy. Here are a few scripts related to Oracle Performance for your reference. The following scripts have passed the Oracle 10g test, and Oracle 11g may need to be adjusted accordingly. 1. Find SQL statements with the most buffer \ ...

query public Cursor query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit, CancellationSignal cancellationSignal) //10 parameters //distinct: set to true, each row must have u ...

Functions in MySQL Functions in MySQL include character function, numeric operator and function, comparison operator and function, date time function, information function, aggregate function, encryption function, etc. 1. Character function //For example, when you need to output last name and first name togethe ...

Tools: CMD sqlplus Content: basic table operation, plsql programming (branch structure, loop, judgment, etc.) Account: scott preparation in advance Tips for using cmd Because the author uses sqlplus and enters in the cmd environment. It's not easy to edit the text in cmd environment, so I'll give you some tips. A ...