Questions tagged as 'mysql'

Tagged questions
1
answer

Listing the most offending querys in MySQL

I would like to know which are the most offensive queries in my database. I have already used the conventional "Show full processlist" and other methods.     
asked by 25.07.2017 / 19:21
3
answers

Doubt with table relationship

Good evening I have the following BD in MySQL CREATE TABLE IF NOT EXISTS 'cad_cliente' ( 'id_cliente' smallint(5) unsigned NOT NULL, 'nome_cliente' varchar(45) NOT NULL, 'nome_dr' varchar(45) NOT NULL, 'email_client...
asked by 12.06.2015 / 22:42
1
answer

JAVA Connection with BANK

I am not able to connect java with a database, because an error appears as in the image, Can anyone help me?     
asked by 15.06.2015 / 19:32
4
answers

How to limit PHP words

Hello, I would like to know how I limit the text I pull from the database. For example, I have a text called: Lorem ipsum dolor sit amet. And I wanted you to limit the text by pulling, it would look like: Lorem ipsum dol ... &l...
asked by 26.06.2015 / 18:41
1
answer

Select (combobox) Dynamic

I need to use a dynamic select on my page, in which when I select the state (UF), it shows me in the next select only the cities of this UF. In the same way the neighborhoods. All of this information is already in the database....
asked by 16.02.2017 / 20:27
1
answer

Save relationship 1: 1 in Laravel 5.3

In my scenario, I have the tables of users and teachers, where a teacher has a user, so I have a 1:1 relation. Migrations: create_users_table Schema::create('users', function (Blueprint $table) { $table->increments('id'...
asked by 07.01.2017 / 01:33
2
answers

Store multiple select in a column only with PHP / javascript + MySQL

I'mhavingahardtimestoringselectmultiplesinthesametablefield.Inthiscase,whenfillingouttheformandmarkingmorethanoneselect,itstoresonlyoneandtheinputquantityfieldthatisinjavascriptdoesnotstore.HowcouldIdoittostoreeverything<?phperror_reporting...
asked by 18.01.2017 / 23:07
1
answer

Change cell color according to result?

I am a beginner in this universe, and I am caught up in my development in a simple function that I can not understand. This code below gets a value from the database, and I would like the background cell to change by value, for example if the fi...
asked by 16.01.2017 / 23:16
3
answers

Where in an array

I have the following Query: SELECT u.user_nome FROM tb_Usuario u WHERE u.user_ativo = 1 I need one more clause where where it compares a id of the user. However, I get this id through array , how do I make that...
asked by 08.11.2016 / 18:31
1
answer

Doubt with relational modeling

I am setting up a real estate register, where these properties belong to an address, which belongs to a neighborhood that belongs to a city. Ex tables: Imoveis: id, endereco_id, etc... Enderecos: id, nome, bairro_id, rua, numero, cep, etc....
asked by 30.06.2014 / 17:20