Questions tagged as 'mysql'

Tagged questions
2
answers

SELECT on 2 MySql tables with PHP

I have a question when giving a select, because I have 3 tables, they are professionals, experiences, address. Let's say I have a professional and this professional has more than 2 experiences. Is there any way to bring this information in a...
asked by 29.09.2015 / 21:15
1
answer

How to count values of type NULL in MySql

I have a simple table with the answers, in this table I can have answers with value null, 0, 1, 2, 3, ... , but when I count the number of answers with each value those with the value null does not count, / p> Here's an example in...
asked by 04.03.2016 / 20:10
1
answer

Doubt insert MySQL

Good morning,  I'm trying to make an insert, plus this giving error and seems to be in the field hour, could help me identify what's wrong:  Here is the insert and the error. INSERT INTO senhas...
asked by 01.03.2016 / 14:20
4
answers

How to search for results in MySQL where a particular field has only special characters?

I need to search in MySQL, lines where a particular field, for example 'Name', is filled with only special characters or spaces. I tried several REGEX for this, but without success. Could anyone help me?     
asked by 07.03.2016 / 19:10
1
answer

Update with Select

I'm new to the forum and SQL. I use the MySQL Workbench DBMS to try to learn the syntax. Querying a site of tutorial, I was to carry out an update using a select, follows command line: update actor set salario = salario * 1.1 where salario = (...
asked by 20.01.2016 / 18:30
1
answer

Querying multiple tables in mysql

My template is as follows, I have 4 tables Avião (tailnum (PK), year) Voos (id_voo (PK), cancelled) Modelo (idmodel (PK), nome) Fabricante (id_fabricante (PK), nome) Airplane is with a 1: M link with the flights table and model, and the mod...
asked by 16.09.2015 / 00:12
1
answer

Add values of an inner join to 2 variables

I wonder if you have some way to get the results of a separate select through php. I have two foreign keys in the same table, set to the same place, they are tj.fk_time_mandante and tj.fk_time_visitante. SELECT tt.ds_nome, tti.ds_nome FROM tb_...
asked by 23.09.2015 / 02:28
3
answers

Fields Checkbox Coming from the database

I have 3 tables, respectively: Vehicles vehicle_id, vehicle_name . Accessories acessorio_id, acessorio_name Vehicle_accessories vehicle_id acessorio_id On the vehicle registration page the accessories f...
asked by 21.10.2015 / 23:21
1
answer

How to append query in a DataGridView?

I was able to Inserts and Updates . I've downloaded this file: using System; using System.Collections.Generic; using System.Linq; using System.Text; using MySql.Data.MySqlClient; using System.Data; namespace MySQLClass { //Do...
asked by 20.10.2015 / 19:51
1
answer

MySQL Time Comparison

I have a schedule where I register an appointment, this appointment has Hora Inicial and Hora Final . But now when I register a new appointment I have to do a check to see if the hours are not between the hours already registered. E...
asked by 10.07.2015 / 20:18