Styjun

How to make all magic-casting innate, but still rare?

What are the mechanical differences between Adapt and Monstrosity?

Having some issue with notation in a Hilbert space

How to know whether to write accidentals as sharps or flats?

How could I create a situation in which a PC has to make a saving throw or be forced to pet a dog?

What could be the physiological mechanism for a biological Geiger counter?

Print the phrase "And she said, 'But that's his.'" using only the alphabet

Should I email my professor to clear up a (possibly very irrelevant) awkward misunderstanding?

How to sort human readable size

Interview was just a one hour panel. Got an offer the next day; do I accept or is this a red flag?

How can this shape perfectly cover a cube?

How can I maintain game balance while allowing my player to craft genuinely useful items?

How "fast" does astronomical events happen?

Can you cover a cube with copies of this shape?

How to make a villain when your PCs are villains?

What is the context for Napoleon's quote "[the Austrians] did not know the value of five minutes"?

What is this plant I saw for sale at a Romanian farmer's market?

Catching a robber on one line

Is my research statement supposed to lead to papers in top journals?

Time at 1G acceleration to travel 100000 light years

How did Avada Kedavra get its name?

Does knowing the surface area of all faces uniquely determine a tetrahedron?

Is it common to delay the start date of a postdoc?

On George Box, Galit Shmueli and the scientific method?

How to concat/join first cell with the cells beneath it and then insert them on the first column?

How to find all the tables in MySQL with specific column names in them?how to implement constraint in table such that inserted values do not repeat for group of rows onlyUpdate only one column (next column) if previous column is emptyHow to insert values from into specific column in already available table using Java and MySQLHow to update table data using group by in mysqlCopy From One Table To Another Specific Cols And VariablesLOAD DATA INFILE, skipping first column in tableHow to loop through rows and columns in a DatagridView to insert their values in a mysql tableHow storing array values in different columns of table using phpSQL for Joining tables after concatination

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

it's my first time here. I hope you can understand my problem.
Okay. I have a table with null values and I need to concatenate cells and insert them to the first column.

here is the table

col1 | col2 | col3
null | Section 001| null
null | 001 | abc
null | a | null
null | Section 002| null
null | 001 | null

here's how the table should look like after

Note: col2 has section numbers. col1 must increment as col2.

Note: value before the section number is constant which is "991-01".

 col1 | col2 | col3
991-01-001 | Section 001| null
991-01-001-001| 001 | abc
991-01-a | a | null
991-01-002 | Section 002| null
991-01-002-001| 001 | null

Thank you very much!

mysql substring mysql-workbench concat

share|improve this question

edited Mar 28 at 2:18

Alina

asked Mar 25 at 3:14

AlinaAlina

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're going to have to provide a lot more information. Why do the first two rows get concatenated, but the third row with a in doesn't, but then the last two rows do? What's the logic here? Is it only two consecutive rows that are concatenated, or more? Where does it stop?
  
  – fubar
  Mar 28 at 2:37
  

  
  
  
  

add a comment | 

0

it's my first time here. I hope you can understand my problem.
Okay. I have a table with null values and I need to concatenate cells and insert them to the first column.

here is the table

col1 | col2 | col3
null | Section 001| null
null | 001 | abc
null | a | null
null | Section 002| null
null | 001 | null

here's how the table should look like after

Note: col2 has section numbers. col1 must increment as col2.

Note: value before the section number is constant which is "991-01".

 col1 | col2 | col3
991-01-001 | Section 001| null
991-01-001-001| 001 | abc
991-01-a | a | null
991-01-002 | Section 002| null
991-01-002-001| 001 | null

Thank you very much!

mysql substring mysql-workbench concat

share|improve this question

edited Mar 28 at 2:18

Alina

asked Mar 25 at 3:14

AlinaAlina

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You're going to have to provide a lot more information. Why do the first two rows get concatenated, but the third row with a in doesn't, but then the last two rows do? What's the logic here? Is it only two consecutive rows that are concatenated, or more? Where does it stop?
  
  – fubar
  Mar 28 at 2:37
  

  
  
  
  

add a comment | 

it's my first time here. I hope you can understand my problem.
Okay. I have a table with null values and I need to concatenate cells and insert them to the first column.

here is the table

col1 | col2 | col3
null | Section 001| null
null | 001 | abc
null | a | null
null | Section 002| null
null | 001 | null

here's how the table should look like after

Note: col2 has section numbers. col1 must increment as col2.

Note: value before the section number is constant which is "991-01".

 col1 | col2 | col3
991-01-001 | Section 001| null
991-01-001-001| 001 | abc
991-01-a | a | null
991-01-002 | Section 002| null
991-01-002-001| 001 | null

Thank you very much!

mysql substring mysql-workbench concat

share|improve this question

edited Mar 28 at 2:18

Alina

asked Mar 25 at 3:14

AlinaAlina

12

col1 | col2 | col3
null | Section 001| null
null | 001 | abc
null | a | null
null | Section 002| null
null | 001 | null

 col1 | col2 | col3
991-01-001 | Section 001| null
991-01-001-001| 001 | abc
991-01-a | a | null
991-01-002 | Section 002| null
991-01-002-001| 001 | null

share|improve this question

edited Mar 28 at 2:18

Alina

asked Mar 25 at 3:14

AlinaAlina

12

share|improve this question

edited Mar 28 at 2:18

Alina

asked Mar 25 at 3:14

AlinaAlina

12

asked Mar 25 at 3:14

AlinaAlina

12

asked Mar 25 at 3:14

AlinaAlina

12