I am having a problem: I am creating a " forgot password" field where the user types the email and if it is in the database it appears as true and redirects to page teste.php ; otherwise, to the index.php page.
However, when I...
I'm using Laravel 5.3 and would like to use columns from two different tables related to foreign key:
For example:
Client table
id | nome | end_cep
1 | carlos | 69084555
2 | Maria | 69088555
Address table
cep...
In the MySQL Workbench , when we do not enter a record by query , and manually, when giving APPLY , the query is displayed before execution.
Example of a query consisting of MySQL Workbench :
INSERT INTO 'nomedobanco'.'tabela' ('id'...
I need to implement a working hours report within a period.
My difficulty is this: the records for each day are on different lines and because of this, I'm having a hard time knocking in and out of the right days and I still have to subtract...
I have a SELECT and in it I display the sum of the sales values of each product, would I have to make a total sum of the table that made the sum?
SELECT
cadpro.descricao,
sum(itensped.total_venda) AS total_venda
FROM itenspe...
I have the following query:
SELECT type,name,points FROM clients WHERE type='1' ORDER BY name
I've created an index for the "clients" table just above the "type" field.
Will adding an ORDER BY over an unindexed field affect query response...
Colleagues, how would you make a Word proposal registered within MySQL, and could it be edited? I tried to use the wysiwyg editors to place and paste, however the Word HTML, after saving, MySQL does not recognize.
Solved. I had put the...
I'm working with the following tables:
CREATE TABLE livro
( Id_livro int NOT NULL,
Nome_livro CHAR(40) NOT NULL,
Pg int,
Edicao int,
Editora int NOT NULL,
Assunto int NOT NULL,
Preco decimal (5,2) NOT...
I'm learning how to work with MySQL and I'm looking at some examples of how to work with more than one table, as an example below:
Id Nome Faculdade_id
101 Amanda 11
102 Bianca 12
103 Carla 13
104 Da...
I'm in a project, which I need to make some changes exactly inside the Wordpress panel. More specifically on a page that lists a specific post list.
I need to add a custom search field with a specific field.
I also need to add a few more c...