Posts by Igor gomes • 13 points
3 posts
-
0
votes1
answer121
viewsQ: Column with utf-8 character error
When executing: SELECT campus_nome FROM cursosprounine where campus_nome like ('%?%')group by campus_nome; to check the character error, I found a code that taught me to convert the column: UPDATE…
-
0
votes1
answer1335
viewsQ: Error Code: 1062. Duplicate entry '2' for key 'PRIMARY'
I am trying to update the local table with the data from the cursoProunine table with the following command : Insert into local (idlocal, Uf, city) SELECT idlocal, uf_search, city_search FROM…
-
0
votes0
answers47
viewsQ: Error in creating FK
Operation failed: There was an error while Applying the SQL script to the database. Executing: ALTER TABLE prouni.ies ADD INDEX local_idx (local ASC) VISIBLE; ; ALTER TABLE prouni.ies ADD CONSTRAINT…