How can I correctly insert accented words in MySQL? Example: if you try to insert "John" you are recording John.
MySQL is as Collation utf8-default collation
I get the input data "name" below:
<%@page contentType="text/html" pa...
I have the following functions:
Archive registra_conta.php:
if(isset($_POST['acao'])){
if($_POST['acao'] == "inserir"){
inserirConta();
}
if($_POST['acao'] == "alterar"){
alterarConta();
function selectIdConta($id){
$banco = ab...
When I try to access the data in MySQL via lambda ( EF ), Visual Studio returns the following error:
Method 'MySql.Data.Entity.EFMySqlCommand.set_DbConnection (Method.Data.Common.DbConnection) failed' when trying to access met...
I have a problem with a database that I use for testing where I have 1000 records and I have a website that pulls this data to be displayed. I'm using paging in my query this way
$read->FullRead("SELECT * FROM teste LIMIT $p , $qt_por_pg");...
I would like to list a field that is in the database in a list that is already created. When the user clicks on the "title" field he has to call a modal with some data from the database.
What happens, it even calls, only that of the first row, i...
I have an application in java (desktop) that does some operations on writes the logs to a table in MySql, I need to make a page that will display this log.
I did some testing, but I did not succeed. I'm using Tomcat 9 and eclipse to run....
I am using fopen , to export the return of a select, it is exporting correctly, but in certain fields it is appearing "" as I remove "" from export, leaving only ,
Because it is coming out as follows: "rice", "sw...
Staff created a table called records in a test database.
In it I was doing the insertion of data of a file cadastros.txt
Until then the id primary key when I created it was not auto_increment
so for test purposes I made a dro...
I would like your help with the connection below, when I close I have the following error, am I doing it correctly? with regard to opening and closing the connection?
My pool
public class MysqlConnectionPool {
private final DataSource dataS...