recent problems

Question 1 Vertical expansion of the display

In the daily working environment, sometimes it is necessary to expand the extended display up and down, but the default computer configuration is to expand left and right, as shown in the figure below.

At this time, open 'Desktop-> Right-click-> Display Settings-> Display (Rearrange Displays)', if you need to expand up and down, just press and hold "Display 2" in the above picture, and drag it directly to "Display 1 " above (or below), you can flexibly complete the expansion of any position on the screen, as shown in the figure below,

Through the "Identify" button, you can identify the corresponding display, as shown below,

Question 2 Insert a radio button in Excel

open 'file',

Select 'Options',

Click on 'Customize the Ribbon', check the 'Developer' checkbox and click 'OK',

Click 'Development Tools -> Insert -> Options Button' in the menu bar,

You can only add one option button at a time, to speed it up, right click on the first control after adding it, then select 'Copy -> Paste',

To edit or delete a control's default text, click the control and update the text as desired,

Question 3 PPT adjusted to 16:9

The previous PPT usually had an aspect ratio of 4:3. With the change of projection equipment, the aspect ratio of 16:9 has become popular in recent years. The aspect ratio of 16:9 is more contemporary and more suitable for human eyes. Information access to make your PPT more beautiful.

Click on 'Design -> Page Setup',

Set the slideshow size to 'Full Screen Display (16:9)', click OK to complete,

Question 4 PPT increase number

If you want to add a number to each page of the PPT, you can select 'Insert' -> 'Header and Footer' (or 'Slide Number'), check the 'Slide Number', and click 'Apply to All' , will add a number to each page of this document, otherwise only add a number to the current page,

Question 5 PPT number position

If you want to adjust the position of the PPT number, you can select 'View' -> 'Slide Master',

Drag the '#' in the lower right corner, which represents the number. After the adjustment is completed, you can change the position of the PPT number.

"Recent Problems Encountered"

Question 1 SVG file

Question 2 License Agreement

Question 3 The difference between x86 and x64

Question 4 The order of the branch committees in the party branch election report

Question 5 Confluence mind map plugin

"Recently Encountered Problems"

Question 1 SpringBoot prompts an error

Question 2 MyBatis prompts an error

Question 3 My document title says [compatibility mode]

Question 4 Confluence inserts static website

Question 5 MobaXterm exits full screen

"Recent Problems Encountered"

Problem 1 Read characters line by line

Question 2 BufferedWriter and FileWriter

Problem 3 log4j and console garbled characters

Question 4 Conversion between String, InputStream and Reader

Question 5 Java writes files

"Recent Problems Encountered"

Issue 1 lombok introduced but not available

Question 2 Eclipse opens the yaml file

Question 3 ArtifactID and GroupID of maven project

Question 4 Java prompts an error by connecting to SQL Server

Question 5 Java removes spaces

"Some Problems Encountered Recently"

Question 1 Windows enables and disables hibernation mode

Question 2 Notepad changes the background color of the interface

Question 3: The power of the Switch is 0, and the switch cannot be turned on after charging?

Question 4 SQL Server generates random numbers

Question 5 Oracle regular

"Some Problems Encountered Recently"

Issue 1 kb and KB

Question 2 The format displayed by the Java List element

Question 3 wget download https prompts authentication error

Question 4 When Oracle 19c is installed on cloud host rpm, it prompts an error that the IP is not recognized

Question 5 Install Oracle 19c on cloud host

"Some Problems Encountered Recently"

Question 1 Difference between comma, semicolon and comma

Question 2 Multi-layer title number

Question 3 The upper and lower lines of Word numbered documents are not aligned when carriage return and line feed

Question 4 Excel data deduplication

Question 5 Log in to Docker MySQL

"Some Problems Encountered Recently"

Question 1 Is /usr the system path?

Question 2 SQL Server deletes the index

Question 3 addresses exporting EXP-00091: Exporting questionable statistics.

Question 4 Delete a large number of inexplicable blanks that appear in Word

Question 5 Word setting read-only open

"Some Problems Encountered Recently"

Question 1 Conditional judgment of cell content in Excel

Question 2 Conversion of InputStream and BufferedReader in Java

Question 3 Excel is set to read-only

Question 4 The Chinese garbled characters written by log4j to the log

