Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 31 of 41

Sort by: Newest Votes Active
9
votes
3
answers

UTF-8 vs Latin1 mysql, indexes not used on utf-8

mysql encoding
asked 2010-02-15T13:35:36.547
185
votes
10
answers

Increment value in MySQL update query

php mysql sql sql-update
asked 2010-02-13T21:37:19.850
26
votes
3
answers

MySql conditional order by

sql mysql sorting
asked 2010-02-13T17:15:09.823
78
votes
5
answers

What is a SPATIAL INDEX and when should I use it?

mysql indexing spatial-index
asked 2010-02-13T03:28:11.447
29
votes
4
answers

Is there an alternative to TOP in MySQL?

sql mysql
asked 2010-02-12T05:44:53.950
11
votes
6
answers

mysql SELECT NOT IN () -- disjoint set?

mysql disjoint-union
asked 2010-02-11T17:57:46.827
10
votes
2
answers

Optimising a haversine formula SQL call in PHP

php sql mysql math
asked 2010-02-09T03:06:23.597
13
votes
2
answers

mysql conditional insert - if not exists insert

mysql insert conditional-statements
asked 2010-02-08T17:03:23.357
45
votes
4
answers

Best way to avoid duplicate entry into mysql database

php mysql
asked 2010-02-08T05:36:50.663
41
votes
5
answers

How to get vi keybindings to work in mysql client?

mysql unix vim command-line readline
asked 2010-02-07T08:59:18.650
413
votes
15
answers

PHP date() format when inserting into datetime in MySQL

php mysql
asked 2010-02-07T00:27:02.397
35
votes
3
answers

mysql equivalent data types

mysql sql-server types
asked 2010-02-06T21:57:18.517
97
votes
18
answers

Auto Increment after delete in MySQL

sql mysql primary-key auto-increment
asked 2010-02-06T18:21:01.360
146
votes
4
answers

How to create a multi-tenant database with shared table structures?

sql mysql database-design multi-tenant
asked 2010-02-06T12:02:35.440
20
votes
4
answers

Out-of-sync AUTO_INCREMENT values in development_structure.sql from Rails/MySQL creates diff noise

ruby-on-rails mysql
asked 2010-02-05T21:53:15.197
37
votes
7
answers

Is it bad to rely on foreign key cascading?

sql mysql database-design cascade
asked 2010-02-05T03:10:45.520
22
votes
2
answers

Getting hierarchy data from self-referencing tables

mysql sql recursion hierarchy
asked 2010-02-04T13:26:35.310
130
votes
4
answers

What is the difference between MySQL, MySQLi and PDO?

php mysql pdo mysqli
asked 2010-02-03T08:59:55.217
95
votes
6
answers

Can MySQL convert a stored UTC time to local timezone?

mysql sql timezone convert-tz
asked 2010-02-02T20:51:25.843
41
votes
4
answers

Quickly add a copy of a column to a MySQL table

sql mysql
asked 2010-02-02T16:00:11.780
21
votes
3
answers

mysql database automatic partitioning

mysql database performance partitioning
asked 2010-02-01T01:02:09.597
54
votes
10
answers

mysql timediff to hours

php mysql
asked 2010-02-01T00:41:31.923
46
votes
8
answers

Facebook user_id : big_int, int or string?

mysql facebook types
asked 2010-01-31T15:03:32.030
68
votes
4
answers

InnoDB takes over an hour to import 600MB file, MyISAM in a few minutes

mysql performance innodb
asked 2010-01-30T10:23:07.973
13
votes
3
answers

Best practice question for MySQL: order by id or date?

mysql sql-order-by
asked 2010-01-30T03:53:45.233
147
votes
5
answers

Alter MySQL table to add comments on columns

mysql alter-table
asked 2010-01-29T14:12:22.953
125
votes
8
answers

SET NAMES utf8 in MySQL?

php mysql utf-8
asked 2010-01-29T02:06:02.640
16
votes
4
answers

Retrieve an Image stored as BLOB on a MYSQL DB

java mysql image jdbc blob
asked 2010-01-27T21:09:14.660
29
votes
1
answers

Could somebody explain SOLR requestHandlers and responseWriters in detail?

java php sql mysql database
asked 2010-01-27T13:55:34.983
18
votes
2
answers

MySQL IFNULL question

mysql ifnull
asked 2010-01-27T12:40:20.913
47
votes
10
answers

How can I stop a MySQL query if it takes too long?

mysql timeout
asked 2010-01-26T01:52:45.500
27
votes
2
answers

Creating mysql table with explicit default character set, what if I don't?

mysql character-encoding default
asked 2010-01-25T22:23:44.373
10
votes
5
answers

PHP PDO: how does re-preparing a statement affect performance

php mysql pdo prepared-statement
asked 2010-01-25T13:24:50.357
548
votes
14
answers

Restrict results to top N rows per group

sql mysql greatest-n-per-group ranking
asked 2010-01-25T01:25:02.777
29
votes
4
answers

inner join on null value

sql mysql t-sql sqlite
asked 2010-01-23T11:41:55.477
156
votes
2
answers

MySQL syntax for Join Update

sql mysql
asked 2010-01-22T02:19:15.060
33
votes
8
answers

Does column order matter in your MySQL tables?

mysql database
asked 2010-01-21T18:52:09.520
38
votes
7
answers

trapping a MySql warning

python mysql
asked 2010-01-20T14:59:39.597
33
votes
6
answers

MySQL query caching: limited to a maximum cache size of 128 MB?

caching mysql performance innodb
asked 2010-01-19T17:43:03.240
11
votes
6
answers

mysql multiple limit in one sql statement

php mysql
asked 2010-01-17T14:36:30.760
17
votes
7
answers

Use PHP to format an input SQL query as HTML?

php mysql phpmyadmin pretty-print
asked 2010-01-16T19:30:09.790
20
votes
4
answers

MySQL & PHP - Not unique table/alias

php mysql
asked 2010-01-16T12:40:50.063
16
votes
7
answers

Convert mysql query results to CSV (with copy/paste)

mysql csv export numbers
asked 2010-01-14T19:24:18.033
13
votes
3
answers

mysql: substring that returns the first occurrence from the right? (subrstring?!)

mysql
asked 2010-01-13T12:26:25.387
22
votes
3
answers

Advantage of using Views in MySQL

mysql stored-procedures view
asked 2010-01-13T07:02:29.853
16
votes
2
answers

Characters to use for \r\n when inserting into SQL Server

mysql sql-server insert
asked 2010-01-13T01:29:36.010
359
votes
14
answers

MySQL Orderby a number, Nulls last

mysql sql-order-by
asked 2010-01-12T19:09:39.710
17
votes
5
answers

Store IPv6 in database

php mysql ip ipv6
asked 2010-01-12T14:37:55.050
27
votes
4
answers

Use of PDO in classes

php mysql pdo prepared-statement
asked 2010-01-12T06:57:05.130
22
votes
13
answers

how to drop database

mysql database-administration
asked 2010-01-12T04:17:06.607
← Prev page 31 of 41 Next →