Top "Mysql" questions

How do you run a single query through mysql from the command line?

I'm looking to be able to run a single query on a remote server in a scripted task. For example, …

sql mysql unix command-line

How do I get SUM function in MySQL to return '0' if no values are found?

Say I have a simple function in MySQL: SELECT SUM(Column_1) FROM Table WHERE Column_2 = 'Test' If no entries in …

mysql function null sum

What are the differences between the BLOB and TEXT datatypes in MySQL?

What is blob and what is text? What are the differences? When do I need to use blob and when …

mysql database text blob

Install MySQL on Ubuntu without a password prompt

How do I write a script to install MySQL server on Ubuntu? sudo apt-get install mysql will install, but it …

mysql bash ubuntu apt

phpmyadmin "no data received to import" error, how to fix?

I am using XAMPP on a pc atwork to host a database. I exported a backup ("bintra.sql") using phpmybackuppro. …

mysql phpmyadmin xampp

phpmyadmin.pma_table_uiprefs doesn't exist

I searched the internet but cannot find anything related to this specific error/table. It pops up when I try …

mysql phpmyadmin

Inner join with 3 tables in mysql

I want to select data from more tables with Inner join. These are my tables. Student (studentId, firstName, lastname) Exam (…

mysql database inner-join

How to use mysql JOIN without ON condition?

Is it possible to write join query without ON statement? and how do these joins differ LEFT JOIN, RIGHT JOIN …

mysql join left-join inner-join right-join

mysql data directory location

I installed mysql in Mac after downloding its dmg file version 64 bit. While trying to create a database it gave …

mysql macos installation

With MySQL, how can I generate a column containing the record index in a table?

Is there any way I can get the actual row number from a query? I want to be able to …

mysql indexing