Questions tagged [mysql]

327

votes

8

answers

MySQL show status - active or total connections?

mysql connection

asked 2011-09-15T14:10:16.027

81

votes

5

answers

How to count the number of instances of each foreign-key ID in a table?

mysql sql

asked 2011-09-15T01:28:18.233

39

votes

3

answers

Opposite of Distinct in MySQL

mysql

asked 2011-09-14T05:26:32.133

12

votes

1

answers

Dapper is throwing an invalid cast exception when trying to set a boolean value returned from MySQL

mysql dapper mysql.data

asked 2011-09-14T03:12:24.847

9

votes

3

answers

Insert data from another table with a loop in mysql

mysql sql

asked 2011-09-14T01:10:20.800

26

votes

2

answers

syntax error for mysql declaration of variable

mysql syntax

asked 2011-09-13T20:30:19.487

9

votes

1

answers

select all records created within the hour

mysql database

asked 2011-09-13T17:26:58.833

17

votes

3

answers

How do I ensure I caught all errors from MySQLi::multi_query?

php mysql mysqli error-handling

asked 2011-09-12T23:46:48.110

418

votes

6

answers

What does SQL clause "GROUP BY 1" mean?

mysql sql group-by

asked 2011-09-12T19:10:53.330

10

votes

3

answers

Using MySQL with dev_appserver (Google App Engine) and Google SQL Service

mysql google-app-engine

asked 2011-09-12T09:40:47.727

15

votes

5

answers

Very slow delete on mysql base with subquery

mysql subquery config sql-delete

asked 2011-09-09T11:48:57.467

22

votes

2

answers

.NET MySQL Connector Conflicting DbProviderFactories

c# .net mysql mysql-connector

asked 2011-09-08T20:31:53.733

9

votes

3

answers

MYSQL Delete FIRST duplicates from table

mysql sql

asked 2011-09-07T20:00:09.947

9

votes

4

answers

Chaining SQL queries

mysql sql

asked 2011-09-06T19:07:18.093

16

votes

3

answers

Kohana 3.2 ORM and PDO

php mysql pdo kohana kohana-orm

asked 2011-09-06T03:53:49.223

34

votes

2

answers

What is the disadvantage to using a MySQL longtext sized field when every entry will fit within a mediumtext sized field?

mysql comparison longtext

asked 2011-09-06T03:40:09.563

9

votes

1

answers

The CommandText property has not been properly initialized (MySqlDataReader)

c# mysql database

asked 2011-09-05T13:47:00.757

172

votes

8

answers

B-Tree vs Hash Table

mysql data-structures computer-science complexity-theory b-tree

asked 2011-09-05T09:43:17.933

25

votes

7

answers

Unknown table engine 'InnoDB'

mysql innodb

asked 2011-09-05T01:09:43.387

9

votes

2

answers

Rails, how to migrate data from development sqlite3 database to production MySQL database?

mysql ruby-on-rails sqlite migration

asked 2011-09-03T05:39:41.317

39

votes

2

answers

Python, MySQL and SELECT output to dictionary with column names for keys

python mysql dictionary

asked 2011-09-01T09:04:41.023

10

votes

5

answers

I set a MySQL column to "NOT NULL" but still I can insert an empty value

mysql database

asked 2011-08-31T23:40:43.013

12

votes

4

answers

In PHP, what happens in memory when we use mysql_query

php mysql pointers memory

asked 2011-08-31T07:34:24.113

24

votes

3

answers

Mysql select query after certain date

php mysql select

asked 2011-08-30T21:18:09.310

10

votes

2

answers

Order within group by?

mysql greatest-n-per-group

asked 2011-08-29T17:46:00.477

17

votes

2

answers

MySQL foreign keys on self

mysql foreign-keys self-reference

asked 2011-08-29T12:35:37.467

10

votes

1

answers

At-Sign in SQL statement before column name

mysql sql symbols at-command

asked 2011-08-29T12:28:18.220

9

votes

4

answers

InnoDB vs. MyISAM insert query time

mysql database optimization innodb myisam

asked 2011-08-27T21:32:01.883

19

votes

2

answers

Muzak replication advice and techniques

php mysql replication innodb myisam

asked 2011-08-27T20:07:07.270

16

votes

6

answers

PHP and MySQL: Order by most recent date and limit 10

php mysql sql-order-by limit querying

asked 2011-08-27T14:03:39.923

13

votes

1

answers

Installing MySQL on Ubuntu with ruby on rails [ERROR]

mysql ruby-on-rails linux ruby-on-rails-3 ubuntu

asked 2011-08-26T08:29:59.190

14

votes

1

answers

Nested Select statement in MYSQL join

mysql join nested greatest-n-per-group

asked 2011-08-25T17:21:57.960

16

votes

3

answers

Find the query from query_id in mysql

mysql deadlock workbench

asked 2011-08-25T12:32:24.200

14

votes

6

answers

does extracting strings into another table and making the original column a foreign key save space?

mysql sql foreign-keys

asked 2011-08-24T21:41:05.837

20

votes

5

answers

C#: SQL Query Builder Class

c# mysql

asked 2011-08-24T07:38:19.773

11

votes

4

answers

How to convert UNIX time before 1970 to date format in MySQL?

mysql unix-timestamp

asked 2011-08-24T05:58:10.580

40

votes

1

answers

Multiple inner joins with multiple tables

mysql sql join inner-join

asked 2011-08-22T15:51:27.397

38

votes

7

answers

Saving facebook id as int or varchar?

mysql facebook facebook-graph-api

asked 2011-08-21T12:02:00.517

85

votes

3

answers

MySQL VARCHAR size?

mysql varchar

asked 2011-08-19T15:38:43.397

9

votes

2

answers

Convert lat/lng pairs using GeomFromText('POINT(1 1)') and insert in another column

mysql

asked 2011-08-18T22:54:51.800

10

votes

2

answers

Is there a way to simulate GROUP BY WITH CUBE in MySql?

mysql group-by cube rollup

asked 2011-08-16T21:25:53.483

38

votes

4

answers

How to insert a row without any values so that all columns assume their default value?

php mysql

asked 2011-08-16T10:58:58.133

79

votes

2

answers

MySQL TEXT vs BLOB vs CLOB

mysql

asked 2011-08-15T22:42:30.977

10

votes

2

answers

Django Binary or BLOB model field

python mysql django blob django-blob

asked 2011-08-15T11:03:14.163

117

votes

3

answers

Best way to store chat messages in a database?

mysql scalability chat

asked 2011-08-15T08:41:54.067

50

votes

5

answers

How do I refer to capture groups in a MySQL regex?

mysql regex

asked 2011-08-14T16:48:05.033

264

votes

1

answers

How to get the count of each distinct value in a column?

mysql sql count

asked 2011-08-13T23:18:43.700

17

votes

4

answers

Insert Blobs in MySql databases with php

php mysql blob

asked 2011-08-13T19:03:42.557

9

votes

1

answers

MySQL relational tables and Primary Keys data types

mysql relational-database

asked 2011-08-12T19:09:07.627

29

votes

2

answers

Why is my custom MySQL function so much slower than inlining same in query?

mysql performance user-defined-functions

asked 2011-08-12T00:05:37.417

Questions tagged mysql