Questions tagged as 'mysql'

Tagged questions
0
answers

PA in MYSQL, if not exist update else insert

I want to verify if there is not a table_id in my table to insert the dish data, in case there already exists a dish_id that updates the amount. BEGIN IF NOT EXISTS(SELECT _id_plato from pedidocarrito) THEN insert into pedidocarrito va...
asked by 27.05.2018 / 04:14
0
answers

Problem with Spring roo when trying to do reverse engineering

I was trying to do reverse engineering and when executing the command:    database reverse engineer --package ~ .domain --schema tests and I miss the following error:    Unknown character set index for field '255' received from server....
asked by 27.05.2018 / 10:52
0
answers

why do not you mark me wrong and do not insert me?

INSERT INTO spartodo_rh.tblVacantesPostuladas (idVacante,idSolicitudEmpleo,estado,fechaRegistro,fechaModificacion) SELECT * FROM (SELECT '1', '4','Postulada','2018-05-29 17:28:48','2018-05-29 17:28:49') AS tmp WHERE NOT EX...
asked by 29.05.2018 / 22:36
1
answer

Export the netbeans database

I want to export my project that I have done with netbeans next to the database that I created with this, as I do     
asked by 30.05.2018 / 08:10
1
answer

Insert enum field (mysql) multiple checkbox values

I need help to insert multiple values in mysql of a checkbox in a form: I have these checkboxes in my form <LABEL>Extras (los que procedan):</LABEL> <INPUT TYPE="checkbox" NAME="extras[]" VALUE="Vista Al Mar">Vista...
asked by 27.05.2018 / 17:34
1
answer

PHPMyadmin does not show the last records in the table

I have a table logs that has 700,000 records. When I go to the "Browse" section in phpmyadmin to see the records in the table, I click on the "> >" symbol. to go to the "last page", basically to go to the end of the table and see th...
asked by 25.05.2018 / 22:08
0
answers

Save data in database using synfony 3.4 and dynamic table

good afternoon. I have some doubts when it comes to how to save data in the database. I am using the synfony 3.4 framework to save the data with the form in my database, but I have found a problem. When making a delivery note I need to add diffe...
asked by 28.05.2018 / 16:07
2
answers

Assign the color of each row according to a row data

How can I change the color of some data extracted from my BD, for example if it is on a slope it is yellow and when it is resolved it is green. <?php $con=@mysqli_connect('localhost', 'root', '', 'bdpagina'); if(!$con){ die("i...
asked by 28.05.2018 / 21:40
1
answer

Select and insert php data

Guys, I doubt this data // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = " Select a.fe...
asked by 28.05.2018 / 21:06
2
answers

Problems with Mysql

I have a mysql database stored in a server, I connect remotely by ssh and I access from there to the databases, but when leaving the session by ssh, my other colleagues who also connect to the base server data can no longer access it, that is if...
asked by 28.05.2018 / 21:15