Cover Image
Cover Image
Drag to reposition
Contributed Questions
mkotla, asked 25m 39s ago
I have created a stored procedure and now I want to delete that particular stored procedure. Which statement do I need to use to delete or drop that procedure?
mkotla, asked 37m 3s ago
I want to create a MySQL stored procedure that executes a block of SQL code repeatedly having the additional benefit of having loop label. How can I create such kind of procedure by using a loop construct based on LOOP loop?
mkotla, asked 2h 58m ago
I want to write a stored procedure in MySQL. Are there any basics which I must have to know about before writing and using the same?
mkotla, asked 4h 25m ago
Is it possible to make a new MySQL database with the help of mysqladmin?
mkotla, asked 20h 49m ago
I want to get the list of MySQL databases stored in MySQL server. Is there any other statement rather than SHOW DATABASES to get that list?
mkotla, asked 20h 51m ago
I want to know about OPTIMIZE TABLE statement and how it would be helpful in maintaining the tables stored in MySQL database.
mkotla, asked 21h 57m ago
Is there any command in MySQL to get the information about MySQL server that it is alive or not?
mkotla, asked 1d 2h ago
While bringing the value from a text file into MySQL table I want to store the changed value in the column. How should the query be written?
mkotla, asked 1d 22h ago
I want to store variable-length character data in a MySQL table. How much such data I can store in a table?
mkotla, asked 1d 22h ago
I am using STR_TO_DATE() function and passing a value like ‘20172810’ along format specifies like '%Y,%d%m' as an argument but getting NULL as the output. Why is it so?