← prev | next →
Sandeep_ranweer 2021-09-15 19:44:28
No…
Sandeep_ranweer 2021-09-15 19:44:37
The data needs to be there
Sandeep_ranweer 2021-09-15 19:44:43
Like for emaill
Sandeep_ranweer 2021-09-15 19:44:51
****@gmail.com
MasterZiv 2021-09-15 19:45:39
Well, this tsk is just to do some queries and that is it.
Sandeep_ranweer 2021-09-15 19:46:17
MasterZiv 2021-09-15 19:45:39
Well, this tsk is just to do some queries and that is it.
How do I mask the data
Sandeep_ranweer 2021-09-15 19:46:21
With c++
MasterZiv 2021-09-15 19:49:34
Sandeep_ranweer 2021-09-15 19:46:17
How do I mask the data
Same way you do other queries
MasterZiv 2021-09-15 19:50:07
Sandeep_ranweer 2021-09-15 19:39:30
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;
}
Like here
You even have updates there
ColonelMustang 2021-09-16 09:02:08
I have a database D1 in which I have a table T1. D1 also has a stored procedure S1 which operates on T1
Now I want to move the table T1 from D1 to D2. Is there a way to keep both the data in D1.T1 and D2.T2 in sync even when S1 works on both D1 and D2?
MasterZiv 2021-09-16 10:04:02
ColonelMustang 2021-09-16 09:02:08
I have a database D1 in which I have a table T1. D1 also has a stored procedure S1 which operates on T1
Now I want to move the table T1 from D1 to D2. Is there a way to keep both the data in D1.T1 and D2.T2 in sync even when S1 works on both D1 and D2?
Create view
MasterZiv 2021-09-16 10:04:54
ColonelMustang 2021-09-16 09:02:08
I have a database D1 in which I have a table T1. D1 also has a stored procedure S1 which operates on T1
Now I want to move the table T1 from D1 to D2. Is there a way to keep both the data in D1.T1 and D2.T2 in sync even when S1 works on both D1 and D2?
There are no actually databases in mySQL, those are schemes
R 2021-09-16 10:05:33
I want to know if there is a list of frequently performed operations on the database.
Me 2021-09-16 10:12:39
Does anybody took fractal sql and aptitude test recently..?
ColonelMustang 2021-09-16 10:22:10
MasterZiv 2021-09-16 10:04:54
There are no actually databases in mySQL, those are schemes
Oh TIL
ColonelMustang 2021-09-16 10:22:25
MasterZiv 2021-09-16 10:04:02
Create view
View is read only afaik. I need both to be writable
MasterZiv 2021-09-16 10:31:25
ColonelMustang 2021-09-16 10:22:25
View is read only afaik. I need both to be writable
No, there’s possibility for a view to be updatable. But don’t know how it is in mySQL
MasterZiv 2021-09-16 10:32:35
ColonelMustang 2021-09-16 10:22:25
View is read only afaik. I need both to be writable
At last, don’t move the table to another scheme there is little use in it
ColonelMustang 2021-09-16 10:49:48
MasterZiv 2021-09-16 10:32:35
At last, don’t move the table to another scheme there is little use in it
I actually want to migrate the table to a different server/machine altogether decoupling from the current schema
MasterZiv 2021-09-16 10:51:00
ColonelMustang 2021-09-16 10:49:48
I actually want to migrate the table to a different server/machine altogether decoupling from the current schema
Next time you’ll say you want to fly to the moon
ColonelMustang 2021-09-16 10:51:36
but what’s the problem with the current thing I’m doing?
svart 2021-09-16 11:08:50
ColonelMustang 2021-09-16 10:49:48
I actually want to migrate the table to a different server/machine altogether decoupling from the current schema
Just setup the replication between these two servers and on the slave add replication filter
ColonelMustang 2021-09-16 11:18:44
svart 2021-09-16 11:08:50
Just setup the replication between these two servers and on the slave add replication filter
can you explain? a link would be helpful
Ishu Gupta 2021-09-16 19:44:33
What is clustering in Mysql????
Nalin Kumar 2021-09-20 13:01:34
Can you please help me to setup incremental backup in crontab in MySql
piterden 2021-09-20 21:01:16
Nalin Kumar 2021-09-20 13:01:34
Can you please help me to setup incremental backup in crontab in MySql
What is unclear for you?
Nalin Kumar 2021-09-20 21:07:16
Can you Please help to schedule the backups through crontab via backup shell script, Full backup followed by Incremental every day.
piterden 2021-09-20 21:11:09
Nalin Kumar 2021-09-20 21:07:16
Can you Please help to schedule the backups through crontab via backup shell script, Full backup followed by Incremental every day.
How much will you pay?
2021-09-20 23:08:40
Nalin Kumar 2021-09-20 21:07:16
Can you Please help to schedule the backups through crontab via backup shell script, Full backup followed by Incremental every day.
Inbox.
Me 2021-09-21 12:24:47
Write a SQL statement to find the the managers of employees supporting Brazilian customers
Me 2021-09-21 12:25:05
Me 2021-09-21 12:24:47
Write a SQL statement to find the the managers of employees supporting Brazilian customers
Can someone help me with this
MasterZiv 2021-09-21 13:49:42
Me 2021-09-21 12:25:05
Can someone help me with this
It is just a series of joins.
MasterZiv 2021-09-21 13:51:33
Me 2021-09-21 12:25:05
Can someone help me with this
Employee join employee join customer
Where customer. country = ‘Brasil’
PrinceRoddy 2021-09-21 21:02:49
Hello,, how can I get MySQL into my laptop, got an assignment
← prev | next →