Questions tagged [mysql]

10

votes

2

answers

PHP Login framework to include google/facebook/openid etc

asked 2011-01-10T14:14:12.583

32

votes

2

answers

Exporting Blob from MySQL database to file with only SQL

sql mysql image export blob

asked 2011-01-10T11:57:07.347

19

votes

2

answers

What is the best way to return enum values in MySQL?

mysql enums

asked 2011-01-10T06:25:02.127

43

votes

4

answers

Search engine Lucene vs Database search

mysql lucene search-engine

asked 2011-01-09T10:22:47.660

49

votes

3

answers

MySQL LAST_INSERT_ID() used with multiple records INSERT statement

mysql insert lastinsertid

asked 2011-01-09T02:41:48.803

11

votes

2

answers

How do I replace all my NULL values in a particular field in a particular table?

mysql null replace phpmyadmin

asked 2011-01-07T19:00:17.013

114

votes

10

answers

MySQL and PHP - insert NULL rather than empty string

php mysql null sql-insert

asked 2011-01-06T22:00:41.613

29

votes

7

answers

How to create a "unique" constraint on a boolean MySQL column?

sql mysql constraints

asked 2011-01-06T17:43:44.717

9

votes

2

answers

How to install MySQL Connector/C on Mac OS X?

mysql c macos

asked 2011-01-06T13:36:58.590

11

votes

6

answers

INT vs VARCHAR in search

sql mysql database database-design search

asked 2011-01-05T18:29:14.660

29

votes

3

answers

What is the significance of the index name when creating an index in MySQL?

mysql indexing

asked 2011-01-05T05:35:55.150

266

votes

4

answers

INSERT ... ON DUPLICATE KEY (do nothing)

mysql sql unique-key

asked 2011-01-04T17:13:28.567

11

votes

1

answers

How to get the total found rows without considering the limit in PDO?

php mysql pdo

asked 2011-01-04T16:52:54.623

26

votes

3

answers

Is there a MySQL equivalent of sprintf?

mysql printf

asked 2011-01-04T15:10:48.563

56

votes

3

answers

MySQL Integer vs DateTime index

mysql indexing innodb

asked 2011-01-04T13:40:16.727

12

votes

4

answers

What type should I store IP addresses for MySQL?

mysql

asked 2011-01-04T02:32:45.753

9

votes

3

answers

Monitoring queries of a MySQL user

mysql logging monitor

asked 2011-01-03T15:06:04.157

10

votes

4

answers

Query speed based on order of columns

sql mysql postgresql

asked 2011-01-03T06:22:20.943

18

votes

7

answers

MySQL: setting time_zone in my.cnf options file

mysql timezone my.cnf

asked 2010-12-30T12:08:28.630

66

votes

3

answers

mysql GROUP_CONCAT duplicates

sql mysql group-concat

asked 2010-12-30T09:56:17.443

11

votes

2

answers

Is it possible to stop intellisense for .sql files in Visual Studio 2010?

mysql visual-studio-2010 intellisense

asked 2010-12-28T17:52:46.380

208

votes

24

answers

Library not loaded: libmysqlclient.16.dylib error when trying to run 'rails server' on OS X 10.6 with mysql2 gem

mysql ruby-on-rails rubygems webrick

asked 2010-12-28T14:17:59.343

22

votes

4

answers

Where is the created MySQL database folder stored in Mac OS X?

mysql macos

asked 2010-12-28T09:09:02.917

168

votes

10

answers

What does collation mean?

sql sql-server-2005 t-sql mysql

asked 2010-12-27T12:47:10.847

29

votes

5

answers

How to get the byte size of resultset in an SQL query?

sql mysql rdbms

asked 2010-12-24T03:32:29.790

19

votes

4

answers

Database Upserts - Good or Bad Practice?

mysql sql-server oracle-database database-design

asked 2010-12-22T09:59:03.837

13

votes

4

answers

Is it safe to install SQL Server 2008 R2 and MySQL side-by-side on Windows Server 2003 Enterprise Edition?

sql mysql sql-server database installation

asked 2010-12-21T21:27:19.983

32

votes

3

answers

How to get the execution time of a MySQL query from PHP?

php mysql webserver execution-time

asked 2010-12-21T17:03:51.850

13

votes

3

answers

how to save tags(keywords) in database?

mysql tags

asked 2010-12-21T14:06:16.950

42

votes

3

answers

MySQL storing duration time - datatype?

mysql time types duration

asked 2010-12-21T10:55:44.273

9

votes

3

answers

Upgrade WAMP to MySQL 5.5?

php mysql wamp

asked 2010-12-21T10:30:51.083

35

votes

3

answers

MySql insert the results of a select

mysql select insert

asked 2010-12-17T17:04:50.873

9

votes

2

answers

Extracting a remote MySQL Database without MyODBC?

mysql

asked 2010-12-17T07:06:12.310

9

votes

3

answers

The purpose of SQL's EXISTS and NOT EXISTS

sql mysql subquery exists not-exists

asked 2010-12-16T21:40:31.357

52

votes

2

answers

Best way to store working hours and query it efficiently

sql mysql database database-design

asked 2010-12-16T20:07:45.540

22

votes

3

answers

How we can use mysql_affected_rows() in stored procedure

mysql

asked 2010-12-16T07:08:30.333

63

votes

4

answers

Sql query to select from 1 hour ago?

sql mysql

asked 2010-12-15T15:06:54.910

76

votes

12

answers

Moving connections and instances between two computers

mysql mysql-workbench workbench

asked 2010-12-15T14:21:37.617

24

votes

5

answers

mysql group by and sort each group

mysql sql sorting group-by

asked 2010-12-15T09:37:35.923

65

votes

3

answers

MongoDB vs MySQL

mysql activerecord comparison mongodb ruby-on-rails-3

asked 2010-12-15T08:53:44.400

40

votes

3

answers

How to store a 128 bit number in a single column in MySQL?

mysql types ipv6

asked 2010-12-14T22:06:23.117

26

votes

3

answers

matching tables name with show tables

mysql

asked 2010-12-13T18:15:51.953

10

votes

6

answers

Change max_connect_errors in MySQL

mysql amazon-rds

asked 2010-12-13T13:16:40.570

14

votes

3

answers

Calculate 100 meter distance when the latitude and longitude is a known point

android mysql geocoding distance

asked 2010-12-12T05:40:39.157

39

votes

3

answers

MySQL: FULL OUTER JOIN - How do I merge one column?

sql mysql union full-outer-join

asked 2010-12-11T03:54:15.263

16

votes

2

answers

How to define a "unique" constraint on a column of MySQL table in Ruby on Rails 3?

mysql ruby-on-rails ruby-on-rails-3 unique unique-constraint

asked 2010-12-10T03:50:00.557

43

votes

4

answers

MySQL Boolean "tinyint(1)" holds values up to 127?

mysql boolean tinyint

asked 2010-12-09T18:19:21.057

11

votes

5

answers

Storing image data in a MySQL database?

mysql image

asked 2010-12-06T14:43:21.563

51

votes

6

answers

Is incrementing a field in MySQL atomic?

mysql thread-safety atomic increment

asked 2010-12-05T12:18:42.667

26

votes

3

answers

Why are certain types of prepared queries using PDO in PHP with MySQL slow?

php mysql performance pdo

asked 2010-12-03T23:05:57.277

Questions tagged mysql