I was creating my querys and suddenly
The issue is that I can not continue with the development of my program
I leave the code of my connection
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
i...
Good afternoon in advance greeting and thanks for your time I am in a company with a system "semi open" so to speak that only lets me manipulate the select, from but not the where of my queries this brings as a consequence, informa...
I have 2 tables in which I record baseball statistics for 2016 and another for 2017.
I have not been able to formulate a Query that adds the statistics of the 2 years of each player and shows it to me in the same way they are shown in the i...
This is my mistake:
The configuration file contains syntax error on line 1:
[EparseError] text is not inside a section
How can I solve it since there I have my database too?
I am adding columns dynamically from rows with the following prepared statement in mysql.
SET @sql = null;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(IF(PC.id_competencia='
,PC.id_competencia
,',PC.puntaje,0) ) AS P...
I am using a corporate ETL of MYABCM to transform some Excel spreadsheets to MYSQL, the problem is that I do not know how to transform the table on the left in the table on the right.
The logic is that the element in column F of the table...
Friends.
I am creating a project in laravel 5.5 using windows, but when creating the migrations "php artisan migrate", I get this error:
In Connection.php line 664:
could not find driver (SQL: select * from information_schema.tables...
I have a question to make a query where I show the sale with your items sold.
I currently have this query:
$query=trim($request->get('serachText'));
$ventas=DB::table('venta as v')
->join('persona as p', 'v.cliente','=','p.i...
First of all a cordial greeting! I have one forms where the user enters a series of numerical values. What I want to do is send these values to a PHP file using Jquery so that PHP can perform a series of calculations with them (subtraction,...
I'm trying to install Plesk on a server with Cent OS 7 and it throws me different errors, I thought it could be the PHP version so uninstall the 7 and install again the 5.4 but it was not like that. The list of errors that you send me is the yes...