I'm using MYSQL to show some data on my site ... But some data is in lowercase, and I need the first letter to be in Capital.
But I do not know how to do this using variable ... I need the data of my variable "$name" to be with the f...
I'm doing the following query:
SELECT SEC_TO_TIME(sum(Total_Segundos_Consumidos)/count(distinct IDTRANSACTIONS)) AS 'Tempo Médio'
FROM
(SELECT IDTRANSACTIONS,
SUM(TIME_TO_SEC(TimeDiff(TIME_FORMAT(DATEFIM,'%H:%i'),...
I am setting up a job agency website and I have a search that looks in the field title and description, what the person searched, as per the query below:
SELECT *
FROM vagas
WHERE (titulo LIKE '%termo_de_busca%' OR observacoes LIKE '%termo_de_...
I need to work with encryption in MySQL and I need to use base64 because I hear that MD5 has a small failure that allows you to have two different passwords with the same MD5.
I need to encrypt and decrypt.
insert into scl_usuario (logi...
Hello! I have the following database:
I would like to make an appointment where I can search for example the teacher x that is related to the student y and z but not the student w. However when executing my queries it displays the teach...
I need to have the most repeated record appear in the tipo_doenca column from the localidade column, which is to display the disease that is in the greatest amount in that location.
Table name: TB_grafico
I would like a help to make the SQL according to the data of this figure.
What I know is that if I send AND to all characteristics and one of them returns false or erro all SQL is compromised.
I thought about doing thi...
$termos = (explode('/', implode('/', $_GET['tipo'])));
print_r($termos);
Array
(
[0] => CASA
[1] => CASA EM CONDOMINIO
[2] => COBERTURA
)
I'm having a syntax error in this SQL that makes loops to add as many terms as need...
In my project I have a function in which I search all elements of the database and still causes "categoria_id" to become "categoria_nome" requesting the field in another table, however when I try to use this select I again...
I have a course management system where the user has access to a table with all classes of all courses and chooses to enroll in one.
When the user is going to register, he / she will open a form with the fields that he / she must fill out and...