Questions tagged as 'mysql'

Tagged questions
2
answers

Query Entity Framework with Inner Join and Where

I am making a query using inner join of some tables and a where with only one condition, but the data is not returned in EF, the same query in Mysql works and returns data. Follow the code: string raAluno = acr.getAlunoLogado().ToString();...
asked by 21.05.2016 / 05:45
2
answers

Insert foreign keys

I have two tables and when I try to use a key of the 1st table in 2nd the value appears NULL and it should appear the values that appear in Aquario CREATE TABLE Aquario( ANome varchar(64) PRIMARY KEY, Localizacao varchar(8), Capaci...
asked by 04.11.2016 / 12:47
2
answers

Count values with specific data in MYSQL

I have a huge list of values that I need to count, the example is, I have 4000 barcodes and in those 4000, 2000 are marked in the without stock column with a yes . Better explanations In the total bar code count I use this code...
asked by 02.05.2016 / 18:05
0
answers

Data structure to set up shop hours

First of all, I found this doubt , which in fact is similar, but did not seem to involve some criteria that I need, such as the hours of operation after midnight. I'm developing an app where I need to show the 'open / closed' stauts of a stor...
asked by 17.11.2015 / 11:09
2
answers

Select Inner Join from what is not on the other table

I have two tables, Anuidades and Pagamentos . From these annuities it is necessary to select data from Anuidades that have not yet been paid. Table Anuidades TablePagamentos Toreturntheannuitydatathathadbeenp...
asked by 19.11.2018 / 05:18
1
answer

Import data from excel to sql server

I need to import the data that is in excel to a table in sql. I looked at several sites but nothing so far has worked out. Using sql server management studio I have done the following so far, following the step a step : sp_configure 'show adv...
asked by 26.08.2014 / 17:09
2
answers

Select to subtract current value from previous and return column with result

I have two tables: Samples and Values, which have columns as follows: TABLE Samples Amostra_id Data Operador_Id Carta_Id TABLE Values Amostra_Id Valor As you can see, the Values table relates to the Samples table from Sample_...
asked by 14.08.2014 / 03:15
1
answer

How to correct the "SQLException: No suitable driver found" error when making a connection?

I'm trying to connect to the database in my code, however it appears the following error:    Exception in thread "main" java.sql.SQLException:   No suitable driver found for jdbc: mysql: // localhost: 3306 / user Code: public class Con...
asked by 25.09.2015 / 06:59
4
answers

PHP class for interaction with BD MySQL

Does anyone know of any PHP class for MySQL integration, using the mysqli_* and prepared statements function? I have these two examples here: MysqliDb MySQL Database
asked by 04.07.2014 / 16:16
1
answer

Filter first result

Is there any way to filter the first result of a query in php? Example: $query = mysql_query("SELECT * FROM teste2 ORDER BY 'id' DESC") or die(mysql_error()); while ($row = mysql_fetch_array($query)) { if (RESULTADO == PRIMEIRO RESULTADO)...
asked by 28.06.2014 / 02:43