Mysql - prac questions

  1. What is Sharding in SQL
  2. How do you view a database in MySQL. How do you use certain database in sql? For Eg:- name of database is “TEST”. Please write commands of the same.
1 Like
  1. Sharding in SQL is a technique that horizontally partitions a database across multiple servers to improve scalability and performance.
    ( 1. Sharding is storing large database accross multiple machines)
  2. show databases, use database_name, use test
1 Like
  1. Sharding is a method for distributing a single database across multiple databases.
  2. show databases,use databases-name, use test
1 Like
  1. Sharding is a method for distributing a single dataset across multiple databases, which can be stored on multiple machines.
  2. mysql -u root -p command, use database_name, use test
1 Like
  1. Sharding is storing large database accross multiple machines
  2. show databases,use database_name, use test
1 Like

1 sharding in sql is a database partitioning technique that involves splitting a database into smaller, more manageable piece called shards
2 1. mysql -u root -p command, use database_name, use test

1 Like