Questions tagged as 'mysql'

Tagged questions
1
answer

SQL statement with INNER JOIN to pull a column of two tables in Java

I need help with a SQL statement. I have never worked with INNER JOIN and I can not do it correctly. As you can see in the previous image, what I'm looking for is this: Save the id_invitacion of the table invitacion...
asked by 05.12.2016 / 04:40
1
answer

Syntax error in MySQL script

I created a simple script in MySQL .... the idea is to create a procedure that shows the data of the last record of a specific table. This would be the code of the script: DROP PROCEDURE IF EXISTS mostrarUltimaAlta; DELIMITER $$ CRE...
asked by 02.12.2016 / 17:05
1
answer

Column name to first field of a csv

I have a code that allows me to export information from a table in my database, but I would like it that every time you export to the file, put the name of the column. <? if($_POST[exportar] == "expbas"){ $consulta = "SELECT *...
asked by 01.12.2016 / 22:34
1
answer

MySQL statement to correctly update an existing record from Java

I try to update a user's data but, I receive the SQL Syntax error.    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an   error in your SQL syntax; check the manual that corresponds to your   MySQL server version for the...
asked by 01.12.2016 / 06:44
1
answer

Fix in MySQL

I have two related tables, movement and details_movement : movimiento +---------------------+-----------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------...
asked by 19.11.2016 / 17:36
1
answer

Show route with several Google Map bookmarks

I'm trying to do a google map that marks a route with several points, I saw an example on the google maps page. To do this I need an array with the intermediate positions. I have the positions in a mysql bd but I do not know how to pass the addr...
asked by 16.11.2016 / 00:35
2
answers

Syntax database

I have generated a script in mysql and at the end of what was said before it appears SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; The problem is that this is gene...
asked by 23.12.2016 / 19:25
2
answers

I do not work the tables made in MySQL on Microsoft SQL Server 2014

SET SESSION FOREIGN_KEY_CHECKS=0; /* Drop Tables */ DROP TABLE IF EXISTS SE_COMPONE; DROP TABLE IF EXISTS ARTICULO; DROP TABLE IF EXISTS PEDIDO; DROP TABLE IF EXISTS CLIENTE; /* Create Tables */ CREATE TABLE ARTICULO ( num_serie numeri...
asked by 04.01.2017 / 21:43
1
answer

Error: SQLSTATE [42000]: Syntax error or access violation: 1064

I get an error when wanting to generate an action like modify or save . Error:    SQLSTATE [42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve...
asked by 15.12.2016 / 07:43
1
answer

Show name of the person who is connected to the system

I am making a system of military sanctions from scratch. with PHP and MYSQL Already install the user LOGIN system My question is: How do I show a welcome message with the name of the user who logged in? THE FOLLOWING ERROR COMES OUT:...
asked by 16.01.2017 / 04:06