Question 5 Java reads Chinese garbled characters in files

"Some Problems Encountered Recently"

Question 1 The background color of Word is green, how to change it to colorless?

Question 2 There is a paragraph after Word wraps

Question 3 The text in the Word table is centered

Question 4 Prohibit editing crontab

Question 5 MySQL's global variables take effect

"Some Problems Encountered Recently"

Question 1 The shortcut keys for Eclipse formatting code are invalid

Question 2 Win10 virtual desktop

Question 3 The data in the table in DBeaver cannot be edited

Question 4 PLSQL Developer button recovery

Question 5 Chrome Performance Statistics

"Some Problems Encountered Recently"

Question 1 MySQL reports MySQL "ERROR 1046 (3D000): No database selected" update query

Question 2 mysqld starts the database

Question 3 How to delete the carriage return in Microsoft Office 2016?

How does the shape window of question 4 Visio open?

Question 5 How to open the document structure diagram of Microsoft Office 2016?

"A few problems encountered recently"

Question 1 Delete MySQL empty user

Problem 2 Cloud document multi-person editing and filtering chaos solution

Question 3 A possibility of MySQL database downtime

Question 4 Configuring automatic disk mounting

Question 5 MySQL exception:ERROR 1045 (28000): Unknown error 1045

"A few recent problems"

Question 1 VMWare is interrupted abnormally and cannot be started

Question 2 Word text box

Question 3 Excel options plus default values

Question 4 How to turn off the Linux screen saver in VMWare

Question 5 Conversion of decimal and hexadecimal in Oracle

"A few problems encountered recently"

Question 1 jxl export excel exception

Problem 2 MySQL login is slow

Question 3 The logic of the kill process in the script

Question 4 The word directory prompts "Error! Undefined bookmark"

Question 5 Invalid package adjustment in Oracle

"A few problems encountered recently"

Question 1 The display problem of DBeaver execution window

Question 2 The text field of MySQL is not enough

Question 3 'The table 'xxxxx' is full' error in MySQL

Question 4 @Controller and @RestController in SpringBoot

Question 5 MySQL retrieves global variables and session variables

"A few problems encountered recently"

Issue 1 switch prompts an error

Question 2 Date operation in MySQL

Question 3 table_owner of dba_synonyms

Question 4 Linux Timing Task

Question 5 SpringBoot prompts package error

"A few problems encountered recently"

Question 1 Linux password policy

Question 2 sudo authorization

Question 3 Specify configuration file when springboot runs

Question 4 The program references application.yml parameter values

Issue 5 jxl operation file compatibility

"A few problems encountered recently"

Question 1 Judgment in Shell

Question 2 A regular requirement

Question 3 xml file filter tag

Question 4 JSON Parsing

Question 5 JSON strings and JSON objects

"A few problems encountered recently"

Question 1 When interacting with MySQL in the program, this error is prompted, Column count doesn't match value count at row 1

Question 2 When using mysqldump to export and import data from the MySQL cluster environment, this error is prompted, @@GLOBAL.GTID_PURGED can only be set when

@@GLOBAL.GTID_EXECUTED is empty

Question 3 When exporting MySQL, what parameters are generally used?

"Some Problems Encountered Recently"

Question 1 Requirements for splitting strings by spaces

Question 2 MyBatis error, Invalid bound statement (not found)

Question 3 JDBC error, java.sql.SQLException: ORA-03115

Question 4 The difference between SID and SERVICE NAME used in the JDBC connection string

Question 5 CTAS of SQL Server

"Several technical problems encountered in daily work"

Question 1 PLSQL Developer Chinese display problem

Question 2 Installing PLSQL Developer on Windows 10

Question 3 PLSQL Developer login error ORA-12504

Question 4 The PLSQL Developer font in Windows 10 is displayed very small

Question 5 Create an Oracle user name containing special characters

Question 6 Execution 10053 did not generate trace

Recently updated articles:

"MySQL time partition case"

"Some problems caused by the undefined DATE type of the date field"

Why is Ronaldo the top scorer in world football history? "

"Introduction to Three Database Architectures"

"Reading Notes on Data Governance - Data Governance Roadmap Planning"

Article Categorization and Indexing:

"Classification and Indexing of 900 Articles on Official Account"