How we know that the table has been created?

|
Raj Varma 2022-09-08 15:22:00
Data base ,mysql , pl sql and oracle offline support is available
Task base also we will do
jordifnz 2022-09-08 16:37:22
Hi all!
I’m trying to define a synced environment between 2 MySQL 8.0.29 servers, but I’m not sure how can I do it:
1) There’re 2 methods: classic and transaction?
2) Classic method is master -> slave way or slave asks to master?
3) By your experience, what’s the best method?
4) Do you have any manual to follow? I’m only finding documents that explain an overview, not in dept (step by step)
gean kadu 2022-09-08 18:38:08
Hi everyone, If you lost money in crypto market in the past 1 yr, do you want to cover your lose in the next Bull market? I just found a ex platform: MC900 – one of the best Crypto exchange, has the a professional trading instructors’ team to help all users to give trading signals for free, and share a series of crypto trading methods and operation strategies for free to help group memebers to recover damages.The most important thing is that we share at least one secret crypto that we think has mostly bull potiential from time to time every month! Want to get more info? Just contact him via the link👉👉: @MC900official

💎🤑☝️😍👉💎🤑☝️😍👉

Ishu Gupta 2022-09-08 18:46:05
Hi need one help i am taking MySQL Meb backup in compressed form the size is around 400GB shall I compressed it more and how can we do it
Ishu Gupta 2022-09-08 18:46:19
Can anyone help me on above
Ishu Gupta 2022-09-08 18:49:30
Guys please update
Appu0502 2022-09-08 18:54:02
How to write a query in mysql to get top3 product names which got sold
Shroff_azago 2022-09-08 19:49:38
Appu0502 2022-09-08 18:54:02
How to write a query in mysql to get top3 product names which got sold

Limit 3 order by sold Desc

Sachet Adhikari 2022-09-08 21:51:22
Hlo
Sachet Adhikari 2022-09-08 21:52:00
How to create a table in MYSQL??
Sachet Adhikari 2022-09-08 21:53:10
How we know that the table has been created ??
Cobrapeace 2022-09-08 21:53:40
Sachet Adhikari 2022-09-08 21:52:00
How to create a table in MYSQL??

do you want to use an application or command line prompt?

Sachet Adhikari 2022-09-08 21:53:52
Cobrapeace 2022-09-08 21:53:40
do you want to use an application or command line prompt?

Yess

Cobrapeace 2022-09-08 21:54:56
Sachet Adhikari 2022-09-08 21:53:52
Yess

have you downloaded the workbench?

Sachet Adhikari 2022-09-08 21:55:06
Cobrapeace 2022-09-08 21:54:56
have you downloaded the workbench?

Yess

Cobrapeace 2022-09-08 21:57:33
Sachet Adhikari 2022-09-08 21:55:06
Yess

type show tables

Cobrapeace 2022-09-08 21:59:16
mysql_en-24781.jpg
at the schema section, u will see all the tables created
Sachet Adhikari 2022-09-08 21:59:50
Cobrapeace 2022-09-08 21:59:16
mysql_en-24781.jpg
at the schema section, u will see all the tables created

I have Windows 11

Cobrapeace 2022-09-08 22:00:19
if u cannot see your schema, click on VIEW at the toolbar, and select show SIDE MENU
Sachet Adhikari 2022-09-08 22:00:30
Ok
Cobrapeace 2022-09-08 22:01:04
Sachet Adhikari 2022-09-08 21:59:50
mysql_en-24781.jpg
I have Windows 11

it doesnt matter, cos I am also using Win 11

Sachet Adhikari 2022-09-08 22:07:17
Cobrapeace 2022-09-08 22:01:04
mysql_en-24781.jpg
it doesnt matter, cos I am also using Win 11

Ok

Sachet Adhikari 2022-09-08 22:07:37
So what can we do next ??
Cobrapeace 2022-09-08 22:08:41
it depends on what u want to do with it
Cobrapeace 2022-09-08 22:09:09
Sachet Adhikari 2022-09-08 22:07:17
mysql_en-24781.jpg
Ok

but i suggest you watch videos about how to use the bench

Cobrapeace 2022-09-08 22:33:39
Sachet Adhikari 2022-09-08 22:07:37
mysql_en-24781.jpg
So what can we do next ??

I hope my answers helped

Senthil 2022-09-08 23:05:18
Senthil:
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377” was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
B. The cluster is running and there is at least one ONLINE instance.
C. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance(‘host1:3377’).
D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
E. The active session instance is invalid and must be re-created by using the command shell.connect(‘host3:3377’).

Any inputs pls?

Appu0502 2022-09-09 07:35:05
How to write query in mysql to get which country has highest sales
P M 2022-09-09 07:38:55
Appu0502 2022-09-09 07:35:05
mysql_en-24781.jpg
How to write query in mysql to get which country has highest sales

Select country, max(sales)
From table

P M 2022-09-09 07:39:21
Are store procedures stored seperately for every database?
Racky Ram 2022-09-09 09:39:32
How to joines create table 2 joining
Racky Ram 2022-09-09 09:39:42
Table
Racky Ram 2022-09-09 09:41:38
How to table
CHANDRA PRASATH R 2022-09-09 12:43:11
Please send the MySQL notes
SANATH 2022-09-09 20:39:52
I need to dump the query given by developer from one server database to the other server database every 15 mins….. please try to help me to solve this…. Thanks in advance
|