Top "Mysql" questions

Ordering by specific field value first

I have a table with 3 columns: id | name | priority -------------------- 1 | core | 10 2 | core | 9 3 | other | 8 4 | board | 7 5 | board | 6 6 | core | 4 I want to order …

mysql sql select sql-order-by

How to create virtual column using MySQL SELECT?

If I do SELECT a AS b and b is not a column in the table, would query create the "…

php mysql select

How do I insert multiple checkbox values into a table?

I cant seem to find or figure out a working solution to insert multiple checkbox values from a form into …

php mysql checkbox multipleselection

Mysql password expired. Can't connect

I just wiped my Mac and did a fresh install of El Capitan. I'm struggling to connect to Mysql now. …

php mysql macos osx-elcapitan

Drop multiple tables in one shot in mysql

How to drop multiple tables from one single database at one command. something like, > use test; > drop table …

mysql sql multiple-tables drop-table

MySQL: Selecting multiple fields into multiple variables in a stored procedure

Can I SELECT multiple columns into multiple variables within the same select query in MySQL? For example: DECLARE iId INT(20); …

sql mysql stored-procedures sql-function

MySQL JOIN with LIMIT 1 on joined table

I want to join two tables, but only get 1 record of table2 per record on table1 For example: SELECT c.…

mysql join limit

Completely Remove MySQL Ubuntu 14.04 LTS

I somehow have messed up my MySQL on my Ubuntu server and cannot fix it. I have tried every single …

mysql ubuntu lts

MySQL "incorrect string value" error when save unicode string in Django

I got strange error message when tried to save first_name, last_name to Django's auth_user model. Failed examples …

python mysql django unicode utf-8

Import SQL file by command line in Windows 7

I want to import an SQL file (size > 500MB) into a database. I have wamp on my PC. Phpmyadmin …

mysql phpmyadmin command-line-arguments wampserver