Do you mean query written by you?
If you want to do it without query, then with what?
Can i do mysql in visual studio?
thank you for your note, but I take a photo from the tables from designer in phpmyadmin to make it easy to see the table structure and I write two tables with some dummy data to explain what I need?
By the way, do you write a similar posts on SO or QNA-habr?
Are you sure it is the correct query?
DBeaver, can you read ?
I already, but asked so i will told
Do you mean query written by you? Or generally without query
There are many other tools like this, Squirell, DBeaver, Navicat, many.
Generally
You can not get data without query
Ask your questions in details, because noone can understand what you ask
It is the same like if you would write messages to chat without telegram client
Don’t send pictures if you can send text
It is still unclear
What is it? Unclear
there is no such tool
Whom ability?
dbeaver, sqlyog, heidisql, navicat… many of them. if you want to create a tool like that consider to discuss your ideas/requirements in development chats
9705910889
Clarification required
Hello everyone, I am building attendant system, and I have two tables (students- attend)
So, all the students will be registered in student table let’s say we only have five students as shown in photo.
When the student signed in, he/she will be inserted to attend table as showed in the photo and the word present will be written under attend table head.
But I want when I click a button after the class finish to insert the rest of the student that didn’t sign in in this case (Sara and Zain) to attend table with the word absent. How I can do that.
Thank you
An online SQL database playground for testing, debugging and sharing SQL snippets.
Please, read the description of our group where it is clear — “Ads/Vacancies aren’t allowed.”
We know, that website is yours and to say people what they need to use to present their data seems for me a bit strange.
It looks like help but your affiliation with own website seems like advertisement.
We follow free speech in our devchats but in the same way we don’t want to see advertisement here.
> When I ask for tables and sample data for this fiddle, I just want to provide the best solution for whoever asked for help.
It looks like promoting and advertisement. Better to ask people to use internal Telegram’s feature to highlight code.
Dura lex, sed lex.
Next time it will be regarded as an advertisement and you will be banned permanently.
So, all the students will be registered in student table let’s say we only have five students as shown in photo.
When the student signed in, he/she will be inserted to attend table as showed in the photo and the word present will be written under attend table head.
But I want when I click a button after the class finish to insert the rest of the student that didn’t sign in in this case (Sara and Zain) to attend table with the word absent. How I can do that.
Thank you
I wrote this query and when I execute it, doesn’t insert anything to the attend table:
$q = INSERT INTO attend SELECT id, fullName, number, ‘absent’, ‘curdate()’
FROM student
WHERE id NOT IN (SELECT stu_id FROM attend WHERE day_date = ‘curdate()’)”;
curdate = the current date because I inserted date with current date and system will take the attendant once every day.
$q = INSERT INTO attend SELECT id, fullName, number, ‘absent’, ‘curdate()’
FROM student
WHERE id NOT IN (SELECT stu_id FROM attend WHERE day_date = ‘curdate()’)”;
curdate = the current date because I inserted date with current date and system will take the attendant once every day.
It seems you have too much quotes. Are you sure it is the correct query?