Top "Mysql" questions

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

How to import large sql file in phpmyadmin

I want to import a sql file of approx 12 mb. But its causing problem while loading. Is there any way …

mysql phpmyadmin
Using a .php file to generate a MySQL dump

Here's the information I have: I am working with a Linux based system using MySQL and PHP5. I need to …

php mysql mysqldump
MySQL - length() vs char_length()

What's the main difference between length() and char_length()? I believe it has something to do with binary and non-binary …

mysql string
Using ORDER BY and GROUP BY together

My table looks like this (and I'm using MySQL): m_id | v_id | timestamp ------------------------ 6 | 1 | 1333635317 34 | 1 | 1333635323 34 | 1 | 1333635336 6 | 1 | 1333635343 6 | 1 | 1333635349 My target is to take …

mysql sql group-by greatest-n-per-group
MySQL: determine which database is selected?

After calling mysql_select_db to grab a database, is there any way to later output the name of the …

mysql
Types in MySQL: BigInt(20) vs Int(20)

I was wondering what the difference between BigInt, MediumInt, and Int are... it would seem obvious that they would allow …

mysql types
When to use single quotes, double quotes, and backticks in MySQL

I am trying to learn the best way to write queries. I also understand the importance of being consistent. Until …

mysql sql quotes
Reorder / reset auto increment primary key

I have a MySQL table with an auto increment primary key. I deleted some rows in the middle of the …

mysql database
Find nearest latitude/longitude with an SQL query

I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and …

mysql sql coordinates geospatial
How many characters can you store with 1 byte?

1 byte = 8 bits So, does this mean 1 byte can only hold one character? E.g.: "16" uses 2 bytes , "9" uses 1 byte , "a" uses 1 …

mysql character byte