Updating multiple columns in a table
My SQL is an SQL based relational database management system (DBMS) that runs under a broad array of operating systems. The SQL commands discussed in this tutorial apply to My SQL operating under all operating systems.Only the installation instructions are Windows specific.The focus is on Windows XP Professional and Windows 2000 Professional machines.We'll be covering the installation of My SQL versions 5.0.51b, 4.1.16 as well as how to configure everything so they'll all be able to run on your system at the same time.If your operating system or versions of My SQL are different, the instructions should still work, but keep an eye out for slight differences, like which working directory you'll need to be in.Usage: Log in to your computer using an account having Administrator privileges.Plus, the data directories will be moved to another location in order to make backups easier.
If you intend to jump over a release series in your upgrade (e.g.: going straight from 4.0 to 5.0) you are strongly advised NOT to do so.If you're not upgrading, just skip down to the next section.If you are upgrading, there are MANY changes that you HAVE TO be aware of., step by step, instructions on how to get started.This My SQL help page also gives more advanced users assistance in upgrading and running multiple versions of My SQL on a computer at the same time.
You should do the upgrade process one release series at a time (e.g.: go from 4.0 to 4.1, then to 5.0). That can be due to a typographical error in the name or value of a setting.