Simple use of MySQL stored procedure

First create a students table The SQL script is as follows: create table students( id int primary key auto_increment, age int, name varchar(20), city varchar(20) ) character set utf8; insert into students values(null, 22, 'lisa', 'Hangzhou'); insert into students values(null, 16, 'rock', 'Shanghai'); insert into students values ...

Posted on Wed, 01 Apr 2020 22:17:06 -0400 by Andre_Ng

Play MYSQL database basic skills

I sorted out some sql statements for beginners, and customized the basic skills necessary for playing mysql database. It is very suitable for beginners to learn! Student list create table student_info ( id int unsigned auto_increment primary key, studentname varchar(10), gender enum('male','female') ); insert in ...

Posted on Wed, 01 Apr 2020 22:06:18 -0400 by billabong0202

When MYSQL designs a table, it needs two TIMESTAMP fields

Sometimes, the database table has such a requirement, which requires a record creation time and a record modification time.  The ideal design is that the initial value of the update time is the same as the creation time: CREATE TABLE `test_table` (   `id` INT( 10 ) NOT NULL,   `create_time` TIMESTAMP NOT NULL DEF ...

Posted on Wed, 01 Apr 2020 21:40:41 -0400 by vboyz

[ShardingSphere] 1. Mysql database master-slave setup

mysql 5.7 installation This is a series of articles ShardingSphere The first article in this article is about how to build a master for Mysql.The setup environment is centos 7.7 and the database version is 5.7.Three virtual machines are needed, one master and two slaves. Readers can create virtual machines on their own computers, or they can b ...

Posted on Wed, 01 Apr 2020 15:39:19 -0400 by surfnjunkie

C × / AutoCad 2018 / ObjectARX / redevelopment add delete entity tool function (4)

1. Add delete entity It is very easy to add and delete entities in the secondary development of C ා ObjectARX. The main codes are as follows: Add entity: objId = btr.AppendEntity(entity); trans.AddNewlyCreatedDBObject(entity, true); Delete entity: entity.Erase(true); 2. Basic process In the code YunyouXueYuan namespace, add the Tools class. Thi ...

Posted on Wed, 01 Apr 2020 14:05:38 -0400 by hmogan

Installing oracle 11.2.0.4 under Docker

Note: https://github.com/sunrainwater/oracle-11g.git There is a complete installation code on Clone git code and generate image Direct execution: docker run -it –privileged –name oracle11g -p 1521:1521 -v /data:/install oracle-11g-scripts (no bash will be added to the last side, otherwise it will not be executed au ...

Posted on Wed, 01 Apr 2020 10:00:31 -0400 by ramonekalsaw

JFinal DB.tx() transaction rollback and lambda expression application

JFinal DB.tx() transaction rollback In order to operate multiple data to the database, transactions are needed. There are encapsulated transaction applications in JFinal Writing: Db.tx(new IAtom(){   @Override   public boolean run() throw SQLException{   // Write the operation to be performed and the operation result here result by boole ...

Posted on Wed, 01 Apr 2020 01:30:32 -0400 by haynest

Mysql multi instance installation and configuration

What is multi instance In short, multiple instances of MySQL are to open multiple different server ports on one server at the same time and run multiple MySQL service processes at the same time. These service processes provide services by listening to different service ports on different socket s. Two different mult ...

Posted on Tue, 31 Mar 2020 23:32:53 -0400 by FrankA

Install mysql and mysql common commands under Mac OS

Using brew to install mysql brew install mysql After the installation is successful, use the following command to start / shut down the service brew services start mysql brew services stop mysql Set up a soft connection for mysql.bin ln -s /usr/local/Cellar/mysql/5.7.21/bin/mysql /usr/bin Enter mysql ...

Posted on Tue, 31 Mar 2020 22:21:20 -0400 by Dvector

oracle Expdp and Impdp import and export database

The basic import and export statements are //Import / export database under specified user and instance orcl impdp/expdp user/pwd@orcl directory=DATA_PUMP_DIR Data ﹣ pump ﹣ dir is the default export path of oracle database files. It is generally the / admin / orcl (instance name) / dpdump directory under the orac ...

Posted on Tue, 31 Mar 2020 19:00:36 -0400 by vince251