Skip to content
DevChunks

DevChunks

Web development tips, tricks and advice

  • PHP
  • MySQL
  • JavaScript
  • Tools
  • Store
  • About
  • Contact
DevChunks
DevChunks
Web development tips, tricks and advice

MySQL

MySQL

Incorrect usage of UNION and ORDER BY

ByCarey October 7, 2010September 15, 2022

A common problem using the UNION command in MySQL is when you want to order data sets differently. If you do it incorrectly, you will see the error message: Incorrect usage of UNION and ORDER BY To solve the problem, wrap each SELECT statement in parenthesis as follows: Nice and simple; all you have to…

Read More Incorrect usage of UNION and ORDER BYContinue

MySQL

Importing Large MySQL Database SQL Dump Files

ByCarey October 19, 2009January 28, 2023

If you’ve ever had to transfer a large MySQL database, you know it can be a real pain. phpMyAdmin is the go-to for most web hosts, but when it comes to importing that massive SQL dump, it can be a big time-waster. Timeouts and errors are all too common when you’re trying to import data…

Read More Importing Large MySQL Database SQL Dump FilesContinue

Page navigation

Previous PagePrevious 1 2 3
Facebook Twitter Instagram
  • About
  • Contact
  • Privacy Policy

© 2023 DevChunks

  • PHP
  • MySQL
  • JavaScript
  • Tools
  • Store
  • About
  • Contact