Questions tagged as 'mysql'

Tagged questions
1
answer

Delete in sql - Inner Join

How is the syntax of a query using Inner Join delete in sql, to compare two-table code and exclude to be equal? Sales item table. in the item sale table, a sale has been registered whose code is 4. To execute the reversal, if applicable, the...
asked by 27.05.2017 / 20:56
1
answer

Problem with table wp_termmeta

The following error is occurring permanently, registered in my error_log: Error in WordPress Table database 'odiletan_bd.wpTP737termmeta' doesn't exist na query SELECT term_id, meta_key, meta_value FROM wpTP737termmeta WHERE term_id IN...
asked by 08.06.2017 / 14:51
0
answers

Mysql does not start on the server!

I can not start MySQL on the server console. Here is the below error:    / *************** /var/log/mysql/error.log *************** /       170525 10:50:35 [Warning] Using unique option prefix myisam-recover   instead of myisam-recover-optio...
asked by 25.05.2017 / 16:04
1
answer

I would like a user to enter a single border of markers on the map

Good morning, I would like to know if there is a way for me to determine a maximum limit of markers registrations for a user, depending on their level of access in the database. Example: CREATE TABLE tb_users ( id_users int (1...
asked by 16.05.2017 / 15:31
0
answers

Read TXT / DAT file and parsing before saving to the database (mysql)

I have an application in Ruby on Rails whose function is to read a text file with the following "TXT / DAT" extensions, so I need a simple page (just an input field (file) and a button of submit) to send the file, the file itself has several lin...
asked by 17.05.2017 / 13:24
0
answers

SQLSTATE [23000]: Integrity constraint violation

I have an employee table and address. The address is a foreign key of the employee, however, is giving the following error when I insert: Exception 'PDOException' with message 'SQLSTATE [23000]: Integrity constraint violation: 1452 Can not ad...
asked by 16.05.2017 / 21:32
0
answers

Error accessing mysql bank in azure

After creating a new user I can not access my mysql database in azure. How can I reverse this error?     
asked by 31.05.2017 / 01:14
1
answer

insert data from an array into the database - java

I am creating a system that at some point must create a request and this request has several items that I put inside a ListList. I have a request table in the database, how will I create my method in DAO to save the order items in the order tabl...
asked by 31.05.2017 / 04:51
1
answer

You are not setting the value in the query.setParameter when trying to query the database

I have a problem when setting a value in query.setParameter . Using EcliseLink and MySQL, I made a query without setting parameters and it worked, what could it be? Class where I try to query: /* * To change this license header, ch...
asked by 02.06.2017 / 00:26
0
answers

Doubt with query mysql bring results even if there is nothing

I have the following query inside a javascript that generates a graphic: <script> $(".sparkline_one").sparkline([<?php $sql="select count(id) as total, DAY(dia_criacao) AS DAY, MONTH(dia_criacao) AS MONTH, YEAR...
asked by 15.05.2017 / 21:01