Posts by Rafael LGC • 51 points
4 posts
-
1
votes2
answers92
viewsA: Index creation in the table
I suggest normalizing this table and in the tables that appear create the indexes only for the fields that will be used as a condition in the queries.
mysqlanswered Rafael LGC 51 -
0
votes1
answer531
viewsA: Deploy applications with Mysql
Does not connect because your database was not created, Mysql was installed but it did not create your database because there is an error in the . bat file on the line: "mysql -u root -p 3308 -h…
mysqlanswered Rafael LGC 51 -
0
votes3
answers754
viewsA: How to update a DIV with PHP
It is not possible, for this you need a client-side language like javascript. If you only use PHP you can build the updated page and send the whole page to the client again.
-
1
votes2
answers882
viewsA: Subselect in the same column
SELECT u.idUnidadeOrganica, u.NmUnidadeOrganica, u.idUOSuperior, u2.NmUnidadeOrganica FROM unidadeorganica AS u LEFT JOIN unidadeorganica AS u2 ON u.idUnidadeOrganica = u2.idUOSuperior;…