Top "Mysql" questions

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

WooCommerce: Finding the products in database

I'm creating a website using WooCommerce and I want to restrict the available products to users depending on the postcode …

mysql database wordpress woocommerce product
How to print exact sql query in zend framework ?

I have the following piece of code which i taken from model, ... $select = $this->_db->select() ->…

php mysql zend-framework zend-db
Pass array to MySQL stored routine

I need to pass an array of strings as parameter to a MySQL stored routine. The array could be long …

mysql arrays stored-procedures parameter-passing
Cannot find mysql.sock

I just had to re-install mysql and I am having a problem starting it up. It cannot find the socket (…

mysql macos sockets installation
MySQL "between" clause not inclusive?

If I run a query with a between clause, it seems to exclude the ending value. For example: select * from …

sql mysql between
how to sort order of LEFT JOIN in SQL query?

OK I tried googling for an answer like crazy, but I couldn't resolve this, so I hope someone will be …

mysql sql greatest-n-per-group
Why is a "GRANT USAGE" created the first time I grant a user privileges?

I'm new to the admin side of DBMS and was setting up a new database tonight (using MySQL) when I …

mysql database privileges grant
MySQL: Get column name or alias from query

I'm not asking for the SHOW COLUMNS command. I want to create an application that works similarly to heidisql, where …

python mysql mysql-python
How to insert pandas dataframe via mysqldb into database?

I can connect to my local mysql database from python, and I can create, select from, and insert individual rows. …

python mysql pandas mysql-python
What does collation mean?

What does collation mean in SQL, and what does it do?

sql sql-server-2005 tsql mysql