good morning, my question is this, I'm experimenting with database, and I have only 1 record in the database and I show it by the following:
SELECT * FROM tabla
very well, following this shows me only the record I have, how do I repeat that...
My database is designed in such a way that the insertion of dates is under the format years / months / days and when sending the content of that control by means of c # to the database, I do not know of the appropriate sentence for convert it an...
I want to count the last records when they meet that:
its estado equals 1
if the usuario_id equals 5, and
the test_id equals 1
The maximum number of records to count is only 3.
These records I have in a table w...
How can I change the format that a date is displayed:
To show the dates of a table, they are shown as follows:
2016-06-28
2016-06-29
2016-07-01
2016-07-03
And I wanted to change that sample format for one like this:
2016, 06,...
I have a table in mysql of name Contracts who has the sig. structure:
----------------------
|id|nombre |fecha |
----------------------
|1 |Emp1 |2015-02-12|
-----------------------
|2 |Emp2 |2016-02-11|
-----------------------...
I am working with Highcharts and I am showing information from my database in the following way:
data: [<?php
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "[Date.UTC("...
I am using AWS and I have just installed mysql in an EC2 environment with ubuntu 14, I have created my root user with which I can connect via SSH normally, but I have created another user with grant all privileges so that another person can uplo...
As the title says, this is in java EE , particularly java web. However, it is a simple% SQL query:
I have a table with several data, and a id autoincremental:
id, date, text.
I use a servlet to add an element to the da...
I am new to the forum, it has helped me so much so far. But now I can not find a solution for the following:
I have a table in MySQL called "events" and another one called "vehiculos", the application I'm designing is for reserving vehicles w...