I am an kangarooking, not my brother’s brother. An Internet small cochlea “gua” cow, sincerely share experience and technology dry goods, today’s content is dry goods in dry goods, dry in dry, like collection, later use of time to turn out to copy a copy of a gourd gourd. Follow me and make progress every day ❗ ❗ ❗

Put on a long line of ha ‘er

On second thought, I still want to stay in Shenzhen for a few more years. I still want to enjoy some things while I am young. So I finally built my own computer and made a big splash, fulfilling a childhood dream of owning a computer that could play any game (lol, excitement). Before buying it, Douyin had been recommending various CPUS, graphics cards and videos of assembling computers to me. It had been working well for a while, and Douyin began to recommend it to me — I was ecstatic before I bought a computer, and I played with my mobile phone while it was on after I bought a computer for a while. Hh, but tiktok’s guess is wrong, because I telecommute, I have plenty of time to play games (still in the excitement stage), I often and I recently they open black eating chicken, but I like ah, there is tie zi is eating chicken big guy, teach me. Then I want to take a double trip with my girlfriend recently, I don’t know when the discount, 199 feels a little expensive. All right, enough nonsense, let’s get to the point.

preface

Men can’t say fast, but sometimes they have to be fast. Today to introduce pig foot – column editing is a can make you crazy to improve the efficiency of the SAO operation. Whether it is programmers or other industry staff, skilled column editing operations, get twice the result with half the effort.

This article is suitable for people:

  • everyone

Not all editors can carry out column editing operations, in some specific tools, such as IT idea, Navicat, PLSQL, etc.. Other tools for column editing will be summarized at the end of this article.

How do I know if an editor can edit columns?

The easiest way is Alt + left click drag down, and you’ll know. Alt + left is the easiest way to do column editing. This is a description of the iron that you don’t understand, but it doesn’t matter, let’s move on to the next demonstration.

Column editing base operations

1. Select the same column

When the leader assigns you “artificial intelligence” work: “Small emperor, you come to make this vertical number to me in a line, each number comma separated ha.”

As follows:

100001
1000014
1000078
100053262
100113655
100122899
1002674
100285605
101974290
102082699
102282567
102286418
102299601
102338378
102520470
102632346
103373827A thousand numbers omitted here...Copy the code

The beginning of the workplace of the small emperor, without words into a busy nervous work, an hour later, the small emperor open a pair of eyes to find leadership, and account for the task to complete.

Let’s look at the column editing operation (select the same column) : Alt + left mouse button drag down, select the left side of the column, then backspace, and finally add a comma. It’s just a matter of seconds.

Of course, the data volume in this example is relatively small, but as the data volume increases, the advantages of using column editing become more obvious. Imagine if you use “AI” to add commas and backspaces one by one, if the data is very large, until tomorrow.

2. Select the same character

After a while, the leader asked xiao Di: “Have you backed up the files I copied to you before? Mine is lost.” The emperor scratched his head and said, “I forgot to back up. How about I make a copy of the one that was converted to a line and come back?” . Leader: “Good idea, do it, come on!” . Then the small emperor chi Chi, and a line of data back to a vertical. Finally came home from work the small emperor game do not want to touch, fell asleep.

Select any comma, CTRL + Shift + Alt + J to select all commas, and press Enter.

3. Place the cursor freely

Good small emperor’s story is over, we will not say nonsense below. Move the cursor anywhere: Alt + Shift + left mouse button

This operation applies to the case where the amount of data is not large and the content in the pre-selection is irregular.

4. Select characters of the same type

CTRL + Shift + Left/right arrow keys to select characters of the same type

Here said about the key is the keyboard up and down around the key, that is, to play qq speed direction key.

This operation applies to the situation where the cursor position is not aligned.

5. Set the cursor before and after the column

Operation: Press home (front) or End (back) on the keyboard to move the column cursor forward/back. It is the same as normal downward editing.

This works when you want the cursor to be set to the front or back.

6. Duplicate the same column

Action: Alt + left click to select a column, then CTRL + D

This works if you want to copy the left column to the right, just like normal row editing, CTRL + D copies the row.

Summary of basic operation

Here the basic operation of column editing is finished. As long as we know these basic operations and combine them in the actual work, no matter how complex the data is, there is basically no problem and the efficiency is great.

In actual combat

Practice is the only test of truth, and I’ll start with how a Java programmer uses column editing at work to solve a problem.

Let me tell you a little bit about my experience, column editing where I use it the most is in SQL writing.

Select * from mapper.xml; select * from mapper.xml; select * from mapper.xml; select * from mapper.xml;

  1. Replicate table structure;
  2. Alt + left mouse button, set the column cursor to the far left;
  3. CTRL + Shift + Direction right clickSelect the same character, then right-click again, and finally add a comma;
  4. shift + endSelect the extra part and pressbackspaceDelete the

Mybatis merges an Oracle database into a mapper. XML file. Merge oracle database into a mapper. XML file. Xx = t1.xx. Xx T1 and T2 are aliases for the same table, but this table has a large number of fields (over 30), so column editing is quick.

I won’t go into the details of the operation, but I will use the same column copy operation described above: select the column, then CTRL + D

This scenario is when you copy a table query from Navicat into an INSERT statement and want to insert another table with a similar or identical structure. Since the ID is incremented, the creation time may not be set and will be automatically obtained at insert time.

The key operations are as follows: Select CTRL + Shift + Alt + J for the same character and CTRL + Shift + Left and right arrow keys for the same character

Have you ever written an update statement with an if tag like this:

It’s really long and smelly, and if I remember correctly, automatic generators don’t generate this update statement.

Let’s use column editing to do it quickly:

conclusion

Learn column editor, speed up you and me. Once you’ve mastered the basics, complex data processing depends on the combination of these basic operations. We take a complex piece of data and we analyze the patterns, and we find the patterns and we edit the columns very quickly. Keep the iron away, or you won’t find it when you need it. Collect, collect, collect!!

Attached some tools with column editing function: Youdao Cloud Note markdown notes can be used, VScode, Notepad, Hbuilder, etc…

If you have any questions, see you in the comments section of the wechat official account “Mr. Kangaroo’s Inn”. If you think my sharing is helpful to you, or if you think I have some skills, support me as a budding writer. Like 👍 and follow ❤️ share 👥