Best answeres tagged with mysql

1

answer

Difference Between Using "FROM Table, Table2" X "Join Table ON Table2"

Considering the two forms of joining tables with a join (any): SELECT Tabela.A, Tabela.B, Tabela2.C FROM Tabela LEFT JOIN Tabela2 ON Tabela.Id = Tabela2.TabelaId And a union using from SELECT Tabela.A, Tabela.B, Tabela2.C...

asked by 06.04.2017 / 14:47

1

answer

Relate MySQL tables and filter by date

I need only one final value, the commission amount for products with extra commission in a date range and a specific vendor, the information is in 3 tables in the DB: Below is the table 'products_commission_extra', the column 'Data_abertura'...

asked by 09.09.2016 / 13:09

1

answer

MySQL database update

I'm working with one database on localhost and the other on production. At various times I need to upgrade my local bank to match that of the server. I made a .sh script to be able to copy all files from the database table (/ var / lib / mysq...

asked by 18.06.2014 / 13:38

1

answer

Query to join one column from another

asked by 08.07.2014 / 17:40

2

answers

Conflict between Simple_HTML_Dom and non-object-oriented functions

I'm developing an app that has to access a list of sites saved in a database, loading all its links. It is a test application but I have encountered a difficulty. The routine is this one: function crawler() { include_once './simple_htm...

asked by 08.05.2014 / 11:38

2

answers

Insert data into database according to number of checkboxes

I have form where I have fields with chekboxes and I want to know if it is possible to make as many inserts as selected fields. In other words, if the user chooses 4% with% I make 4% with%, is it possible? If so, how can I do it?...

asked by 29.01.2015 / 19:26

2

answers

Impact of exchange - MyISAM by InnoDB

In a medium database (~ 2GB) MySQL that is all with the MyISAM engine. Realizing the conversion to InnoDB, what will be the impact on my system? Can I simply convert by phpMyAdmin, for example? Has anyone ever had this experience?

asked by 17.02.2014 / 18:44

3

answers

Select months even without records

I need to select the data stored in the database and separate them by month, but when the month does not have data yet, the month is not returned. I need the month to be returned with the value zero but to bring the month anyway. My Query...

asked by 22.11.2018 / 18:07

2

answers

Count friends in common using LEFT JOIN

asked by 03.05.2016 / 18:05

1

answer

Does not INSERT the data in the database

Well folks, I have this code, and what happens is that since I inserted the part to upload an image it does not send anything to the database. Not a new line creates, nothing at all. Can someone help me? <? require('../cdn/lib/config.ph...

asked by 03.05.2015 / 21:02

Questions tagged as 'mysql'