Questions tagged [mysql]

12

votes

3

answers

ActiveRecord3 deadlock retry

mysql ruby-on-rails-3 deadlock

asked 2010-10-26T20:23:17.370

58

votes

9

answers

How to extract the nth word and count word occurrences in a MySQL string?

mysql regex word-count

asked 2010-10-26T07:24:34.263

10

votes

2

answers

In MySQL, is it faster to delete and then insert or is it faster to update existing rows?

php mysql performance yii

asked 2010-10-26T02:25:22.230

17

votes

2

answers

How to create a sitemap using PHP & MySQL

php mysql sitemap

asked 2010-10-25T21:13:41.553

9

votes

2

answers

mysql schema changes with master & slave

mysql

asked 2010-10-25T13:38:49.437

9

votes

5

answers

Login/Registration System with php and mysql

php mysql authentication

asked 2010-10-25T00:03:49.577

31

votes

5

answers

UNION ALL and LIMIT in MySQL

mysql

asked 2010-10-24T13:45:25.663

436

votes

21

answers

Error 1046 No database selected, how to resolve?

sql mysql database mysqlcommand mysql-error-1046

asked 2010-10-23T18:19:23.200

9

votes

3

answers

left join with condition for right table in mysql

sql mysql left-join

asked 2010-10-23T04:03:28.057

20

votes

7

answers

How can I speed up MySQL query with multiple joins

sql mysql join

asked 2010-10-21T16:13:08.230

11

votes

5

answers

Commercial license for MariaDB

mysql licensing mariadb

asked 2010-10-20T14:32:44.977

45

votes

7

answers

MySQL timestamp select date range

mysql timestamp

asked 2010-10-20T10:28:18.993

24

votes

6

answers

How can I check (My)SQL statements for syntactical correctness

mysql lint syntax-checking

asked 2010-10-19T16:43:44.553

13

votes

3

answers

CakePHP: No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

php mysql cakephp mysql-error-2002

asked 2010-10-19T11:53:42.137

124

votes

12

answers

UnicodeEncodeError: 'latin-1' codec can't encode character

python mysql unicode pylons

asked 2010-10-15T13:57:07.540

37

votes

2

answers

How can I access the table comment from a mysql table?

mysql comments

asked 2010-10-15T02:04:28.537

9

votes

6

answers

Extracting a table from a mysql.sql dump file

sql mysql linux scripting

asked 2010-10-14T17:41:52.433

12

votes

10

answers

Database design - primary key naming conventions

mysql database

asked 2010-10-14T13:46:50.820

83

votes

4

answers

MySQL InnoDB foreign key between different databases

mysql database foreign-keys innodb

asked 2010-10-11T09:32:41.537

35

votes

3

answers

How to use MySQL JDBC driver in an SBT Scala project?

mysql scala jdbc sbt

asked 2010-10-09T15:26:06.047

12

votes

3

answers

Escaping hyphens with the mysql commandline tool

mysql

asked 2010-10-09T08:32:54.743

11

votes

2

answers

GRANT DELETE ON database.table TO username@'%';

mysql mysql-error-1142

asked 2010-10-08T15:08:12.463

147

votes

15

answers

Convert MySQL to SQlite

mysql sqlite

asked 2010-10-08T12:38:12.340

57

votes

5

answers

Why is GRANT not working in MySQL?

mysql sql-grant

asked 2010-10-07T23:41:50.847

13

votes

2

answers

Sql query to find things tagged with all specified tags

sql mysql ruby-on-rails tags tagging

asked 2010-10-06T19:38:11.587

103

votes

3

answers

JPA: how do I persist a String into a database field, type MYSQL Text

java mysql orm jpa

asked 2010-10-05T21:59:05.240

20

votes

2

answers

Make a single table in mysql read-only

mysql

asked 2010-10-05T07:18:48.177

14

votes

2

answers

Social web application database design: how can I improve this schema?

mysql database database-design schema social-networking

asked 2010-10-02T05:11:40.463

166

votes

5

answers

mysql check collation of a table

mysql collation

asked 2010-09-30T15:20:23.073

55

votes

1

answers

Is it possible to insert data into a MySQL view?

sql mysql updatable-views

asked 2010-09-29T21:17:55.897

139

votes

8

answers

What is InnoDB and MyISAM in MySQL?

mysql innodb myisam

asked 2010-09-29T04:36:38.657

20

votes

2

answers

SQL update one column from another column in another table

mysql join sql-update

asked 2010-09-29T03:25:40.813

38

votes

4

answers

concat the output of the subquery?

mysql

asked 2010-09-28T12:51:46.527

16

votes

5

answers

How to load mysql dump to hsqldb database?

mysql groovy migration hsqldb

asked 2010-09-28T10:46:20.350

14

votes

5

answers

"WHERE column IS NOT NULL" with Kohana v3 Query Builder

php mysql database kohana kohana-3

asked 2010-09-26T00:50:02.943

9

votes

2

answers

How to SUM() multiple subquery rows in MySQL?

mysql

asked 2010-09-24T09:03:57.017

30

votes

5

answers

Float or decimal for prices?

mysql sql sql-server database database-design

asked 2010-09-22T11:24:48.117

27

votes

9

answers

Where are Custom Menus saved in the Database for Wordpress 3.0?

mysql wordpress

asked 2010-09-22T09:02:44.800

40

votes

4

answers

How to combine multiple columns as one and format with custom strings?

mysql select

asked 2010-09-21T06:09:32.480

23

votes

1

answers

Mysql - find a table in all database

sql mysql database

asked 2010-09-21T01:41:07.930

25

votes

6

answers

mysql: Copy table structure including foreign keys

mysql

asked 2010-09-20T21:20:07.637

14

votes

4

answers

Mysqltuner suggestions and changes to my.cnf

mysql performance wordpress

asked 2010-09-20T16:37:39.507

161

votes

8

answers

Boolean vs tinyint(1) for boolean values in MySQL

sql mysql boolean tinyint

asked 2010-09-20T13:21:52.453

31

votes

1

answers

Search for value within BLOB column in MySQL

php mysql search blob

asked 2010-09-19T17:43:05.253

11

votes

5

answers

Stop MySQL Reusing AUTO_INCREMENT IDs

sql mysql

asked 2010-09-15T13:45:21.703

16

votes

5

answers

How to SHOW COLUMNS from a SELECT query (rather than a table)?

java mysql database-metadata

asked 2010-09-15T09:47:44.007

10

votes

4

answers

Does MySQL Short Circuit the IF() function?

mysql short-circuiting

asked 2010-09-14T21:35:32.083

12

votes

1

answers

How to REGEXP for numbers that begin with a specific number in MySQL?

mysql regex

asked 2010-09-14T20:35:11.757

442

votes

7

answers

Does MySQL ignore null values on unique constraints?

mysql database unique-constraint

asked 2010-09-14T19:29:22.187

12

votes

4

answers

Check if a row could be deleted in MySQL

mysql foreign-keys delete-row

asked 2010-09-14T18:37:37.007

Questions tagged mysql