How to Select a Subset in MySQL. The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables. SQL's SELECT statement shows ...

Open MySQL Workbench and connect to your database server. From the database home screen (Figure A), right-click a blank spot under the SCHEMAS pane and select Create Schema.

If you manage a database server, you are probably always in search of a tool to make that process a bit easier. If your database of choice is MySQL, you have a number of options.

The range of database platforms to choose from is enormous, and there's no one-size-fits-all solution. So what should you choose?

If it matters, I'm using PHP, but I'm pretty sure I just need help with the actual MySQL query.I'm going to be building a table in MySQL with user information. What I'd like to do is select 50 ...