Questions tagged as 'mysql'

Tagged questions
2
answers

What is the difference between SCHEMA and DATABASE?

I had never used the MySQL Workbench and it instead of database, gives me the option of SCHEMA. What's the difference between the two? Does it give one or the other?     
asked by 18.07.2018 / 15:54
1
answer

What is the best way to update multiple tables using a trigger?

I have a trigger for After insert notes After delete notes After update notes You need to update multiple tables like sales, sales, sales. I tested using a cursor for each table, at first it worked normally, my question is about performanc...
asked by 25.07.2018 / 17:24
2
answers

How to write data from a form into a database by converting the fields to JSON?

I have some form, example: <form action="confi.php" method="post" enctype="multipart/form-data"> <p><input type="text" name="nome" value="nome"> <p><input type="text" name="email" value="email"> <p>...
asked by 15.03.2017 / 16:19
1
answer

SELECT Union ALL Dismiss Arguments

I have this query that adds two results to different tables. SELECT sum(g) saldo_anterior from ( SELECT SUM(valor_pg) g FROM ctrl_deposito WHERE MONTH(data_pg) < 11 and YEAR(data_pg) <= 2016 or YEAR(...
asked by 17.07.2017 / 14:13
2
answers

Initialize apache and mysql on windows 7 32 bits using Xampp

I would like to initialize Apache and Mysql from Xampp as soon as the system is booted, I ran some searches and found this:    Service installation: In C: / xampp / apache double-click on "apache_installservice.bat".   Uninstalling the servic...
asked by 27.07.2017 / 18:37
1
answer

Display only a maximum number of characters

My question, I think, is quite simple, how can I do to display only a maximum number of characters for the user, for example 25 characters + "..." The idea is to limit the characters of these texts, so that the sizes of the div's do not...
asked by 04.08.2017 / 21:34
2
answers

UPDATE giving error but updates database

IamcreatingaloginpagewhereIneedtowritetotheMySQLdatabasethedateandtimetheuserwasloggedin.InthedatabaseIhaveatablesomethinglikethis:____________________________________________________|nome|login|senha|login_on|----------------------------------...
asked by 22.07.2016 / 21:42
1
answer

Login page redirect does not match

I'm having a hard time redirecting the user after logging in. I need some help, to find the solution. valida_user_login.php <?php $servidor = 'localhost'; $usuario = 'root'; $senha = ''; $banco = 'bd_'; // Conecta-se ao ban...
asked by 14.06.2016 / 21:41
1
answer

How to save HTML in Mysql

I have a deadlock over storing an HTML in the DB. I'm using the property in php: htmlentities($_POST['codhtml']) to perform this operation. But when saving a code like: <span class="frase-aditivo mover" id="adt6-enable" style="transf...
asked by 14.06.2016 / 20:25
2
answers

Do insert in two tables at the same time

I need to insert into two tables at the same time. I have a user registry and I need the id of a user to be registered in two tables at the same time, thus making an association of this user with another table, which contains a group of users....
asked by 11.01.2016 / 17:24