Posts by Ramos J Souza • 25 points
5 posts
-
1
votes2
answers106
viewsQ: SQL search between two tables with duplicate result
I have a View and a table. A View V_CUSTOMER with customer data, but does not have the same CPF/CNPJ as in the view, which is identified by the field V_CUSTOMER.CUSTOMER_ID that makes the…
-
-1
votes1
answer105
viewsQ: DELETE IN SQL WITH WHERE STATEMENT NO ID REQUIRED
I have ZIP table with a new OP field with DEL information to delete. When I perform the instruction: DELETE FROM cepdb.log_bairro where BAI_OPERACAO = 'del'; Returns: 2 Cannot delete or update a…
-
0
votes0
answers627
viewsQ: Query Mysql: Error Code: 2013. Lost Connection to Mysql server During query
I have a Mysql Query that only returns me Error Code: 2013. Lost connection to MySQL server during query. Follows the same: select log_logradouro.ufe_sg, log_localidade.LOC_NU,…
-
0
votes1
answer229
viewsQ: MYSQL - The used SELECT statements have a Different number of Columns
I have a Mail Query that returns a result that does not contain some data I need, like LOC_NU, LOC_NUM_SUB and MUN_NU. Follow the original NO these fields and no errors: select…
-
-1
votes1
answer65
viewsQ: Update between two tables with conditions
I have a question in my work regarding locating and replacing a certain field, updating it with a value of a search. I’ll give you an example: I have this table that has LOC_NUM_SUB and note in the…