Questions tagged as 'mysql'

Tagged questions
1
answer

error with EF and Mysql query

I have the following query: var produto = (from a in context.ItensReceita join b in context.Receita on a.t0080_id_receita equals b.t0080_id_receita join c in context.Medicamento on a.t0080_id_receita equals c.t...
asked by 09.02.2017 / 11:15
3
answers

Find first name in the mysql field before MYSQL space

I have to look for a date in a mysql field, but the guys had put it to save so "2016-02-21 14:02:01" I just need the date from there, how can I check on the select date I want to compare with that date?     
asked by 21.02.2017 / 18:03
1
answer

MySql display the sum field with value null

I've researched but not found anything I need. I have a table where I have the record of debit and credit postings. These values are in the 'value' field. But I want to display this field in two columns, one for debit and one for credit. I...
asked by 15.04.2016 / 17:04
3
answers

Do an independent search of the order of the keywords

I have a database in which I need to search based on the keywords, regardless of the order. See the full table below: +----+-----------------------+ | id | description | +----+-----------------------+ | 1 | joão de santo cristo | |...
asked by 04.03.2017 / 06:05
3
answers

How to sort the date?

In the database: Showingpage(inphp): I would like it to appear as follows: 03-11-2015     
asked by 19.11.2015 / 22:06
1
answer

INNER JOIN with where

I have the following tables: permissoes_users id_user id_permission permissions  id  - Permission I have a session variable where I have the id di user, I need to search the table for the id and those that have the id of the user to...
asked by 19.11.2015 / 12:51
1
answer

Database to work after a few hours

Hello, in this registration system, I get the information entered and I play it in a database. include("connection.php"); require("blowfish.php"); $login = $_POST['login_cadastro']; $senha = $_POST['senha_cadastro']; $confirmarsenha = $_P...
asked by 17.05.2015 / 03:16
3
answers

Count Mysql records

I have a table where I store sales. Home There was a need to order sellers by the amount of sales. In case of a tie the one who made the most recent sale gets first. I can bring with the sql below, the seller and time of the sale, however I...
asked by 12.11.2015 / 12:27
1
answer

SQL has no results after using bind

I made this code to create databases : public function addDatabase($name, $collation) { try { $sql = "CREATE DATABASE ':name' COLLATE ':collation';"; // Prepare the query to execute $query = $th...
asked by 04.04.2015 / 15:59
3
answers

Search results for 3 table with date of last 5 days

I have the following tables: What I'm trying to do is fetch the names of users who have no records in tbl_votos and no resources in tbl_recursos in the last 5 days . I'm using php and mysql.     
asked by 08.05.2015 / 15:08