Questions tagged as 'mysql'

Tagged questions
2
answers

Difference between mysqlconnection and using (mysqlconnection)?

My question is what is the difference between the following connections? Conexion Mysql without USING MySqlConnection databaseConnection = new MySqlConnection("//CADENA DE XCONEXION"); // CODE; MYSQL Connection with USING using (Npg...
asked by 19.12.2018 / 17:02
1
answer

MySQL join / inner join 3 tables

I have 3 related tables. Users, in which I get the following columns (username). Submissions, I get the columns (id, title, thumbnail and rate). It also has the user_id column to know which user made the upload. Favorites, I get the 3 co...
asked by 28.02.2017 / 12:18
2
answers

Insert emojis in mysql 5.5

I want to insert texts that have emojis in a MySQL table. I saw that it takes 4 bytes for each emoji because they come in 2 hexadecimals. The issue that I have seen there are different "solutions" and none of them worked for me. Part of the e...
asked by 14.03.2016 / 17:04
1
answer

The value of the output is always null. PHP and MySql

I have a problem. The procedure returns an output value (boolean type) and when I pick it up in the php code it is always null. Any solution? Thank you! MYSQL STORED PROCEDURE: BEGIN IF EXISTS (SELECT * FROM cliente WHERE usuario...
asked by 27.11.2018 / 18:55
2
answers

why does it give an error on the PhP line?

The code is the following one I am doing after consulting from mySQL. <?php include_once "conex.php"; $resultado1 = mysqli_query($conexion, "SELECT nombre_esp,cantidad FROM sr_productos WHERE id = (SELECT id_producto1 FROM sr_escalas_detal...
asked by 26.11.2018 / 23:08
1
answer

PHP / MySQLI Syntax Error

What happens? I think it's well built, but obviously something is missing. Name of the Table: citas Field Name: idcita, horacita, diacita, asuntocita    Query Error 1064 You have an error in your SQL syntax; check the   ma...
asked by 14.11.2018 / 15:17
2
answers

MySQL query from C # returns InvalidOperationException

Thanks to the users I managed to establish the connection to my MySQL database from C #, but now another problem arose. I just want to get a DataSet where I can then read the data, but at the moment the function finishes, it always returns Inval...
asked by 14.11.2018 / 20:12
1
answer

Implement token's in web services with php and json

I have created several web services to consult data from my database from an android application, the web services are already working, they return the information to me and it is already shown in the application, but I want to implement token's...
asked by 29.12.2018 / 17:12
2
answers

Update Total Accumulated

I need to update the cumulative sales of all the clients in the accumPurchases field, for which I try to add all the invoices of each one and record this value there UPDATE contacts SET accumPurchases = (SELECT SUM(inv_total...
asked by 28.12.2018 / 19:52
2
answers

Can DIE be done in mysql connection? To show if I connect or not

I want to make a testing website. Connection PHP I have the following code: <?php $conexion = @mysqli_connect("localhost", "usuario", "contrasenia", "database"); if (!$conexion) { printf("Error de conexión.", mysqli_connect_error()); }...
asked by 24.12.2018 / 02:19