How do I add multiple records at once in MySQL by passing an array of, for example, products?
HTTP-POST request, where products is an array with an x number of products.
FRONT-END
addProduct(products: any): Observable<any> {
ret...
I have the following SQL :
SELECT id,titulo,slug,endereco
FROM empresas
WHERE
(categoria = ".$_GET['id']." OR categoria_2 = ".$_GET['id']." OR categoria_3 = ".$_GET['id'].") AND (status = '1') ORDER BY chave DESC, RAND()
But it does not s...
Hello, I'm having problems with a query, and I need to bring only the last record of each id_face that has in the imagens table, but for some reason it's causing id_faces duplicates
Follow my query:
SELECT
DISTINCT(...
I'm trying to connect remotely to a mysql in google cloud, but I can not. in google I created a vm Ubuntu, last version, this is my ip,
It'susuallydripping: Iconfiguredthefirewallasfollows: configureinoiptables: settbomy.cnf: Iranthecommandnamp...
In that upload code. The class uploads an audio. Everything works fine, but, I do not know how to do that "identifies" and "id_user" can manage the upload and restrict to only when those two are different or is "empty", the upload is done. There...
I have a considerable problem:
- I want to list a search for a function that counts.
I want it to be displayed by the value of notifications
Thenotificationcountismadefromthefollowingcode:functioncount_reports_where_id($conn,$id){//$cmd="SELECT...
I have some problems with identifying special characters in the database. I do the UTF-8 decoding in the database:
ALTER DATABASE biblioteca CHARACTER SET utf8 COLLATE utf8_unicode_ci;
And also in HTML:
<meta http-equiv="Content-Type"...
To register the games of a football league the following tables have been defined:
Time (
id int primary key,
nome char(20),
pontos int,
nroVitorias,
golsMarcados int,
golsSofridos int )
Jogo (
idTime1 int,...
Hey guys, I'm setting up a football club management system just to practice and in that a doubt arose, I have the following eloquent:
$matches = DB::table('ut_tickets AS TIC')
->select('TIC.id', 'STA.name AS stadium', 'CLM.name AS club_...