QUESTIONS INTERVIEW.IN

Sign Up | Sign In

Post a Question

Asked Questions

Interview Questions

- Computer Language

- Computer Database

- Data Structure

- Certifications

- Cost Accounting

- Common Interview Questions

Home >> Computer Database >> Mysql

Question

View Answer

=> How do you get the month from a timestamp?

=> What does + mean in REGEXP?

=> What do % and _ mean inside LIKE statement?

=> How do you convert a string to UTF-8?

=> Whatâ€™s the difference between CHAR_LENGTH and LENGTH?

=> How do you get a portion of a string?

=> How do you concatenate strings in MySQL?

=> When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?

=> How would you change a table to InnoDB?

=> How would you delete a column?

=> How would you change a column from VARCHAR(10) to VARCHAR(50)?

=> How can you see all indexes defined for a table?

=> When would you use ORDER BY in DELETE statement?

=> On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?

=> What does â€“i-am-a-dummy flag to do when starting MySQL?

=> How do you find out which auto increment was assigned on the last insert?

=> What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id) ?

=> How would you select all the users, whose phone number is null?

=> How would you write a query to select all teams that won either 2, 4, 6 or 8 games?

=> You wrote a search engine that should retrieve 10 results at a time, but at the same time youâ€™d like to know how many rows thereâ€™re total. How do you display that to the user?

Page: 2 3 4 5 6 7 8

Last

Latest Mysql Interview video

Latest Topic

How to Import sqlserver data to mysql?

Uncaught TypeError: extract(): Argument #1 ($array) must be of type array, null given

Fatal error: Uncaught TypeError: extract(): Argument #1 ($array) must be of type array

HTTPS is invalid and might prevent it from being indexed

Deprecated: Required parameter $sql follows optional parameter $name in

Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null

Your account isn’t eligible for the Google Workspace Individual plan