Posts by Vinicius Sousa • 31 points

• 1

  votes

  4

  answers

  1444

  views

  A: Excel transpose row to column and preserves columns and replicate them in row

  I created the code below by the example you gave. Change the Worksheets(1) and Worksheets(2) according to the worksheet with the origin and the worksheet that will serve as the destination. Public…

  sql excel vba csv

  answered 7 years, 6 months ago Vinicius Sousa 31

• 1

  votes

  5

  answers

  325

  views

  A: Php View Columns

  I think it is more efficient and simple if executed by mysql $query = "SELECT id, A, B FROM table WHERE CHAR_LENGTH(B) >=8"; $recordset = mysqli_query($query, $link);…

  php mysql echo

  answered 7 years, 8 months ago Vinicius Sousa 31

• 1

  votes

  1

  answer

  235

  views

  A: Grab the latest message from a conversation (GROUP BY)

  I would make a inner join with a sub query: Select a.* From cp_mensagem a Join ( SELECT id_projeto, id_freelancer, max(cp_mensagem.dh_envio) as dh_envio FROM cp_mensagem WHERE id_pessoa = 6 AND…

  mysql query group-by order-by

  answered 10 years, 7 months ago Vinicius Sousa 31