Answer Posted / boobalan

Float is data type which holds the 8 bytes memory to
holds the floating values even if we give the values in
integer(4)it takes as float(4.0).
Double is also same to the float that is also takes 8
bytes main purpose is to holds the long values of varible
(example:phone no),thank you.......

all the queries used in sql

2154

---

What is row level locking?

500

---

what is constraints? Also explain the different types of constraints?

524

---

What is username in mysql?

484

---

How do I edit a table in mysql workbench?

443

---

---

What's new in mysql 8?

565

---

How to declare variable in mysql trigger?

488

---

How can you filter the duplicate data while retrieving records from the table?

478

---

What is logs in mysql?

492

---

How to upload a large file through phpmyadmin in mysql?

434

---

If we use sum function in mysql, does it return sum of that row or for that column?

531

---

Write a command to list all databases in mysql?

533

---

How do you rename a table in mysql?

510

---

How do I change mysql password?

495

---

How do stored procedures work?

487

---