Questions tagged as 'mysql'

Tagged questions
1
answer

Charset in PHP with MySQL [duplicate]

Following: The header of my page is configured like this: header('Content-Type: text/html; charset=UTF-8'); I configured the connection to MySQL like this: mysqli_set_charset($dbc, 'utf8'); In my MySQL database a is set to InnoDB an...
asked by 07.01.2017 / 23:10
0
answers

MySqlDataAdapter Fill giving error

When using database connection in C #, I saw many ways to do it. I can make insertion of data in the database very quiet, but the selection of data is leaving me with white hair. Below the code and I will explain the error soon. public void...
asked by 06.01.2017 / 14:02
0
answers

Android application gives error when I try to sign in

Log in application in Android Studio. I can register in the application but when I try to log in I can not give me an "login failed" here is the code for login.php <?php require("password.php"); $con = mysqli_connect("198.91.81.5", "usuari...
asked by 03.12.2016 / 15:27
1
answer

Query is executed, but the data does not go to the database

Good afternoon, Galera, I'm studying the PDO and with the following difficulty, the query executes (Or rather, it does not return any errors), but when I go to the bank, it does not have anything, what do I do? / p> pdo = new PDO ("mysql:host...
asked by 10.12.2016 / 16:39
0
answers

No column names appear in jTable [closed]

I created a JScrollPane and a jTable in it, all inside a JInternalFrame, but when I run my Jframe and open this JInternalFrame, it only shows the data in lines that are in my database, but it does not show up there column names. JInternalFrame c...
asked by 11.12.2016 / 07:35
2
answers

Doubt in preparing a query in SQL

Could you tell me what's wrong with this SQL code? I want for each movie, the salaries of each staff does not appear repeated, ie if the first movie has 2 leads , in the table I want to sum these values to the lead . select Ms.salary as To...
asked by 17.12.2016 / 18:41
1
answer

create a triggers in mysql that reorganize the numbering of a field when one of these fields is excluded

I have a users table containing the following column: note that the position numbering is in order, what I want is when you delete some user to trigger rearrange the numbering, ie if you delete Josefa and Pedro, Jone becomes...
asked by 15.12.2016 / 13:33
1
answer

Insert data into the database

How could I insert the image data below into the database I created. is not giving and only inserted those 0. thisisthecode<html><body><head><metacharset="UTF-8"> <title>Sistema de Inventário</title...
asked by 22.12.2016 / 22:15
1
answer

How to query 2 tables inside a mysql database? [duplicate]

I'm new to sql and php. It's as follows, I have an affiliate system that I need to bring a user's affiliate list to. For this I use: <?php //traz os usuarios $query = sprintf("SELECT referral_user_id FROM magry_awoaffiliate_referral...
asked by 16.01.2017 / 22:19
2
answers

Increase number of rows returned by select group in MySQL

I have a table with 1 million rows that I need to make a report that groups the repeated names. I'm doing this SELECT instituicao, count(*) from base_wos GROUP BY instituicao; . However, MySQL always only makes the group of the first 100...
asked by 13.04.2014 / 01:27