I need every day, the system send shipping requests to the post office. How can I do this automatically, without needing a user to load the page or anything?
I would use the same logic of doing something automatically without user interaction...
What is Binary and what does it do?
What is the difference generated when using Binary in a query in MySQL and when not using Binary ?
SELECT email, senha from login WHERE usuario = ? && senha = ?
SELECT email,...
I have the following queries in MySQL:
1st: Using multiple OR
SELECT SUM(qtd)
FROM
produtos
WHERE
qtd > 10
and (status = '0' or status = '4' or status = '7')
2nd: Using IN
SELECT SU...
I have a database and would like to know how do I search for the data by typing the complete result using where
Example:
ID NOME CODIGOS
1 | Joao | 9714,51,100
2 | Maria | 50,9714,88100
I wanted to make it return a where by search...
I'm trying to get the column type of the tables from my BD , and how can I use PHP with Laravel I've tried using GetType to get the types and show on view . But the code is only returning Object .
Here is t...
I want to make a query sql and I want each line to have a column indicating the line number eg:
linha nome
1 joao
2 maria
3 tiago
. .
. .
. .
n joares
But, this column "li...
In java I created a project where I use the drive mysql-connector-java-5.1.40-bin.jar In this project I created a class with a form to register course and in mysql I created a database called sistema with a table called curso...
I'm trying to get the longest date entered in my BD , I'm trying to use the MAX and DATE_FORMAT functions together and the search result is not as expected, I have these dates registered:
2016-10-24
2016-10-25
2016-10-26
2016-10-27
2016...
What is the difference, in the syntax, of the following databases, for a simple query, of type:
SELECT * FROM tabela WHERE id = '1' ORDER BY nome GROUP BY nome LIMIT 1
Or, what do they differ in syntax in general? Or is it all the same?...
I have a lot of questions about MySQL when I have to use INNER JOIN to get data from other tables.
I have 3 tables:
MEDIA
id, user_id, title, description
COMMENTS
id, user_id, media_id, comment
MEDIA_LIKES
id,...