Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 10 of 41

Sort by: Newest Votes Active
18
votes
2
answers

Update table with SUM from another table

mysql sum
asked 2012-04-10T15:08:40.427
8
votes
9
answers

mysql - if value = 0 shorten where statement

php mysql where-clause
asked 2012-04-10T14:18:52.713
8
votes
1
answers

How to create and execute procedures in MySQL workbench

mysql mysql-error-1064
asked 2012-04-10T07:03:22.570
17
votes
3
answers

How to remove characters from end of field in MySql database

php mysql
asked 2012-04-10T03:11:01.747
17
votes
6
answers

Foreign key constraint is incorrectly formed?

mysql
asked 2012-04-09T18:48:03.357
12
votes
6
answers

In MySQL, how do I batch rename tables within a database?

mysql joomla1.5
asked 2012-04-08T21:42:06.163
47
votes
23
answers

Insert array into MySQL database with PHP

php mysql arrays
asked 2012-04-07T12:49:10.487
8
votes
3
answers

Sharding and Transactions with MySQL

mysql transactions sharding
asked 2012-04-07T03:32:09.263
32
votes
2
answers

Mysql Add a new value to a column of data type enum

mysql ddl
asked 2012-04-06T17:50:51.833
8
votes
1
answers

Can I use MySQL interactively from an SQL block in org-mode?

mysql sql emacs org-mode
asked 2012-04-05T15:28:42.300
16
votes
2
answers

MySql Select, Count(*) and SubQueries in Users<>Comments relations

mysql sql subquery aggregate-functions
asked 2012-04-05T04:05:13.113
43
votes
6
answers

SELECT that returns list of values not occurring in any row

mysql
asked 2012-04-04T14:42:22.837
8
votes
1
answers

Passing FieldName as Parameter in MySQL Stored Procedure

mysql
asked 2012-04-03T13:06:29.277
46
votes
6
answers

MySQL Performance - "IN" Clause vs. Equals (=) for a Single Value

php mysql performance
asked 2012-03-29T13:33:44.833
8
votes
2
answers

How to implement remember me feature?

php mysql session cookies
asked 2012-03-27T13:44:29.440
23
votes
5
answers

Replace nulls values in sql using select statement in mysql?

mysql sql
asked 2012-03-26T18:21:33.823
18
votes
2
answers

How to ignore characters on a MYSQL SELECT LIKE %...%

mysql select wildcard sql-like
asked 2012-03-24T08:19:55.210
40
votes
8
answers

Using MySQL in Flask

python mysql web-services flask
asked 2012-03-23T19:06:52.320
49
votes
5
answers

How to make the mysql MEMORY ENGINE store more data?

mysql memory
asked 2012-03-23T16:16:26.373
9
votes
5
answers

mysql row locking via php

php mysql locking row
asked 2012-03-21T23:11:17.253
16
votes
3
answers

Python-mysql: when to explicitly rollback a transaction

python mysql mysql-python
asked 2012-03-21T09:51:42.247
22
votes
2
answers

Reserved word in column name - insert into MySQL

mysql insert reserved-words
asked 2012-03-21T07:11:38.513
9
votes
7
answers

How to convert mysql data base table data in json using php

php mysql json
asked 2012-03-20T11:12:01.223
11
votes
3
answers

Store mysql subquery in a variable

mysql
asked 2012-03-20T10:57:38.613
14
votes
2
answers

Algorithm using soundex() or metaphone() to create Mad Gab style phrases

php mysql soundex metaphone
asked 2012-03-19T20:06:40.947
161
votes
8
answers

multiple tables broken down into categories vs one table with many columns

mysql database-design
asked 2012-03-19T17:16:45.107
11
votes
2
answers

Is the PDO Library faster than the native MySQL Functions?

php mysql sql pdo
asked 2012-03-19T12:53:32.517
10
votes
3
answers

#1033 - Incorrect information in file: './database_name/table_name.frm'

php mysql phpmyadmin innodb myisam
asked 2012-03-18T18:44:37.250
31
votes
3
answers

Is it possible to define a timestamp column that is not null and has no default and no special behavior on update?

mysql timestamp
asked 2012-03-17T09:49:02.030
27
votes
7
answers

MySQL Create Table as SELECT

mysql database
asked 2012-03-15T07:36:07.603
23
votes
4
answers

Libpuzzle Indexing millions of pictures?

php mysql compare similarity image
asked 2012-03-14T14:19:32.877
175
votes
27
answers

MacOSX homebrew mysql root password

mysql macos
asked 2012-03-14T03:07:48.997
48
votes
8
answers

MYSQL Date Time Round To Nearest Hour

mysql datetime
asked 2012-03-13T07:49:28.333
8
votes
2
answers

MySql JDBC timeout even with 'autoReconnect=true'

mysql jdbc timeout
asked 2012-03-12T20:17:40.403
27
votes
7
answers

Multiple IF statements on MYSQL

mysql if-statement multipleselection
asked 2012-03-10T17:19:09.613
10
votes
1
answers

MySQL - Different Engines for Different Tables

mysql join innodb myisam
asked 2012-03-10T16:26:44.767
11
votes
2
answers

Simplified/shorthand SQL Data Definition Languages?

mysql sql database-schema ddl shorthand
asked 2012-03-09T20:33:19.470
11
votes
3
answers

Keeping integrity between two separate data stores during backups (MySQL and MongoDB)

mysql mongodb backup
asked 2012-03-08T17:05:42.217
34
votes
2
answers

How to schedule a MySQL query?

mysql scheduled-tasks
asked 2012-03-08T16:42:07.357
15
votes
7
answers

Most efficient way to search in SQL?

mysql sql
asked 2012-03-06T18:36:20.847
18
votes
4
answers

How can I select rows in reverse order in MySQL?

mysql sql
asked 2012-03-06T11:05:22.310
33
votes
13
answers

Table is 'read only'

mysql freebsd sql-update
asked 2012-03-05T23:50:57.593
307
votes
15
answers

Difference between primary key and unique key

mysql sql database primary-key unique-key
asked 2012-03-05T11:39:53.707
11
votes
5
answers

MySQL return first row of a joined table

php mysql sql join greatest-n-per-group
asked 2012-03-04T21:52:21.143
8
votes
4
answers

MYSQL, set two variables in stored proc with single select statement

mysql variables select procedure
asked 2012-03-02T21:20:02.423
16
votes
16
answers

Finding and dealing with duplicate users

mysql sql
asked 2012-03-02T21:00:34.990
10
votes
4
answers

SQL select some rows in a table so that they sum up to certain value

mysql select sum
asked 2012-03-01T23:16:07.787
9
votes
2
answers

Why can't MySQL optimize this query?

mysql
asked 2012-03-01T18:44:56.453
18
votes
3
answers

warning remove database

mysql database qt
asked 2012-03-01T16:12:37.303
16
votes
9
answers

Prevent SQL injection attacks in a Java program

java mysql sql sql-injection
asked 2012-03-01T12:56:33.643
← Prev page 10 of 41 Next →