Posts by brucepc • 21 points
2 posts
-
0
votes2
answers248
viewsA: Merge two tables into a third table
You can just update one of the tables as the example below, of course after updating its structure. UPDATE docs INNER JOIN docs_1 ON docs_1.id=docs.id SET docs.teste2=docs_1.teste;…
-
2
votes2
answers194
viewsA: Table values being truncated
You must use point(.) and not comma(,) to separate the decimal, mysql does not use the Brazilian standard. http://sqlfiddle.com/#! 9/21d68c/2…