Taking this table as an example:
create table datos_prueba(
id int not null auto_increment,
persona int (11) not null,
mes int (11) not null,
anio int (11) not null
dato int (11) not null,
total int (11) not null,
p...
Hi, I have been researching and unfortunately it is not so clear to me to be able to move from rows to columns or maybe it does not have the same format as in the examples
I'm doing this query to enter it into a KENDO GRID table,
This is my quer...
I am trying data from several tables of the same scheme that have no relation from a given date but I am super green in mysql ... I am trying this way:
delete from tabla1,tabla2 where date < '2018/01/01';
but I get syntax error...
this is the controller,
public function index()
{
//$files = File::all();
//return view('file/create', compact(''));
$paises = DB::table('clientes')->pluck("nombre","id")->all();
return view('file/creat...
I have a problem calling a Stored Procedure with codeigniter, the stored is to generate an id autonumeric this is the code, I use PHP 7.0 , MySQL , Codeigniter 3 , jQuery 3.1 .
DELIMITER $$
CREATE DEFINER='root'@'localh...
I need to make the following query using Symfony 2.1 and Doctrine, but I have no idea how I can make it work, I would appreciate it if you can help me with this problem.
SELECT * FROM (
SELECT
factura.id AS factura,...
Hi, I have the following problem:
I have all my MySQL DB, tables and columns with charset utf8 and collation utf8_spanish_ci
When I run this query:
SELECT *
FROM profesionales INNER JOIN horarios
ON profesionales.id = hora...
This is the view that carries the data, the file and the name but when it reaches the controller it only sends the file
<input type="file" name="link" required="required">
<textarea type="text" rows="50" hidden="hidden" id="text...
When doing a DUMP with mysqldump, the views are saved as tables:
CREATE TABLE v_facturas
The correct thing would be CREATE VIEW v_facturas AS ...
What option should I use to prevent this problem from happening?
I managed to make him make the command to look up the data of a table, but he does not show them in the datatable, I do not know why. Does the query, but does not show it.
I already asked this question 2 times, and nobody even tells you. I do...