Database Archives - Page 37 of 44

How can I see the list of the stored procedures or stored functions in mysql command line like show tables; or show databases; ...

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8? 20 s 20 Use the ALTER DATABASE and ALTER ...

By default, mysqldump takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How ...

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

Is there any query/way to show the last queries executed on ALL servers? 10 s 10 For those blessed with MySQL >= 5.1.12, ...

I am having some problems when trying to install mysql2 gem for Rails. When I try to install it by running bundle install ...

Is there a nice easy way to drop all tables from a MySQL database, ignoring any foreign key constraints that may be in ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

How can I best write a query that selects 10 rows randomly from a total of 600k? 28 s 28 SELECT column FROM ...

In another question I posted someone told me that there is a difference between: @variable and: variable in MySQL. He also mentioned how ...