I have 2 tables
account1 and account2
account1 with the columns [account_code1] and [account_name1]
account2 with the columns [account_code2] and [account_name2]
I need your help to show the data of account1 and account2 in the select...
How I want to enter the MySQL workbench or open the server from cmd
mysql -u root -p and when I enter the password it tells me
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using
password: YES)
I have a problem with the following query
SELECT h.sexo,
h.universidad,
count(*) as TOTALES,
SUM(CASE WHEN h.universidad = 'Latina' THEN 1 ELSE 0 END) AS number,
SUM(CASE WHEN h.universidad = 'UAM' THEN 1 ELSE...
I bring you another little problem that came up during my project (which is almost finished already). What this code is supposed to do is create a new "Artist" row, add it to the dataset (in its datatable) and update the database.
Well, it's cle...
Good, I have a sales form, more or less finished.
In that form I have a table that adds dynamic rows extracted from another table in a modal.
$('.a').on('click',function(){
var trPrincipal = this.offsetParent.parentElement; //Buscamo...
I try to display information from the total column of my database with the following DEMO :
link
This is the table I want to work with:
But I do not know how it works. It is the first time that I am working with Highcharts, a...
Hi, I'm designing a sales database.
But I have a problem. I need that when inserting data in my table, it looks like this:
Table detail_sales
Now, the id of my sale_file has to travel to my sale table as a foreign ke...
Good I have this query but it does not return anything to me, only it returns to me when all the data are complete, if only I put a city does not return nothing try to thunder the query but even so it does not return anything, as q does not ente...
Good I have the following doubt I have the following functions PHP in a file, the thing is that I want that by pressing a button (delete) the function is called delete and delete the record.
How can you do that without calling a funcio...
Hello, how are you? I bother you with a question?.
I decided to group products according to the subcategory (id_subcate) but when accessing the Category (id_cate)
I start from the base, as well comments and made me realize @amenadiel,
...