Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 34 of 41

Sort by: Newest Votes Active
39
votes
2
answers

Decimal(3,2) values in MySQL are always 9.99

sql mysql
asked 2009-10-06T01:16:25.950
15
votes
2
answers

PDO looping through and printing fetchAll

php mysql database pdo fetchall
asked 2009-10-05T12:45:22.547
10
votes
7
answers

python MySQLDB query timeout

python timeout mysql
asked 2009-10-01T23:51:06.377
14
votes
7
answers

What happens when autoincrement clashes with existing data in MySQL?

mysql
asked 2009-09-30T09:02:01.447
35
votes
5
answers

MySQL Views - When to use & when not to

sql mysql view
asked 2009-09-27T13:28:36.223
12
votes
2
answers

mysql last month date statement

php mysql date
asked 2009-09-25T21:54:10.230
34
votes
5
answers

How to store more than 255 char in MySQL database?

sql mysql
asked 2009-09-25T12:18:40.793
9
votes
1
answers

PDO - Working with table prefixes

php mysql pdo
asked 2009-09-24T14:55:48.207
58
votes
6
answers

SELECT only rows that contain only alphanumeric characters in MySQL

mysql regex
asked 2009-09-24T12:57:05.007
106
votes
3
answers

How do I rename an Index in MySQL

sql mysql indexing
asked 2009-09-23T00:36:38.417
38
votes
2
answers

Creating ENUM variable type in MySQL

mysql variables enums
asked 2009-09-22T20:46:13.277
52
votes
3
answers

Composite Primary Key performance drawback in MySQL

mysql performance primary-key composite-key
asked 2009-09-22T14:34:59.600
61
votes
11
answers

Hibernate: Create Mysql InnoDB tables instead of MyISAM

java mysql hibernate jpa innodb
asked 2009-09-22T10:23:53.707
130
votes
14
answers

What is the MySQL JDBC driver connection string?

mysql jdbc connection-string
asked 2009-09-22T01:33:38.873
109
votes
20
answers

MySQL Creating tables with Foreign Keys giving errno: 150

mysql foreign-keys mysql-error-150
asked 2009-09-21T22:55:47.390
10
votes
4
answers

Python MySQL - SELECTs work but not DELETEs?

python mysql select sql-delete
asked 2009-09-20T19:22:23.413
39
votes
8
answers

How to SELECT the newest four items per category?

sql mysql greatest-n-per-group
asked 2009-09-18T03:59:31.270
11
votes
2
answers

MYSQL Fulltext search and LIKE

mysql full-text-search
asked 2009-09-17T06:40:13.020
64
votes
6
answers

adding 30 minutes to datetime php/mysql

php mysql datetime strtotime
asked 2009-09-17T05:26:16.787
233
votes
16
answers

How do you uninstall MySQL from Mac OS X?

mysql macos osx-snow-leopard
asked 2009-09-17T02:26:26.483
43
votes
10
answers

phpMyAdmin: change default number of rows displayed?

php mysql phpmyadmin
asked 2009-09-11T21:08:35.433
47
votes
12
answers

PHP PDO vs normal mysql_connect

php mysql pdo
asked 2009-09-09T20:52:06.477
45
votes
12
answers

How to connect MySQL workbench with MAMP PRO?

mysql macos mamp
asked 2009-09-07T22:29:27.707
10
votes
5
answers

Convert MS SQL script to Mysql and Oracle

sql mysql sql-server oracle-database
asked 2009-09-07T14:53:45.330
11
votes
3
answers

Using rsync to backup MySQL

mysql unix rsync
asked 2009-09-07T11:29:26.037
164
votes
12
answers

How to get ID of the last updated row in MySQL?

php mysql
asked 2009-09-07T07:34:02.563
11
votes
4
answers

read/write unicode data in MySql

c# sql mysql unicode
asked 2009-09-06T15:59:59.657
9
votes
5
answers

way to search entire database for a string in MySQL

mysql
asked 2009-09-05T20:53:37.340
168
votes
7
answers

How do you use the "WITH" clause in MySQL?

mysql common-table-expression with-clause subquery-factoring mysql-8.0
asked 2009-09-05T05:45:26.760
13
votes
3
answers

List of Best Practice MySQL Data Types

sql mysql
asked 2009-09-04T16:29:39.980
65
votes
5
answers

Is there a way to retrieve the autoincrement ID from a prepared statement

java mysql prepared-statement auto-increment
asked 2009-09-03T22:04:26.783
9
votes
6
answers

Get next auto increment

php mysql auto-increment
asked 2009-09-03T08:17:25.520
10
votes
6
answers

gem install mysql failure in Snow Leopard

mysql rubygems osx-snow-leopard
asked 2009-09-02T09:45:54.127
9
votes
7
answers

SQL: count number of distinct values in every column

sql mysql count distinct
asked 2009-09-01T17:04:18.723
710
votes
9
answers

How do I change the data type for a column in MySQL?

mysql
asked 2009-08-31T10:44:24.233
179
votes
14
answers

Unknown column in 'field list' error on MySQL Update query

mysql sql mysql-error-1054
asked 2009-08-28T10:38:11.893
70
votes
15
answers

Fixing broken UTF-8 encoding

php mysql unicode utf-8
asked 2009-08-28T02:14:51.783
31
votes
4
answers

Writing a subquery using Zend DB

sql mysql zend-framework
asked 2009-08-27T11:46:40.120
20
votes
3
answers

What is the best way to bind decimal / double / float values with PDO in PHP?

php mysql database binding pdo
asked 2009-08-26T14:22:26.537
78
votes
4
answers

MySQL ORDER BY IN()

php mysql sql-order-by in-function
asked 2009-08-26T05:07:31.560
23
votes
4
answers

db:schema:load vs db:migrate with capistrano

mysql ruby-on-rails database rake capistrano
asked 2009-08-25T17:36:17.490
11
votes
5
answers

MySQL - How to SUM times?

mysql
asked 2009-08-25T16:37:57.170
44
votes
12
answers

Update only Time in a mysql DateTime field

sql mysql
asked 2009-08-25T07:23:03.377
117
votes
19
answers

Deleting millions of rows in MySQL

mysql query-optimization sql-delete
asked 2009-08-23T16:39:32.657
44
votes
3
answers

How can I make a MySQL SUM query return zero instead of null if there are no records?

sql mysql
asked 2009-08-23T14:02:55.603
64
votes
6
answers

Creating DATETIME from DATE and TIME

mysql datetime
asked 2009-08-23T13:59:45.903
43
votes
4
answers

how safe are PDO prepared statements

php mysql security pdo sql-injection
asked 2009-08-21T22:47:09.557
13
votes
1
answers

mySQL: Multiple COUNT()s based on differing criteria

mysql
asked 2009-08-21T19:29:57.240
1363
votes
34
answers

Retrieving the last record in each group - MySQL

mysql sql group-by greatest-n-per-group groupwise-maximum
asked 2009-08-21T17:04:04.147
49
votes
5
answers

How to ORDER BY a SUM() in MySQL?

sql mysql sql-order-by
asked 2009-08-21T02:39:28.580
← Prev page 34 of 41 Next →