Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 33 of 41

Sort by: Newest Votes Active
10
votes
1
answers

Foreign Keys and MySQL Errors

mysql mysql-error-1005
asked 2009-11-29T02:00:09.490
44
votes
11
answers

Database: Best performance way to query geo location data?

mysql database database-design performance
asked 2009-11-28T19:12:04.797
18
votes
5
answers

Why does my python script randomly get killed?

python mysql url
asked 2009-11-28T00:47:23.267
10
votes
5
answers

How can I reverse the default ordering in MySQL?

sql mysql sorting sql-order-by
asked 2009-11-27T06:22:17.917
22
votes
4
answers

Java, MySQL: Is there a way to embed a MySQL server with a Java program?

java mysql embedded-database
asked 2009-11-24T16:58:23.473
38
votes
4
answers

How much real storage is used with a varchar(100) declaration in mysql?

sql mysql
asked 2009-11-24T14:43:16.883
41
votes
3
answers

PHP PDO prepared statement -- MySQL LIKE query

php mysql pdo
asked 2009-11-23T22:15:33.557
36
votes
6
answers

SQL Delete Rows Based on Another Table

sql mysql
asked 2009-11-23T15:20:27.457
12
votes
4
answers

How to change the storage engine type on MySQL?

mysql
asked 2009-11-22T21:38:01.553
12
votes
11
answers

Best way to handle concurrency issues

php mysql postgresql concurrency
asked 2009-11-22T17:17:51.387
23
votes
2
answers

Is "LIMIT 1" recommended for query where WHERE condition is based on PK?

mysql limit
asked 2009-11-21T03:04:13.930
16
votes
4
answers

select and echo a single field from mysql db using PHP

php mysql
asked 2009-11-20T09:29:39.267
9
votes
5
answers

Can i force mysql to perform subquery first?

sql mysql subquery
asked 2009-11-19T21:29:07.190
13
votes
3
answers

PHP- inserting binary data in mysql using prepared statements

php mysql prepared-statement
asked 2009-11-17T10:24:06.713
14
votes
1
answers

How do I check if date occurs today?

mysql
asked 2009-11-17T01:47:23.497
29
votes
4
answers

Achievements / Badges system

php mysql architecture scalability
asked 2009-11-16T20:45:06.247
9
votes
3
answers

Mysql: Optimizing finding super node in nested set tree

sql mysql nested-sets
asked 2009-11-16T18:12:33.650
9
votes
4
answers

Will partitions improve MySQL INSERT speed?

mysql
asked 2009-11-16T03:48:14.137
11
votes
7
answers

Should I use MySQL blob field type?

mysql
asked 2009-11-11T18:44:07.643
122
votes
10
answers

How can I restore the MySQL root user’s full privileges?

mysql privileges mysql-error-1045
asked 2009-11-10T16:07:10.613
13
votes
5
answers

Is there a MySQL equivalent of PHP's preg_replace?

php mysql regex replace preg-replace
asked 2009-11-10T03:17:15.243
33
votes
7
answers

How to check if MySQL returns null/empty?

php mysql
asked 2009-11-07T15:36:17.943
44
votes
2
answers

MySQL EXPLAIN: "Using index" vs. "Using index condition"

mysql optimization
asked 2009-11-06T13:18:45.987
17
votes
4
answers

Too many tables; MySQL can only use 61 tables in a join

mysql join entity-attribute-value
asked 2009-11-06T02:06:35.160
10
votes
4
answers

PHP Mysql joins across databases

php sql mysql join
asked 2009-11-04T17:19:25.530
17
votes
5
answers

mysql CREATE USER

mysql database
asked 2009-11-03T14:16:09.180
121
votes
4
answers

Replace Default Null Values Returned From Left Outer Join

mysql sql sql-server t-sql sql-server-2008
asked 2009-11-02T22:56:17.843
12
votes
1
answers

MySQL LOAD DATA INFILE - Loading a file with no primary key

mysql import load-data-infile
asked 2009-11-01T12:18:00.923
17
votes
2
answers

MySQL - Rename Column

php mysql
asked 2009-10-31T20:52:26.117
9
votes
3
answers

Is there a mysql function that will format a unix timestamp?

sql mysql
asked 2009-10-30T16:52:59.333
121
votes
9
answers

MySQL "CREATE TABLE IF NOT EXISTS" -> Error 1050

sql mysql mysql-error-1050
asked 2009-10-30T16:39:20.327
75
votes
2
answers

How do you write a conditional in a MySQL select statement?

sql mysql
asked 2009-10-30T04:06:50.893
105
votes
7
answers

MySQL datetime fields and daylight savings time -- how do I reference the "extra" hour?

php mysql datetime timestamp dst
asked 2009-10-29T19:55:06.437
9
votes
4
answers

Is there a way to get rows_examined in MySQL without the slow log?

mysql performance
asked 2009-10-28T14:42:10.657
54
votes
11
answers

Store mysql query output into a shell variable

mysql sql bash scripting
asked 2009-10-28T12:33:50.890
66
votes
8
answers

How can I store and retrieve images from a MySQL database using PHP?

php mysql database blob
asked 2009-10-28T12:13:37.057
50
votes
5
answers

Is BIGINT(8) the largest integer MySQL can store?

sql mysql
asked 2009-10-27T17:11:53.920
33
votes
12
answers

Random record from mysql database with CodeIgniter

php mysql codeigniter random
asked 2009-10-26T23:39:44.477
14
votes
1
answers

Can't create MySQL trigger with TRIGGER privilege on 5.1.32

sql triggers mysql
asked 2009-10-26T21:14:20.683
11
votes
3
answers

How to order by maximum of two column which can be null in MySQL?

mysql sql sorting
asked 2009-10-23T05:14:43.130
123
votes
10
answers

SQL: deleting tables with prefix

mysql phpmyadmin sql-drop
asked 2009-10-19T15:14:44.300
10
votes
1
answers

MySQL full text search for words with three or less letters

sql mysql full-text-search
asked 2009-10-18T18:14:24.683
10
votes
5
answers

Apache, PHP and MySQL portable?

php mysql apache
asked 2009-10-17T18:20:41.843
53
votes
5
answers

PHP Check for NULL

php mysql null
asked 2009-10-16T05:33:13.613
9
votes
5
answers

SQL left join query runs VERY slow

sql mysql optimization
asked 2009-10-15T23:29:21.460
48
votes
4
answers

How to map OO inheritence to a relational database scheme?

mysql database inheritance data-modeling class-table-inheritance
asked 2009-10-14T17:52:52.023
20
votes
10
answers

MySQL driver for Rails in Windows 7 x64

mysql ruby-on-rails windows-7
asked 2009-10-12T22:22:07.397
26
votes
6
answers

Using backquote/backticks for mysql queries

sql mysql
asked 2009-10-12T18:47:13.980
15
votes
2
answers

Under what circumstances would you want Rails to be set NOT to reconnect to MYSQL

mysql ruby-on-rails
asked 2009-10-08T16:21:07.153
10
votes
7
answers

Replacement for PEAR: MDB2 on PHP 5.3

php mysql pear mdb2
asked 2009-10-07T07:39:47.520
← Prev page 33 of 41 Next →