Http://www.cnblogs.com/hongten/p/java_poi_excel.htmlThis blog is an introduction to the POI technology in Java to read Excel data and then save it to MySQL data.You can also read and import excel in: Java's POI technology to learn how to write Excel
MySQL Database basics
Install MySQL
[email protected] ~]# yum install MySQL mysql-server mysql-devel2. Start MySQL and set the boot from start[[Email protected] ~]# service mysqld start/stop/restart/status #启动/shutdown/restart/status
1. DescriptionWhen it comes to using data, we need a lot of databases, and we want to use time to make table names to differentiate. However, MySQL does not support the use of variable names for table names or column names in stored procedures.For
Introduced: mysql traditional master-slave replication is asynchronous replication mode, the master server to send Binlog to the slave server, it is considered to be completed synchronously. MySQL semi-synchronous replication mode ensures that the
There was a problem when the data source configuration was added with the Encoding conversion format:The reference to entity "characterencoding" must end with the '; ' delimiterThis error is the problem of setting the URL of the data source link in
Compile and install MySQL1 Find out if the system has MYQL installedRpm-q MySQL Mysql-server1.1 If it is installed. Just deletesudo yum-y remove MySQL mysql-serversudo rm-rf/etc/my.cnf2 Installation Dependenciessudo yum install ncurses-devel-ysudo
Display database:show databases;Use database (Connect database to switch database):use+ database name;Show a table in a database:show tables;Creating database: Createdatabase+ database name;To create a table:CREATE TABLE Student (ID int (4) primary
1. Create a new userLog in to MySQL@>mysql-u root-p@> PasswordCreate usermysql> INSERT INTO Mysql.user (Host,user,password) VALUES (' localhost ', ' JEECN ', Password (' JEECN '));Refresh System Permissions TableMysql>flush privileges;This creates a
Many people have the database design paradigm as the database table structure of the "bible", that as long as the requirements of this paradigm design, you can make the design of the table structure is sufficient to optimize, not only to ensure
When using the MySQL database, the new connection will be reported 2003-can ' t connect to server on ' localhost ' (10038) error, the main reason is that the MySQL service did not start up, but into: computer--management--services, Unable to find
Add userInsert into Mysql.user (Host,user,password) VALUES ("%", "Shenen", Password ("123456"));Add all PermissionsGrant all privileges the fgame.* to ' shenen222 ' @ ' percent ' identified by ' 123456 ';Add query permissions to a specific
First, mathematical functionsABS (x) returns the absolute value of XBIN (x) returns the binary of X (Oct returns octal, HEX returns hex)CEILING (x) returns the smallest integer value greater than XEXP (x) return value E (base of natural logarithm) x
8.2.2 creating users and empowering them as MySQL administrators, the most common task is to maintain user information--adding and removing users and managing their permissions in MySQL. Manage user permissions by using the GRANT and REVOKE commands
1, unzip, and put the extracted folder in the appropriate location2, configure the environment variable path, add the MySQL folder Bin directory for example: C:\Program files\mysql\mysql-5.6.25\ Bin "mysql-5.6.25" is my extracted folder, I changed
The formula is as follows, Unit meter: 1th Latitude: lng1 lat1 2nd latitude and Longitude: lng2 lat2round (6378.138*2*asin (Pow ((sqrt () LAT1*PI (180)/2), 2) + Cos (LAT1*PI ()/180) *cos (Lat2*pi ()/180) *pow (Sin ((Lng1*pi ()/180-lng2*pi ()/180)/2),
Summarize: Utf8_unicode_ci and Utf8_general_ci have no real difference between Chinese and English.Utf8_general_ci proofreading speed is fast, but the accuracy is slightly worse.Utf8_unicode_ci accuracy is high, but the proofreading speed is
1. When exporting SQL files using PowerDesigner (with export steps):(1) First switch the database, for example, in MySQL:650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/DC/wKiom1VtaAeBwKdbAAHV7EfGPYo271.jpg "title=" 00001. PNG "alt="
Ways to query and delete duplicate recordsA1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere Peopleid in (select Peopleid from People GROUP by Peopleid have
Jdbc BASICS (3) Big text, binary data processing, and jdbc Data Processing
LOB (Large Objects)Divided:CLOBAndBLOBBig text and big binary data
CLOB: used to store large text
BLOB: used to store binary data, such as images, sounds, and binary
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service