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?

|
MasterZiv 2022-01-17 17:00:28
2022-01-17 17:00:09
I want tool which can run views of mysql database without query

DBeaver, can you read ?

2022-01-17 17:01:01
piterden 2022-01-17 16:59:38
What thing?

I already, but asked so i will told

piterden 2022-01-17 17:01:06
2022-01-17 17:00:09
I want tool which can run views of mysql database without query

Do you mean query written by you? Or generally without query

MasterZiv 2022-01-17 17:01:12
2022-01-17 17:00:09
I want tool which can run views of mysql database without query

There are many other tools like this, Squirell, DBeaver, Navicat, many.

2022-01-17 17:01:41
piterden 2022-01-17 17:01:06
Do you mean query written by you? Or generally without query

Generally

piterden 2022-01-17 17:02:05
2022-01-17 17:01:41
Generally

You can not get data without query

MasterZiv 2022-01-17 17:02:28
2022-01-17 17:01:41
Generally

Ask your questions in details, because noone can understand what you ask

2022-01-17 17:02:44
Wait for minute
piterden 2022-01-17 17:02:58
2022-01-17 17:01:41
Generally

It is the same like if you would write messages to chat without telegram client

piterden 2022-01-17 17:04:27
The main principle of RDBS is interaction through queries
piterden 2022-01-17 17:05:01
If you want to do it without query, then with what?
piterden 2022-01-17 17:05:42
How are you going to say to DB: “Give me that”
2022-01-17 17:06:49
mysql_en-16061.jpg

2022-01-17 17:07:00
Here is what i want to do
MasterZiv 2022-01-17 17:07:25
2022-01-17 17:07:00
Here is what i want to do

Don’t send pictures if you can send text

2022-01-17 17:07:42
Ok sorry
MasterZiv 2022-01-17 17:08:07
2022-01-17 17:07:00
Here is what i want to do

It is still unclear

piterden 2022-01-17 17:08:15
2022-01-17 17:07:00
Here is what i want to do

What is it? Unclear

2022-01-17 17:10:14
I want tool that controls like able to view and export and block ability to run queries
MasterZiv 2022-01-17 17:12:37
2022-01-17 17:10:14
I want tool that controls like able to view and export and block ability to run queries

there is no such tool

piterden 2022-01-17 17:21:01
2022-01-17 17:10:14
I want tool that controls like able to view and export and block ability to run queries

Whom ability?

svart 2022-01-17 17:35:42
2022-01-17 17:10:14
I want tool that controls like able to view and export and block ability to run queries

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

Larry 2022-01-17 20:44:21
Can i do mysql in visual studio?
Srinivas M 2022-01-17 20:46:53
Required MySQL development who are strong communications people
9705910889
svart 2022-01-17 21:09:03
Larry 2022-01-17 20:44:21
Can i do mysql in visual studio?

Clarification required

dev 2022-01-17 21:44:18
mysql_en-16082.jpg
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

dev 2022-01-17 21:49:11
I showed all the info in the photo and I believe it is clear
dev 2022-01-17 21:58:30
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?
piterden 2022-01-17 22:33:08
If be honest, your sandbox is less comfortable than his screenshot. Could you please propose people to use more convenient tool like https://www.db-fiddle.com/ or https://dbfiddle.uk/ ?

DB Fiddle – SQL Database PlaygroundDb-Fiddle
An online SQL database playground for testing, debugging and sharing SQL snippets.
smlkw 2022-01-17 22:42:51
Hello.

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.

smlkw 2022-01-17 23:49:00
I have seen your tool and understand what this is and for which purpose you have created it.

> 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.

piterden 2022-01-17 23:55:26
By the way, do you write a similar posts on SO or QNA-habr?
dev 2022-01-18 03:14:55
dev 2022-01-17 21:44:18
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

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.

piterden 2022-01-18 03:20:00
dev 2022-01-18 03:14:55
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.

It seems you have too much quotes. Are you sure it is the correct query?

dev 2022-01-18 03:20:56
Yeah I forgot the quote after = sign
|