Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 40 of 41

Sort by: Newest Votes Active
223
votes
17
answers

How can I tell when a MySQL table was last updated?

mysql sql
asked 2008-11-21T00:48:59.003
10
votes
3
answers

MySQL: adding current year as a default value for a field 'year'

mysql mysql-error-1067
asked 2008-11-19T13:50:22.047
210
votes
10
answers

MySQL - Using COUNT(*) in the WHERE clause

mysql count aggregation having
asked 2008-11-19T12:47:36.213
11
votes
1
answers

Using variables as OFFSET in SELECT statments inside mysql's stored functions

mysql stored-functions
asked 2008-11-19T00:48:12.097
128
votes
6
answers

What is the difference between BIT and TINYINT in MySQL?

mysql bit tinyint
asked 2008-11-14T14:29:46.183
61
votes
19
answers

MySQL strip non-numeric characters to compare

mysql regex
asked 2008-11-13T14:43:20.977
17
votes
3
answers

Big integer field in django models

mysql django
asked 2008-11-12T11:59:25.323
32
votes
10
answers

Does the MySQL TRIM function not trim line breaks or carriage returns?

mysql string trim
asked 2008-11-11T18:17:26.043
1371
votes
14
answers

UTF-8 all the way through

php mysql apache utf-8
asked 2008-11-10T21:04:56.767
44
votes
12
answers

MySql: MyISAM vs. Inno DB!

mysql database innodb myisam
asked 2008-11-10T09:42:23.120
12
votes
8
answers

Best way to connect to MySQL locally?

mysql windows
asked 2008-11-07T12:02:43.027
14
votes
4
answers

Why does Hibernate/JDBC/MySQL drop connections after a day or so?

mysql hibernate
asked 2008-11-06T23:41:43.940
115
votes
5
answers

Mysql strip time component from datetime

sql mysql datetime
asked 2008-11-06T05:29:35.487
11
votes
6
answers

Is there a speed difference between sqlite3 and mysql?

mysql ruby-on-rails database sqlite
asked 2008-11-05T06:12:26.803
28
votes
2
answers

Does SQL Server 2005 have an equivalent to MySql's ENUM data type?

mysql database sql-server-2005 enums
asked 2008-11-04T18:17:12.723
84
votes
3
answers

How to do select from where x is equal to multiple values?

sql mysql
asked 2008-11-04T12:47:51.670
10
votes
2
answers

java.sql.Connection extension for SSH

java mysql jdbc ssh firewall
asked 2008-10-31T00:40:11.303
63
votes
7
answers

make an ID in a mysql table auto_increment (after the fact)

mysql primary-key auto-increment
asked 2008-10-30T19:41:26.193
328
votes
10
answers

What data type to use for hashed password field and what length?

mysql hash types passwords cryptography
asked 2008-10-29T15:44:47.373
10
votes
8
answers

What is the simplest way to format a timestamp from SQL in PHP?

php mysql formatting timestamp
asked 2008-10-26T14:30:22.877
27
votes
5
answers

Foreign keys in MySQL?

sql mysql foreign-keys
asked 2008-10-25T16:43:19.380
12
votes
8
answers

What is the best practice for naming database tables to provide natural organization?

mysql database database-design
asked 2008-10-24T19:13:14.797
12
votes
3
answers

What's the best method to use / store encryption keys in MySQL

php mysql security encryption key
asked 2008-10-24T01:43:14.633
30
votes
12
answers

Do any databases support automatic Index Creation?

mysql database indexing
asked 2008-10-23T21:05:45.287
15
votes
2
answers

MySQL Fulltext Search Score Explained

mysql full-text-search
asked 2008-10-23T15:16:24.010
14
votes
7
answers

Copying rows in MySQL

mysql sql
asked 2008-10-23T14:38:58.093
89
votes
4
answers

NULL in MySQL (Performance & Storage)

sql mysql null
asked 2008-10-23T10:02:48.150
25
votes
3
answers

Do different databases use different name quote?

mysql database
asked 2008-10-18T01:02:09.650
494
votes
14
answers

How can I check MySQL engine type for a specific table?

mysql innodb myisam
asked 2008-10-17T19:28:38.230
542
votes
6
answers

How do I modify a MySQL column to allow NULL?

mysql syntax alter
asked 2008-10-17T16:52:23.053
171
votes
16
answers

Getting raw SQL query string from PDO prepared statements

php sql mysql pdo
asked 2008-10-16T22:47:32.463
43
votes
9
answers

How to enable MySQL client auto re-connect with MySQLdb?

python mysql
asked 2008-10-16T09:56:05.827
65
votes
11
answers

How do you write a case insensitive query for both MySQL and Postgres?

mysql ruby-on-rails database postgresql heroku
asked 2008-10-15T01:10:29.273
134
votes
15
answers

How to make MySQL handle UTF-8 properly

mysql utf-8
asked 2008-10-14T18:09:31.463
126
votes
5
answers

Can you use an alias in the WHERE clause in mysql?

mysql sql having having-clause
asked 2008-10-14T06:49:45.737
17
votes
2
answers

Grouping by intervals

sql mysql
asked 2008-10-13T11:28:06.067
34
votes
5
answers

MySQL: Select N rows, but with only unique values in one column

sql mysql unique aggregate-functions min
asked 2008-10-10T10:11:46.983
15
votes
6
answers

How to monitor MySQL space?

mysql database-administration
asked 2008-10-08T19:52:29.823
40
votes
6
answers

Is there an equivalent to SHA1() in MS-SQL?

sql mysql sha1 t-sql sql-server
asked 2008-10-08T19:30:02.910
406
votes
11
answers

MySQL - force not to use cache for testing speed of query

mysql
asked 2008-10-08T09:05:11.843
22
votes
9
answers

What techniques are most effective for dealing with millions of records?

mysql database
asked 2008-10-08T08:12:53.727
12
votes
7
answers

PHP: mysql_connect() won't work via command line

php mysql
asked 2008-10-08T03:25:37.350
12
votes
6
answers

Either OR non-null constraints in MySQL

sql mysql null
asked 2008-10-04T15:14:28.653
30
votes
16
answers

Should I use NULL or an empty string to represent no data in table column?

mysql database null
asked 2008-10-03T17:21:13.047
29
votes
6
answers

Watching a table for change in MySQL?

mysql database
asked 2008-10-03T14:51:28.730
502
votes
23
answers

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

mysql database-design maps mapping latitude-longitude
asked 2008-10-01T19:18:13.960
100
votes
23
answers

Natural Sort in MySQL

sql mysql sorting natural-sort
asked 2008-09-30T15:42:27.857
12
votes
3
answers

mysql "drop database" takes time -- why?

mysql database schema innodb
asked 2008-09-29T18:42:14.657
465
votes
6
answers

How to use GROUP BY to concatenate strings in MySQL?

sql mysql string aggregate concatenation
asked 2008-09-29T17:32:45.493
13
votes
11
answers

Search for text between delimiters in MySQL

mysql
asked 2008-09-29T17:08:28.047
← Prev page 40 of 41 Next →