Posts by Bruno Henrique • 122 points
13 posts
-
-3
votes1
answer121
viewsA: Column with utf-8 character error
Try this: ALTER TABLE cursosprounine CHANGE COLUMN campus_nome campus_nome VARCHAR(500) CHARACTER SET utf8mb4
-
1
votes0
answers33
viewsQ: Is it possible to store the result of an ANALYZE TABLE or SHOW in Mysql in variables?
Good night, everybody, all right? I’m having a little silly doubt about the return of commands ANALYZE TABLE and SHOW in Mysql. I know that if I make a query using SELECT I can store the desired…
-
1
votes2
answers245
viewsA: I cannot declare a cursor in Mysql
Good afternoon. An example of the creation of a PROCEDURE with CURSOR, basically a cake recipe. Do not forget to always pay attention to the change of delimiter before the creation of any TRIGGER,…
-
1
votes1
answer72
viewsA: Create Product Pages - PHP + Mysql
The correct thing would be to make a single product page where the user clicks on the product and the information is dynamically loaded, according to the information in the bank. If you don’t have a…
-
0
votes1
answer103
viewsQ: mysqldump generating the same file with different size
Good morning, you guys. I’m having a bizarre problem using the mysqldump, I’ll try to explain as best I can. I have 4 Databases, and daily a dump is made from each base, generating different files,…
-
1
votes0
answers1886
viewsQ: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Good afternoon, you guys! I’m having a lot of headaches to connect my code to a file .dbf, and found no solution after running the internet for two days in a row... This is the code on PHP <?php…
-
0
votes1
answer63
viewsA: How to get all the sums of 'SUM'
I believe you want to add up the values this way: SELECT SUM(CASE WHEN (a==b 2 THEN 1 ELSE 0 END) + SUM(CASE WHEN (a==b 5 THEN 1 ELSE 0 END) + SUM(CASE WHEN (a==b 10 THEN 1 ELSE 0 END) /*Porem com…
-
1
votes1
answer55
viewsQ: How to know which columns were modified in an UPDATE using TRIGGER?
Good afternoon, everyone. I am creating a TRIGGER AFTER UPDATE in a table in the BD, and I need to know which columns were changed (regardless of the value that was placed), and put the column names…
-
0
votes2
answers51
viewsA: How to loop Mysql based on a query
I didn’t quite understand what you need to do with the loop, but you could use some CURSOR in a PROCEDURE, since you would need to go through the result of a query. About the event you can create…
-
0
votes0
answers146
viewsQ: How to correctly display an XML that has blank cells in PHP?
Good afternoon, everyone. I followed a video classroom how to display XML data in PHP, and everything worked out, the result was displayed correctly, but if a cell is empty it plays the value of the…
-
2
votes1
answer51
viewsQ: How to select and play values in the same column
Example: select 'a' as 'letras', 'b' as 'letras' I want to play the letter 'a' and the letter 'b' in the column 'letters', but with this code it returns 2 columns with the same name, but I want to…
-
0
votes1
answer995
viewsQ: How to use If with Insert in Mysql?
I have a variable x, and I want to check its value with an if, and if the value is above 10 (for example) I want to perform an Insert in a table, otherwise a select in it. It’s something relatively…
mysqlasked Bruno Henrique 122 -
1
votes2
answers4641
viewsQ: How to store a SELECT value in a MYSQL variable?
It’s something very simple but I can’t find the information I want, people! I saw once how to do it but it was very shallow, but I’ll explain what I want: I have a variable and I want it to receive…
mysqlasked Bruno Henrique 122