Questions tagged as 'mysql'

Tagged questions
0
answers

Query sql with reserved word in column name [duplicate]

     This question already has an answer here:                   A MySQL query with 'ciphers' vs without                                      2 answers                                                 Mysql reserved keywords        ...
asked by 22.06.2018 / 22:07
0
answers

Partitioning MYSQL tables

Good night everyone. I have a question regarding tables in mysql. Assuming the following scenario. I have a MYSQL INNODB table with PK ID INT UNSIGNED. (4 billion records approx) 1 º If by chance I reach the registry 4,294,967,295.00...
asked by 20.06.2018 / 23:48
2
answers

Get mysql table id in application

I'm developing a Java application where I need to retrieve the id of a Course table (idCourse, CourseName, CourseCode). I'm trying to do the following: public class Teste4 extends javax.swing.JFrame { Connection con = new ConnectionFa...
asked by 21.06.2018 / 00:35
1
answer

How to generate graphs with Laravel 5.6 and Mysql? [closed]

Good afternoon, I'm doing a project that I would like to add some graphics to, but the libraries I found were not very effective ... I would like some indication of some library to use along with Laravel and MySql ... If possible with documentat...
asked by 20.06.2018 / 21:43
0
answers

PHP query with response from another query

I run a query that returns a list of IDs. With each ID of this list I want to make an insert into a second table. My code: <?php $db = mysqli_connect("localhost","root","","test") or die("Erro ao conectar na base de dados MySQL!"); $que...
asked by 17.06.2018 / 06:36
1
answer

How to insert dates in a table from a database using PHP? [duplicate]

I am creating a form where I need to save the dates that are placed inside the Inputs in a MySQL database table, but as I am now apprehending PHP, I am having difficulties, because with the code I always have to press to send the information t...
asked by 25.06.2018 / 23:53
0
answers

Error 1042 when installing Mysql 8.011 on win 10

This error appears in the Starting Server part.     
asked by 23.06.2018 / 14:30
0
answers

"Foreign key constraint is incorrectly formed" MYSQL - Help

I'm modeling a database in MYSQL and I'm having a problem that I can not identify: Bank creation: -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHE...
asked by 23.06.2018 / 02:25
2
answers

Satisfaction survey form

I have a following question, because I put a search form and unfortunately it is not inserted in the database, I am possibly letting something happen. PHP registration code - > <?php include_once 'conexao.php'; if(isset($_POST['cadast...
asked by 15.06.2018 / 14:02
2
answers

How do I save to the database, when a "user" or "admin" edit or register a new item? [closed]

I want to know how to save the actions, type, when admin, logs and shifts, changes a register or creates a new cadastre ??     
asked by 15.06.2018 / 04:18