Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 28 of 41

Sort by: Newest Votes Active
12
votes
2
answers

How to validate expiry date on MySQL query

php mysql datetime
asked 2010-06-23T16:22:29.200
11
votes
1
answers

Explain Vs Desc anomalies in mysql

mysql sql-execution-plan describe
asked 2010-06-23T08:58:22.710
73
votes
6
answers

add a temporary column with a value

sql mysql
asked 2010-06-22T21:06:04.027
24
votes
6
answers

Best Practice / Standard for storing an Address in a SQL Database

mysql street-address
asked 2010-06-22T14:30:12.843
37
votes
5
answers

mysql, alter column remove primary key and auto incremement

mysql sql mysql-error-1075
asked 2010-06-22T05:12:49.500
9
votes
6
answers

PHP: How to determine if a database connection is open

php mysql
asked 2010-06-19T10:12:31.237
9
votes
3
answers

Deleting all records of a table that are not referenced from another table

sql mysql
asked 2010-06-19T08:11:47.630
10
votes
4
answers

How do I add to each row in MySQL?

sql mysql
asked 2010-06-19T04:32:41.363
11
votes
2
answers

SQLAlchemy: Inserting the results of a query into another table

python sql mysql sqlalchemy
asked 2010-06-18T15:02:12.113
9
votes
3
answers

How do I explain a query with parameters in MySQL

mysql sql-execution-plan
asked 2010-06-16T16:56:19.083
47
votes
4
answers

calculate a sum of type time using sql

sql mysql
asked 2010-06-16T14:22:07.247
29
votes
6
answers

Getting the count of rows in a Java resultset

java mysql jdbc
asked 2010-06-16T11:11:05.620
58
votes
7
answers

Indexes and multi column primary keys

sql mysql primary-key indexing
asked 2010-06-15T18:55:03.283
13
votes
7
answers

mysql select where count = 0

mysql
asked 2010-06-15T12:25:31.947
11
votes
6
answers

Can I get the full query that a PreparedStatement is about to execute?

java mysql prepared-statement
asked 2010-06-14T15:32:01.137
20
votes
3
answers

Import CSV to MySQL

mysql csv load-data-infile
asked 2010-06-11T19:28:40.077
31
votes
11
answers

Get the first and last date of next month in MySQL

sql mysql
asked 2010-06-09T20:59:10.500
10
votes
5
answers

mysql_real_escape_string() just makes an empty string?

php mysql ajax mysql-real-escape-string
asked 2010-06-09T10:58:15.867
524
votes
8
answers

How do I add indexes to MySQL tables?

mysql optimization indexing row
asked 2010-06-09T01:41:23.900
35
votes
6
answers

Ruby, Rails: mysql2 gem, does somebody use this gem? Is it stable?

mysql ruby-on-rails ruby
asked 2010-06-08T20:57:00.883
218
votes
20
answers

Access denied for user 'root@localhost' (using password:NO)

mysql wordpress mysql-error-1045
asked 2010-06-08T05:53:09.327
21
votes
4
answers

Is it safe to delete rotated MySQL binary logs?

mysql binary-log
asked 2010-06-07T12:00:10.513
17
votes
5
answers

Convert T-SQL to MySQL

mysql t-sql
asked 2010-06-06T23:46:37.377
11
votes
6
answers

PHP & MYSQL: using group by for categories

php mysql
asked 2010-06-04T19:36:44.113
262
votes
21
answers

How to use MySQLdb with Python and Django in OSX 10.6?

python mysql django virtualenv virtualenvwrapper
asked 2010-06-01T18:18:10.243
22
votes
3
answers

Unix timestamp vs datetime

php mysql sql datetime unix-timestamp
asked 2010-06-01T09:17:13.530
12
votes
3
answers

Lexing partial SQL in C#

c# sql mysql parsing lexer
asked 2010-05-30T17:58:02.743
14
votes
4
answers

What is the unit in returned by MySQL GLength method?

mysql geospatial
asked 2010-05-28T20:24:13.687
15
votes
14
answers

SQL hidden techniques?

sql mysql sql-server postgresql
asked 2010-05-28T16:08:28.897
9
votes
1
answers

mysql replace into alternative

mysql replace
asked 2010-05-28T15:41:25.490
12
votes
3
answers

MySQL, delete and index hint

mysql query-optimization sql-delete sql-execution-plan
asked 2010-05-27T20:33:14.250
53
votes
5
answers

Many-to-many relationships examples

mysql many-to-many
asked 2010-05-27T18:29:42.077
30
votes
6
answers

How can I implement an "interesting tags" feature like that on Stack Overflow?

php jquery mysql tags
asked 2010-05-26T16:51:41.890
12
votes
3
answers

Extract the Day / Month / Year from a Timestamp on MYSQL

php mysql datetime timestamp
asked 2010-05-24T22:23:11.883
38
votes
13
answers

Storing Credit Card Numbers in SESSION - ways around it?

php mysql session credit-card
asked 2010-05-24T20:43:43.730
18
votes
8
answers

Hibernate constraint ConstraintViolationException. Is there an easy way to ignore duplicate entries?

java mysql hibernate
asked 2010-05-23T23:35:09.187
178
votes
4
answers

How do I escape reserved words used as column names? MySQL/Create Table

mysql escaping
asked 2010-05-22T21:43:59.633
38
votes
9
answers

How to remove duplicate entries from a mysql db?

mysql duplicates
asked 2010-05-19T16:35:17.380
9
votes
4
answers

best way to change the date format in mysql SELECT?

mysql
asked 2010-05-19T07:38:54.397
12
votes
3
answers

NoSQL or Ehcache caching?

mysql hibernate nosql ehcache neo4j
asked 2010-05-19T01:53:35.623
26
votes
1
answers

How does Wordpress link posts to categories in its database?

mysql wordpress
asked 2010-05-17T11:13:46.260
9
votes
1
answers

SQL for total count and count within that where condition is true

sql mysql count
asked 2010-05-16T06:30:41.787
13
votes
4
answers

MySQL Query to get count of unique values?

mysql database
asked 2010-05-14T06:43:53.230
18
votes
4
answers

Migrate from MySQL to PostgreSQL on Linux (Kubuntu)

mysql postgresql database-migration
asked 2010-05-13T23:48:44.667
31
votes
2
answers

MySQL: how to index an "OR" clause

mysql indexing composite where-clause
asked 2010-05-13T19:09:47.403
89
votes
7
answers

MySQL: How to add one day to datetime field in query

mysql sql
asked 2010-05-11T12:11:38.497
23
votes
7
answers

Creating a MySQL view with an auto-incrementing id column

mysql view
asked 2010-05-11T07:22:08.440
23
votes
5
answers

Foreign keys and NULL in mySQL

mysql sql database-design foreign-keys database-relations
asked 2010-05-10T12:26:25.000
13
votes
4
answers

What's the best way to store sensitive data in MySQL?

php mysql security encryption cryptography
asked 2010-05-09T13:07:13.240
55
votes
10
answers

Group mysql query by 15 min intervals

mysql sql datetime group-by timestamp
asked 2010-05-08T12:13:02.297
← Prev page 28 of 41 Next →