mysql 修改单列数据_将单列列表更改为2列表

mysql 修改单列数据

On the weekend, I copied a list of blog names and URLs into Excel. On the website that I copied it from, the list was in 2 columns, but it pasted into a single column in Excel. Having everything mixed together in one column wasn’t going to be very helpful. Here’s what I did to change single column list to 2 column table.

在周末，我将博客名称和URL列表复制到Excel中。 在我从中复制它的网站上，该列表位于2列中，但是粘贴到Excel中的一列中。 将所有内容混合在一列中不会很有帮助。 这是我将单列列表更改为2列表的操作。

添加标题和ID (Add Headings and IDs)

This screen shot shows the list, in a single column.

此屏幕快照在单个列中显示了列表。

I wanted the site names in one column, and the URLs in another. If I labeled all the site names as “a”, and the URLs as “b”, I’d be able to sort them into two groups.

我希望在一列中显示站点名称，而在另一列中显示URL。 如果我将所有站点名称标记为“ a”，将URL标记为“ b”，则可以将它们分为两组。

• First, I put a heading at the top of the list, and an “ID” heading for the column to the left.
  首先，我将标题放在列表的顶部，并在该列的左侧添加一个“ ID”标题。
• Then, I typed “a” and “b” as the IDs for the first two rows.
  然后，我键入“ a”和“ b”作为前两行的ID。
<