Guys how can i pass this error in mysql?

|
piterden 2021-09-13 09:34:57
Anjuman Nehal 2021-09-13 09:33:42
Can anyone pls help me on this ?

What is unclear for you?

MasterZiv 2021-09-13 09:36:58
ruydar 2021-09-13 09:26:41
Which operating system is more stable and faster

it is all same

thanosphan 2021-09-13 22:26:31
Anjuman Nehal 2021-09-13 09:33:42
Can anyone pls help me on this ?

If I didn’t understand it wrong, you will have to self join and do a distinct. Though I wonder if a join on bookings table is required to be considered as a successful recommendation. Sample output will help here

coincap360admin 2021-09-14 09:04:53
mysql_en-12689.jpg
Hello
Guys how can i pass this error in mysql?
Anjuman Nehal 2021-09-14 13:32:35
thanosphan 2021-09-13 22:26:31
If I didn’t understand it wrong, you will have to self join and do a distinct. Though I wonder if a join on bookings table is required to be considered as a successful recommendation. Sample output will help here

I am not clear how to run query for this

Anjuman Nehal 2021-09-14 13:33:19
Recommendations part is not clear for me
MasterZiv 2021-09-14 13:54:37
Anjuman Nehal 2021-09-14 13:33:19
Recommendations part is not clear for me

Send us your variant, we will check it!

MasterZiv 2021-09-14 13:57:44
coincap360admin 2021-09-14 09:04:53
Hello
Guys how can i pass this error in mysql?

This is code written on Python. Python is not the topic of the chat.
The chat is about MySQL.

You have error message telling you that the table you query is NOT IN YOU DATABASE, there is no such table.
What is unclear to you ?

TechGuyHelp 2021-09-15 02:25:59
hi guys. just wonder how to use free mysql database service. anyone can be of help? thanks
piterden 2021-09-15 02:43:25
TechGuyHelp 2021-09-15 02:25:59
hi guys. just wonder how to use free mysql database service. anyone can be of help? thanks

What service do you mean?

Generally you need the personal computer or server where you should install MySQL RDBMS

MasterZiv 2021-09-15 06:06:42
TechGuyHelp 2021-09-15 02:25:59
hi guys. just wonder how to use free mysql database service. anyone can be of help? thanks

Use it as a database management system

Amit Kumar 2021-09-15 10:57:32
can someone pass interview ques and ans for mysql exp candidate
TechGuyHelp 2021-09-15 12:24:54
piterden 2021-09-15 02:43:25
What service do you mean?

Generally you need the personal computer or server where you should install MySQL RDBMS

i went to download page of mysql site, the server service software seems not free. i just figured great if there is a way to use it foc.

TechGuyHelp 2021-09-15 12:25:09
mysql_en-12723.jpg

MasterZiv 2021-09-15 12:28:29
TechGuyHelp 2021-09-15 12:24:54
i went to download page of mysql site, the server service software seems not free. i just figured great if there is a way to use it foc.

MySQL IS free.

MasterZiv 2021-09-15 12:29:00
TechGuyHelp 2021-09-15 12:25:09

this is apparently not vanilla MySQL

TechGuyHelp 2021-09-15 12:41:12
MasterZiv 2021-09-15 12:28:29
MySQL IS free.

do you have link to download it?

MasterZiv 2021-09-15 12:44:40
TechGuyHelp 2021-09-15 12:41:12
do you have link to download it?

https://dev.mysql.com/downloads/

TechGuyHelp 2021-09-15 13:06:49
tq bro 👍
Sandeep_ranweer 2021-09-15 18:55:57
Guys
Sandeep_ranweer 2021-09-15 18:56:12
I was asked to write a c++ program to mask database
Sandeep_ranweer 2021-09-15 18:56:31
Sandeep_ranweer 2021-09-15 18:56:12
I was asked to write a c++ program to mask database

I have connected visual studio with mysql

Sandeep_ranweer 2021-09-15 18:56:44
Sandeep_ranweer 2021-09-15 18:56:31
I have connected visual studio with mysql

Can amyone tell me what to do next

Sandeep_ranweer 2021-09-15 18:57:32
MasterZiv 2021-09-15 06:06:42
Use it as a database management system

Any idea

MasterZiv 2021-09-15 19:38:43
Sandeep_ranweer 2021-09-15 18:56:12
I was asked to write a c++ program to mask database

To what database?

Sandeep_ranweer 2021-09-15 19:38:56
My SQL database
Sandeep_ranweer 2021-09-15 19:39:05
MasterZiv 2021-09-15 19:38:43
To what database?

My SQL database

Sandeep_ranweer 2021-09-15 19:39:30
MasterZiv 2021-09-15 19:38:43
To what database?

int main(void)
{
cout << endl;
cout << “Masked values are” << “n”;
DisplayMasked();
cout << “n”;
cout << “n”;
cout << “UnMasked values are” << “n”;
cout << “n”;
DisplayUnmasked();
cout << “n”;
cout << “n”;
compute_alphabeticallyfirst();

return EXIT_SUCCESS;
try {
sql::Driver* driver;
sql::Connection* con;
sql::Statement* stmt;
sql::ResultSet* res;
sql::PreparedStatement* prep_stmt;

driver = get_driver_instance();
con = driver->connect(“tcp://localhost”, “root”, “27640822aC@”);

con->setSchema(“wrestling”);

stmt = con->createStatement();
res = stmt->executeQuery(“SELECT * from personal_info1”);
while (res->next()) {
sql::ResultSet* res1;
string name = res->getString(2);
reverse(name.begin(), name.end());
name = “*” + name + “*”;
string val = res->getString(2);

stmt->executeUpdate(“UPDATE personal_info1 SET Name = ‘”+ name+”‘ WHERE Name = ‘”+ val+”‘”);

stmt->execute(“COMMIT”);

}

delete res;
delete stmt;
delete con;

}
catch (sql::SQLException& e) {
cout << “# ER: SQL-Exeption in ” << FILE;

}

cout << endl;

return EXIT_SUCCESS;
}

MasterZiv 2021-09-15 19:39:43
Sandeep_ranweer 2021-09-15 19:39:05
My SQL database

What do you wanna do with the database?

Sandeep_ranweer 2021-09-15 19:39:59
MasterZiv 2021-09-15 19:39:43
What do you wanna do with the database?

I need to mask the database

Sandeep_ranweer 2021-09-15 19:40:13
But need to do it in c+(
Sandeep_ranweer 2021-09-15 19:40:17
C++
MasterZiv 2021-09-15 19:40:50
Sandeep_ranweer 2021-09-15 19:39:59
I need to mask the database

What is it “to mask the database”

Sandeep_ranweer 2021-09-15 19:42:10
MasterZiv 2021-09-15 19:40:50
What is it “to mask the database”

https://mysqlserverteam.com/data-masking-in-mysql/

MasterZiv 2021-09-15 19:44:09
Sandeep_ranweer 2021-09-15 19:42:10
https://mysqlserverteam.com/data-masking-in-mysql/

Ah you need to erase some data…

|