Questions tagged as 'mysql'

Tagged questions
1
answer

Foreach within While

Capture in an array the values received via checked checkbox post, these checkboxes have the values equal to the field names of the table, I need to query with while and print the fields referring to array: <?php $campos = '''.implode('...
asked by 22.05.2015 / 03:48
0
answers

Truncated data LOAD DATA INFILE

I have a problem with load data, trying to insert the CSV file the data is truncated because in fields like comments or in the address. LOAD DATA INFILE 'exemplo.csv' INTO TABLE relat_produt_analistas_temp FIELD...
asked by 01.07.2015 / 14:59
0
answers

Vertabelo - Warning: Reference Name seems to be invalid

I'm using the vertabelo because I need to share my program with others, however when I brought my work to him. It appears the following warnings, does anyone know what it is? link: link The problem is in the comments, the idea is as foll...
asked by 02.06.2015 / 07:14
0
answers

Intel XDK Connection with Mysql Database

I have a question about connecting my external database application to Intel XDK. Could someone tell me what other techniques connect my application with an external database, plus the possibility of developing a webservice with php and xml / js...
asked by 01.06.2015 / 19:42
0
answers

Error "java.sql.SQLException: Incorrect string value: \ xE7 \ xF5 for column"

Good afternoon, I'm having the error below whenever I try to perform an indexing method. ERROR: javax.servlet.ServletException: net.alforria.util.InfraException: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC b...
asked by 02.06.2015 / 19:15
0
answers

MySQL access through MSSQL client

First of all I would like to inform you that my knowledge in SQL is beginner ... I have a proprietary MSSQL client application and would like to know if there is any way to get it to the MySQL database through a linked server or another way. The...
asked by 01.06.2015 / 20:20
1
answer

How to remove duplicate lines efficiently?

I'm normalizing a table here and found that there are duplicate rows. The way I chose to clean these lines is through: CREATE TABLE tabela_nova AS ( SELECT DISTINCT * FROM tabela_antiga ); The problem this way is that it is very slo...
asked by 10.06.2015 / 01:56
1
answer

Oracle Data Modeler - Connect to MySQL Database

Hello I'm having problems about two days ago about connecting the ODM (Oracle Data Modeler) to a mysql database. The process in all the places that I found consists of: -Initiate Oracle Data Modeler (ODM) -No ODM, follow Tools - > Pref...
asked by 11.05.2015 / 19:24
1
answer

Insertion with non-standard characters [duplicate]

When I enter MySQL database with PHP and PDO are entering strange and cluttered characters, what could be wrong? Here is an image of a bank table: Mypagehastheparameter:<metaname="viewport" content="width=device-width, initial-scale=1.0"...
asked by 27.04.2015 / 03:29
2
answers

HttpPost action returning null values

I'm developing a web (intranet) system for handling requests in ASP.NET MVC 4 C #. Below are my MVC where I have questions. I'm having a hard time with the HttpPost of a Tipada View, which is returning null value for the "REQUEST" property of th...
asked by 29.05.2015 / 22:52