Experimental reportexperimentRead data table 1-table 4 and consider whether it is reasonable to add constraints to each fieldWrite T-SQL statements, create tables and constraintsView information about creating tablesVerify data integrity by inserting data into the table and answer the appropriate questionsExperimental task 1Using T-SQL to compl ...
Posted by Exemption on Sat, 26 Mar 2022 22:05:12 +0300
On the perfect scheme of Redission to realize distributed lock and Lua script
In the previous article, I mentioned the redis distributed lock implementation and lua script related knowledge In some scenarios, multiple processes must monopolize and share resources in a mutually exclusive manner. At this time, distributed lockin ...
Posted by andreas on Sat, 26 Mar 2022 17:19:12 +0300
Modify database table
Modify table name:
alter table Old table name rename as New table name
Add table fields
alter table Table name add Field column properties
For example: alter table student age int(11)
Modify the fields of the table
alter table Table name modify Field column properties;
For example: ...
Posted by jyushinx on Sat, 26 Mar 2022 12:26:12 +0300
DMDSC principle: in one sentence, it can realize multiple instances to control a database; Each node of DSC is an instance, and the database exists in the shared disk. The effect of instance operation database on each node is equivalent. Therefore, the effect of instance operation database of multiple nodes is equivalent to that of one instance ...
Posted by mahakmx on Sat, 26 Mar 2022 07:48:44 +0300
This blog is a follow-up to (). After crawling the data back, I wanted to directly turn it into excel, which is simple and convenient, but when I thought about how we are also programmers and can't be lazy, I put a database on the virtual machine and wrote a blog 😃
1. First look at the system version, Centos 7 2. wget obtains the mysql insta ...
Posted by MrXander on Sat, 26 Mar 2022 07:20:38 +0300
There are 33 national standard attribute table excel files, and the database table needs to be built according to these standard attribute tables. The format of each excel is as follows:
For such heavy and basically brainless work, I choose Python to do it:
Posted by LiamOReilly on Sat, 26 Mar 2022 06:52:41 +0300
preface: This article learned from: https://www.bilibili.com/video/BV1NJ411J79W?p=38 Make this note to help deepen your impression and facilitate future review
1, Database driven
The concept of driver here is the same as that heard in ordinary times. For example, the sound card purchased in ordinary times cannot be used when the network ...
Posted by jakobdoppler on Sat, 26 Mar 2022 06:12:24 +0300
Source download http://www.byamd.xyz/hui-zong-1/
Python 2.7IDE Pycharm 5.0.3PyMySQL 0.7.6MySQL 5.7MySQL Workbench 6.3
If the database is temporarily stored in a third party, and the stored data does not want to be seen by the third-party database administrator, and the message involves privacy and can only be seen ...
Posted by satheshf12000 on Sat, 26 Mar 2022 04:59:26 +0300
Basic operation of MySQL database
I use MySQL database special software MySQL 5 seven Special software is still very easy to use. If you don't have MySQL 5 7. It doesn't matter. You can also use the built-in database operation software of windows, the shortcut key win + R, and then enter cmd in the dialog box to pop up a and MySQL 5 7 similar ...
Posted by kwong on Sat, 26 Mar 2022 02:23:14 +0300