Alex Rivera | Logout

Questions tagged mysql

2049 questions · page 29 of 41

Sort by: Newest Votes Active
9
votes
3
answers

How to simulate "MYSQL has gone away" error?

php mysql
asked 2010-05-08T09:07:35.910
53
votes
10
answers

MySQL - How do I enter NULL?

mysql sql sql-update
asked 2010-05-06T21:37:45.083
238
votes
6
answers

Deleting rows with MySQL LEFT JOIN

mysql left-join delete-row sql-delete
asked 2010-05-04T06:20:32.377
14
votes
5
answers

Fetch HTML page and store it in MYSQL- How to

php mysql html
asked 2010-05-03T21:04:36.683
34
votes
6
answers

Testing performance of queries in mysql

performance testing mysql
asked 2010-05-03T04:23:45.597
11
votes
6
answers

Mysql count how many queries per second are executed, is there any way?

mysql performance lamp metrics
asked 2010-05-02T18:24:05.957
10
votes
6
answers

Post and get at the same time in php

php mysql
asked 2010-05-01T09:20:06.230
23
votes
5
answers

how to find first and last record from mysql table

mysql
asked 2010-04-29T07:13:09.103
9
votes
2
answers

Multiple Rails app, single MySQL database

mysql ruby-on-rails
asked 2010-04-22T12:02:35.967
14
votes
1
answers

Outer select column value in joined subquery?

mysql
asked 2010-04-21T22:41:28.073
9
votes
3
answers

Monitor MySQL table for changes within a C# program?

c# .net mysql
asked 2010-04-21T19:58:56.040
65
votes
7
answers

View all foreign key constraints for entire MySQL database

mysql foreign-keys database
asked 2010-04-21T15:53:09.627
11
votes
2
answers

Resetting AUTO_INCREMENT is taking a long time in MySQL

mysql optimization auto-increment
asked 2010-04-21T09:58:39.300
9
votes
6
answers

How to find root cause for "too many connections" error in MySQL/PHP

php mysql performance
asked 2010-04-15T09:33:09.770
41
votes
3
answers

Multi-Column Primary Key in MySQL 5

mysql key primary-key
asked 2010-04-15T04:41:51.243
10
votes
5
answers

Sending +-200 emails using php mail() function in a loop

mysql email php
asked 2010-04-14T17:11:46.463
35
votes
10
answers

Remove HTML tags from record

mysql
asked 2010-04-13T08:12:38.537
24
votes
6
answers

Does introducing foreign keys to MySQL reduce performance

sql mysql database-design
asked 2010-04-11T19:27:30.500
10
votes
1
answers

Tuning recommendations from mysqltuner.pl: query_cache_limit

mysql
asked 2010-04-11T12:55:01.723
71
votes
8
answers

How can a not null constraint be dropped?

mysql null constraints
asked 2010-04-09T13:25:00.837
26
votes
7
answers

Delete, Truncate or Drop to clean out a table in MySQL

mysql sql-delete sql-drop
asked 2010-04-08T16:16:03.220
23
votes
1
answers

MySQL index cardinality - performance vs storage efficiency

mysql indexing performance cardinality
asked 2010-04-08T02:23:03.197
11
votes
5
answers

How to select all parents of a node in a hierarchical mysql table?

mysql tree hierarchical
asked 2010-04-07T18:07:21.083
54
votes
2
answers

Can I create a database using PDO in PHP?

php mysql pdo
asked 2010-04-06T09:11:30.747
9
votes
5
answers

Is it possible for a Grails Domain to have no 'id'?

mysql hibernate grails grails-orm
asked 2010-04-06T05:49:33.040
25
votes
3
answers

Group MySQL Data into Arbitrarily Sized Time Buckets

mysql time
asked 2010-04-05T17:19:42.907
16
votes
2
answers

MySql Not Like Regexp?

mysql regex numeric
asked 2010-04-05T16:22:52.527
19
votes
13
answers

Can't get access to PHPmyAdmin after setting a root password and using Instant Rails

mysql ruby-on-rails phpmyadmin mysql-error-1045
asked 2010-04-03T02:04:19.427
32
votes
2
answers

MySQL data type: Text,,, Erroring: Data Too Long

mysql coldfusion types
asked 2010-04-03T00:23:46.953
12
votes
5
answers

Is SQLite strong enough to use as wordpress database?

sql mysql sqlite wordpress
asked 2010-04-01T16:33:17.423
9
votes
4
answers

mysql min ignores null - need workaround/tweak

mysql
asked 2010-03-31T13:05:19.047
10
votes
2
answers

How do I INSERT INTO from one mysql table into another table and set the value of one column?

mysql insert
asked 2010-03-31T00:14:55.320
44
votes
4
answers

MySQL: What's the best to use, Unix TimeStamp Or DATETIME

php mysql datetime unix-timestamp
asked 2010-03-28T17:18:16.947
16
votes
10
answers

How can I delete the contents of all tables in my database in phpMyAdmin without dropping the database?

mysql phpmyadmin database-table
asked 2010-03-27T15:09:53.837
28
votes
2
answers

Update multiple rows with one query?

sql mysql
asked 2010-03-27T04:54:35.663
85
votes
7
answers

Search for string within text column in MySQL

mysql search sql-like
asked 2010-03-26T21:10:06.320
19
votes
10
answers

What are advantages of using a one-to-one table relationship? (MySQL)

php mysql database oop
asked 2010-03-26T07:55:11.857
12
votes
6
answers

MySQL - mysqldump --routines to only export 1 stored procedure (by name) and not every routine

mysql
asked 2010-03-25T18:52:21.817
9
votes
4
answers

What's the difference between !col and col=false in MySQL?

sql mysql query-optimization
asked 2010-03-25T16:08:55.410
15
votes
4
answers

Using mysqlimport where the filename is different from the table name

mysql filenames restriction mysqlimport tablename
asked 2010-03-24T14:41:41.990
21
votes
7
answers

Visual Query Builder

mysql windows
asked 2010-03-24T09:47:33.923
26
votes
4
answers

When should I use MySQL compressed protocol?

mysql compression
asked 2010-03-24T09:21:30.743
18
votes
6
answers

How do I print all the queries in Magento?

php mysql magento debugging
asked 2010-03-24T02:14:57.863
11
votes
3
answers

MySQL ignores the NOT NULL constraint

php mysql constraints
asked 2010-03-23T21:20:28.600
15
votes
4
answers

is it a good practice to use mysql_free_result($result)?

php mysql
asked 2010-03-23T17:35:50.167
84
votes
8
answers

Detecting locked tables (locked by LOCK TABLE)

mysql locking
asked 2010-03-23T12:55:01.253
9
votes
3
answers

MySQL: Transactions across multiple threads

mysql multithreading transactions
asked 2010-03-22T20:49:58.657
81
votes
7
answers

How to SELECT rows WHERE column value IS NOT NULL using CodeIgniter's query builder

php mysql codeigniter null query-builder
asked 2010-03-22T00:56:55.227
43
votes
5
answers

Is copying the /var/lib/mysql directory a good alternative to mysqldump?

mysql backup database-backups
asked 2010-03-20T09:17:21.327
50
votes
3
answers

How to concat datatypes like integers(integer with integer) & varchar(varchar with varchar) in mysql?

mysql
asked 2010-03-19T16:45:16.730
← Prev page 29 of 41 Next →