Questions tagged as 'mysql'

Tagged questions
1
answer

How can I handle this type of relationship in Eloquent de Laravel?

I know how to handle relationships like "One to Many" but when creating a new sale, what would be the best practice using Eloquent to save?     
asked by 17.01.2018 / 15:03
1
answer

Error 1415 in MySQl when creating a trigger

Good afternoon, I am trying to create an alert trigger for lack of products, which throws me the error:    Not allowed to return to result set from a trigger. This is the Query of the trigger that I'm trying to create delimiter $ create...
asked by 30.12.2017 / 21:53
1
answer

How can I make an entry always up MYSQL PHP

I come to ask for your help, I am programming a forum in php and mysql without a framework, and I need to put in the list of entries the rules of the forum so that it remains fixed (ALWAYS UP) and so when users fence entering new entries appe...
asked by 21.01.2018 / 03:04
1
answer

Relate two fields to the same primary key PHP - MySQL

This is how I have the code MySQL of my tables. tasks : CREATE TABLE tasks( task_id INTEGER UNSIGNED PRIMARY KEY AUTO_INCREMENT, created_by INTEGER UNSIGNED NOT NULL, support_by INTEGER UNSIGNED, customer_id INTEGER UNSIGNED NOT NUL...
asked by 22.12.2017 / 19:05
1
answer

Accelerate amount of PhpExcel

Good day, When I do the amount of files of up to a thousand records it does not delay, but when I increase the number of records it takes a long time. My question is if anyone knows how to accelerate the amount of phpexcel. Thanks in advance.  ...
asked by 22.01.2018 / 01:06
1
answer

How to reverse the order of a chat in PHP?

How can I get the most recent messages on the top and the oldest messages on the bottom, the messages are stored in my database. This is my chat.php: inside is the style and a script that updates the load.php        <style> *{margin:0p...
asked by 14.06.2018 / 00:35
1
answer

INNER JOIN between InnoDB and MyISAM tables

I am developing a database, therefore some tables will have MyISAM Storage Engine and other InnoDB. My question is this: are there problems when performing INNER JOIN with tables that handle different Storage Engine?     
asked by 10.12.2017 / 03:14
1
answer

modify table in mysql from a php form bringing the data from another file

Good evening, I am looking for help with the following, I want to modify a record of a table in php, I have already managed to search for the records and show links to modify and delete using the following code: <!doctype html> <?php...
asked by 07.12.2017 / 02:55
1
answer

change status when exceeding the date column

Good morning, I have the following problem: I need to change the states after a deadline (table date column date ) and at the same time change the states where reference the iddocumento (including the one in the document ), This is my t...
asked by 02.12.2017 / 20:10
1
answer

Mysql query, filter

I have a table with People and roles, and I want to select people who do not have the Head of Department role in a selection. The problem is that if you have the role, the user also shows it and I want it to be shown at the moment you have th...
asked by 03.12.2017 / 20:17