1. Date and Time Data Types: a) DATE: create table student( id int(10) primary key auto_increment, name varchar(20) not null, date_of_birth date // Date datatype column ); insert into student(name,date_of_birth)values('Jahid','1990-01-21'); // d...

1. What are MySQL clients? Answer: The MySQL server is used to persist the data and provide a query interface for it (SQL). The mysql clients purpose is to allow you to use that query interface. The client package also comes with utilities that allows you to easily backup/restore data and ad...

Dumping from a localhost database Dump: mysqldump -u <db_username> -p db_name table_name > table_name.sql Restore: mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or mysql> databasename tableName < path/example.sql Dumping from a r...

About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. This can helpful for many reasons including facilitating a backup for the data,a way to analyze it wi...

Q1. Why we use triggers?

Answer:

• Audit trails : Executing additional insertion can be done automatically with a trigger. • Validation: You can use triggers to validate data before updating the database. • Referential integrity enforcement: it occasionally may make sense to use trigge...

Q1. Why we use triggers? Q2. Write down five limitations of MySQL's trigger. Q3. Create insert,update,delete triggers with appropriate after and before clause on user table Q4. How can you display triggers you have created? Q5. How can you modify trigger? Q6. Write Before triggers vs. After ...

Q1. Write advantages and disadvantages of stored routines. Advantages: 1. Consistency 2. Performance 3. Security 4. Architecture Disadvantages: 1. Performance 2. Capability 3. Maintainability 4. Portability Q2. Classify MySQL stored routines. 1. Stored Procedures: Stored proced...

01. Create a user name jone@localhost with the following privilege : all privilege mysql> grant all privileges on test.* to jone@localhost; Query OK, 0 rows affected (0.00 sec) 02.Set new password to jone@localhost like demo mysql> set password for jone@localhost=password('kasem�...

MYSQLi ডাটাবেজে কি দশমিক সহ সংখ্যা ( যেমন 10.109 ‍এরকম সংখ্যা ) রাখা সম্ভব্? যদি সম্ভব হয় তাহলে টেবিল তৈরী করার সময় কলাম টাইপ কি দিলে ডাটাবেজে দশমিক(.) সহ যে কোন সংখ্যা রাখা যাবে?...

ALTER TABLE `table` DROP `id`; ALTER TABLE `table` AUTO_INCREMENT = 1; ALTER TABLE `table` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; ...