Top "Mysql" questions

How to select count with Laravel's fluent query builder?

Here is my query using fluent query builder. $query = DB::table('category_issue') ->select('issues.*') ->…

mysql activerecord fluent laravel eloquent

Change mysql user password using command line

I'm trying to update the password for a database user using the command line, and it's not working for me. …

mysql command-line putty

MySQL match() against() - order by relevance and column?

Okay, so I'm trying to make a full text search in multiple columns, something simple like this: SELECT * FROM pages …

mysql full-text-search

MySQL 'Order By' - sorting alphanumeric correctly

I want to sort the following data items in the order they are presented below (numbers 1-12): 1 2 3 4 5 6 7 8 9 10 11 12 However, my query …

mysql sql-order-by

What does mysql error 1025 (HY000): Error on rename of './foo' (errorno: 150) mean?

I tried this in mysql: mysql> alter table region drop column country_id; And got this: ERROR 1025 (HY000): Error …

mysql mysql-error-1025

use mysql SUM() in a WHERE clause

suppose I have this table id | cash 1 200 2 301 3 101 4 700 and I want to return the first row in which the sum of …

mysql aggregate-functions having-clause

Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)

When you limit the number of rows to be returned by a SQL query, usually used in paging, there are …

mysql optimization

Differences between utf8 and latin1

what is the difference between utf8 and latin1?

mysql utf-8 installation latin1

comma separated string of selected values in mysql

I want to convert selected values into a comma separated string in MySQL. My initial code is as follows: SELECT …

mysql select comma

Copy table without copying data

CREATE TABLE foo SELECT * FROM bar copies the table foo and duplicates it as a new table called bar. How …

mysql