Questions tagged as 'mysql'

Tagged questions
3
answers

Error accessing SQLAlchemy and mysql database

I have installed an Ubuntu server! 6.04.4 LTS, mysql 5.7.21 and python 3.5.2. I am developing a script in python that gives me the information of the existing databases. The problem is that executing the script always gives me this error:   ...
asked by 08.04.2018 / 23:09
1
answer

Syntax error in Java, MySQL

I have a syntax error in the following String and I do not know what is due. Nparte is of type int . String editSQL="UPDATE PARTESDETRABAJO SET DESCRIPCIONTAREA=?,"+"FECHAENTRADA=?,"+"FECHAENTREGA=?,"+"TIEMPOEMPLEADO=?"+"WHERE NPA...
asked by 06.06.2018 / 10:53
1
answer

Accents with mysql and php

I am making an application and my goal is that from the form you enter the data with accents and ñ, and that in the BD are stored the same. It turns out that when executing the following query through PHP with PDO (from the backend of the app...
asked by 24.03.2018 / 23:09
1
answer

PHP cycle while printing unwanted results

I am making an invoice in which I can pay 1 or several installments of the contract at the same time. Each payment is saved with the date and time it was made. For example if I pay 3 installments at the same time, all 3 have the same time and da...
asked by 11.03.2018 / 14:30
1
answer

Create MySQL database from script in bash ubuntu 16.04

I would like to create a database using a script that I already have, in MySQL from the bash of ubuntu 16.04, the script is the following -- Creamos la tabla si esta no existe CREATE DATABASE IF NOT EXISTS platzi; -- Indicamos que trabajaremo...
asked by 25.02.2018 / 18:06
2
answers

Replace characters in column during SELECT SQL

I have a column in my database that goes something like this: ----------------- | nombre | ----------------- | 225/65/17 etc| | 225/55C R17 etc| | xxx225/65 r16 | | 235/65 17 etc| | etc 215/65 R17| ------------- And I...
asked by 15.02.2018 / 10:57
1
answer

How can I check in Mysql only the same names of a product table?

My Table product is this: Product table id Nombre precio stock 1 Zapato $45.00 40 2 Zapato $23.00 30 3 Zapato $23.00 30 4 jeans $28.00 10 5 lentes $89.00 20 This is a small table that I can not make a q...
asked by 15.02.2018 / 18:54
2
answers

Extract table data to another table automatically in MYSQL [closed]

I have a field called TIME with the data type datetime and this default is CURRENT_TIMESTAMP . The result when I enter a record comes out in this way 2017-12-20 09:45:00 but what I want is that in another table I save only the specific...
asked by 20.12.2017 / 15:32
1
answer

Queries between several related tables

I have a table actividad that has two attributes: creadoID and modificadoID in relation to the table usuario . I tried to perform an activities query, where for each record I took the user's data from the person...
asked by 24.11.2017 / 02:43
1
answer

Updated PHP - HTML form

I have a form to add data to a table (visual in HTML) and to the database (in a table called "Cabanas"). Doubts: 1) Why is not the table automatically updated when you click "Save"? And you only see the cabin added when we update t...
asked by 29.11.2017 / 10:20