Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

MySQL Orderby a number, Nulls last

Currently I am doing a very basic OrderBy in my statement. SELECT * FROM tablename WHERE visible=1 ORDER BY position ASC, …

mysql sql-order-by
How can I import data into mysql database via mysql workbench?

I created a database in mysql. I have a .sql file. how can i import it into my database via …

mysql mysql-workbench
Simple Random Samples from a Sql database

How do I take an efficient simple random sample in SQL? The database in question is running MySQL; my table …

mysql sql postgresql random
How to get all privileges back to the root user in MySQL?

I am using MySQL. My root user doesn't have all privileges. How can I get all privileges back to the …

mysql privileges
Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

I installed MySQL community server 5.7.10 using binary zip. I extracted the zip in c:\mysql and created the data folder …

mysql mysql-5.7
Is it a good idea to index datetime field in mysql?

I am working on designing a large database. In my application I will have many rows for example I currently …

mysql indexing
No connection could be made because the target machine actively refused it (PHP / WAMP)

Note: I realise this could be seen as a duplicate but i have looked at the other responses and they …

mysql zend-server
Inserting NOW() into Database with CodeIgniter's Active Record

I want to insert current time in database using mySQL function NOW() in Codeigniter's active record. The following query won't …

php mysql codeigniter
How to select data where a field has a min value in MySQL?

I want to select data from a table in MySQL where a specific field has the minimum value, I've tried …

mysql sql aggregate-functions greatest-n-per-group
Fixing broken UTF-8 encoding

I am in the process of fixing some bad UTF-8 encoding. I am currently using PHP 5 and MySQL. In my …

php mysql unicode utf-8