Database Experiment - Triggers and Database Security

📧 Triggers and database security Tip: The general content of this article: This experiment is from topics 7 to 10 of "Database Principles and Technologies" of Tsinghua University Press. 2. P396 on-line experimental questions 8. 3. P396 computer experiment questions 9 topics. Preface 😁 Again, the old saying goes: the basic prin ...

Posted by qazwsx on Wed, 04 May 2022 20:06:17 +0300

Record the formulation and implementation of an online Mysql database migration plan

foreword The system has been in operation for many years. The database server has also been running for many years, and its performance is relatively old. The capacity of the SSD hard disk is only 250G. Under various demands, the disk of the current server is about to be insufficient. Therefore, the migration of this database was started. nee ...

Posted by Myke on Wed, 04 May 2022 14:57:37 +0300

JDBC Programming: Advanced JDBC Programming

transaction processing Bulk update Returns the automatic primary key DAO 1. Transaction processing What are things? Transaction: The mechanism in the database to ensure the reliability of transactions. JDBC supports the concept of transactions in the database, and in JDBC, transactions are automatically committed by default. There are two wa ...

Posted by pabs1983 on Wed, 04 May 2022 12:30:43 +0300

Database Experiment 6 stored procedure

Database and table building view the database sentence show datebases; -- View all databases effect [take mine as an example, the following are] mysql> show databases; ±-------------------+ | Database | ±-------------------+ | information_schema | | mysql | | performance_schema | | sqlfortextbook | | studb | | sys | ±------------- ...

Posted by izzy on Wed, 04 May 2022 09:52:20 +0300

May 3, 2022 [crazy God talking about Java] the latest tutorial of MySQL is easy to understand 2

2. Operation database 2.1 operation database 2.2 column type of database numerical value tinyint very small data 1 bytesmallint smaller data 2 bytesmediumint medium size 3 bytesint standard integer 4 bytesbigint larger datafloat floating point number 4 bytesdouble floating point number 8 bytesFinancial calculation of floating point num ...

Posted by grumpy on Tue, 03 May 2022 19:40:00 +0300

[MySQL notes] multi table query

Multi table query, also known as association query, refers to two or more tables completing the query operation together catalogue Prerequisites for multi table query Basic syntax of multi table query Classification of multi table query Equivalent connection and non equivalent connection Self connected and non self connected Internal con ...

Posted by tanita on Tue, 03 May 2022 11:50:59 +0300

JDBC connection database

1, What is JDBC When it comes to JDBC, we should first think of the 13 specifications in Java. One of them is JDBC. What is it and what is its use? Let's take a look at Baidu Encyclopedia first In short, it is the method of connecting the database with Java, but we all know that the Java language is developed and maintained by Oracle company, ...

Posted by tito on Mon, 02 May 2022 11:21:35 +0300

[collection not recommended] Redis learning notes

Redis cache database foundation summary Redis, remote dictionary service. What can you do? Data persistence: RDB, OF High efficiency, cache Publish subscribe system Map information analysis Timer, page views ... characteristic Diverse data types Persistence affair colony ... Things needed in learning Redis official website: http ...

Posted by Studio381 on Sun, 01 May 2022 22:29:16 +0300

Transaction opening, commit and rollback of MySQL database

A transaction is a user-defined sequence of database operations. These operations are either done or not done at all, and are an inseparable unit of work. Based on the atomicity, consistency, isolation and persistence characteristics of transactions, related data operations can be defined into a transaction. If no exception occurs during the ...

Posted by wblati on Sat, 30 Apr 2022 23:02:23 +0300

Basic syntax of MySQL database

Basic operation of MySQL database 1. Creation of database 1.1 create database Create database create database <Database name>   -- stay sql Statements are not case sensitive Use database use <Database name> Delete database drop database  <Database name> view the database show databases <Database name> 1.2 crea ...

Posted by IG88 on Sat, 30 Apr 2022 18:54:06 +0300