Posts by Rodrigo • 41 points
10 posts
-
0
votes0
answers47
viewsQ: Absurd difference in WHERE without BINARY conversion
I implemented an INDEX in the "Name" column, which is varchar Binary (latin1_binary). This query takes about 1.5 seconds to execute: SELECT Nome FROM contas WHERE IP='255.255.255.255' AND Nome !=…
-
1
votes0
answers30
viewsQ: Accelerate selection by varchar - Mariadb 10
I have an Innodb table with 105 columns and about 300,000 rows. There is a varchar(24) where the username is stored. When I execute queries like these: SELECT * FROM users WHERE BINARY…
-
0
votes1
answer300
viewsQ: Centos 7 problem (libstdc++)
/lib/libstdc++.so.6: version `GLIBCXX_3.4.20' not found I am having this error while trying to run an application on Centos 7.4 x86_64. My attempts (based on what I found researching): yum install…
-
0
votes1
answer218
viewsA: Google Maps does not load (php include)
Problem solved. Was not specified width and height in pixels in div where the map is loaded.
-
0
votes1
answer218
viewsQ: Google Maps does not load (php include)
The map worked normally on a separate page, but when included with the PHP include function it simply doesn’t work, it loads nothing. I already checked the file paths and are correct, Javascript…
-
0
votes0
answers70
viewsQ: URL friendly + GET on the same link
I need a rewrite rule (.htaccess) that enables user-friendly URL and normal GET on the same link, example: meusite.com/teste?t=0&t2=1 That would be the same as:…
-
0
votes2
answers54
viewsA: Mysql - Multi Selects in a query
Solved. SELECT *, (SELECT COUNT(*) FROM contas WHERE Clan=1) AS Membros FROM clans WHERE ID=1;
-
1
votes2
answers54
viewsQ: Mysql - Multi Selects in a query
I need to get all columns of a table and more a custom column in the same query, I tried this way: SELECT (SELECT * FROM clans WHERE ID=1), (SELECT COUNT(*) FROM contas WHERE Clan=1) AS Membros; You…
-
-1
votes1
answer57
viewsA: Mysql Connector/C error
Problem solved. I removed the command lines in Project -> Build Options -> Compiler Settings -> Other Compiler options.
-
2
votes1
answer57
viewsQ: Mysql Connector/C error
I’m having a C problem, while trying to include Mysql bookstore gave some strange errors that I didn’t find anywhere. I downloaded the bookstore on official website for Win32-x86 (ZIP) and installed…