Questions tagged [mysql]

8

votes

5

answers

Combine two queries to check for duplicates in MySQL?

mysql sql

asked 2013-05-08T20:13:20.370

10

votes

2

answers

How to write a query with join, update and order by?

mysql sql join sql-update sql-order-by

asked 2013-05-08T15:27:55.197

22

votes

1

answers

Plugin 'FEDERATED' is disabled

mysql database easyphp

asked 2013-05-07T09:56:30.723

24

votes

6

answers

How to make JOIN query use index?

mysql sql join query-optimization

asked 2013-05-05T14:45:19.260

9

votes

3

answers

Mysql - Mysql2::Error: Incorrect string value:

mysql

asked 2013-05-03T01:38:50.443

11

votes

2

answers

How to connect to two databases in one connection string in C#?

c# mysql database

asked 2013-05-02T07:01:49.323

12

votes

3

answers

Any reason to still use snake case for database tables and columns?

mysql database database-design relational-database

asked 2013-04-29T21:31:29.870

57

votes

7

answers

Decrement value in mysql but not negative

mysql decrement

asked 2013-04-29T11:19:41.630

8

votes

3

answers

Priority of AND and OR operator in Mysql select query

mysql operator-precedence

asked 2013-04-27T08:14:52.283

70

votes

6

answers

MySQL LEFT JOIN 3 tables

mysql sql join

asked 2013-04-25T18:30:56.777

30

votes

4

answers

find number of rows in returned mysql result (nodejs)

mysql node.js

asked 2013-04-24T18:47:08.630

11

votes

1

answers

How to migrate database from Postgres to MySQL?

mysql postgresql migration

asked 2013-04-24T10:36:13.270

30

votes

15

answers

Installing MySQL Python on Mac OS X

python mysql macos

asked 2013-04-24T02:18:04.417

36

votes

9

answers

C# with MySQL INSERT parameters

c# mysql database sql-insert

asked 2013-04-23T11:15:06.727

48

votes

1

answers

How to design a hierarchical role based access control system

php mysql permissions hierarchy rbac

asked 2013-04-22T04:59:47.347

16

votes

3

answers

Best way to handle large (UUID) as a MySQL table primary key

php mysql hex decimal

asked 2013-04-20T17:03:44.357

14

votes

1

answers

What is the maximum possible value range of MATCH ('...' IN NATURAL LANGUAGE MODE) in MySQL?

mysql full-text-search relevance match-against

asked 2013-04-20T00:54:57.257

39

votes

4

answers

Inner join with 3 tables in mysql

mysql database inner-join

asked 2013-04-15T10:52:45.540

13

votes

4

answers

MySQL ON UPDATE CASCADE not CASCADEing

mysql foreign-keys cascade

asked 2013-04-12T17:45:25.037

18

votes

3

answers

MySQL: what does @@ mean?

mysql

asked 2013-04-12T01:08:16.490

9

votes

5

answers

Magento Product Flat Data and Catalog Search Index issue

php mysql magento

asked 2013-04-11T14:12:57.160

19

votes

2

answers

Show MySQL tables starting with prefix?

mysql

asked 2013-04-09T15:55:23.743

23

votes

3

answers

In MySQL, which is more efficient: IFNULL or NULLIF?

mysql ifnull null-test

asked 2013-04-08T23:52:38.157

8

votes

2

answers

Meaning? header('P3P:CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"');

php mysql header

asked 2013-04-05T18:43:57.173

8

votes

4

answers

Should SQL functions be uppercase or lowercase?

mysql sql function sql-function

asked 2013-04-04T14:14:40.427

11

votes

2

answers

Rename Root @ local host username mySQL

mysql

asked 2013-04-02T15:59:52.593

18

votes

7

answers

how to get mysql row size in GB

mysql

asked 2013-03-30T05:54:24.917

46

votes

4

answers

MySQL Select Distinct Count

mysql

asked 2013-03-29T20:28:11.660

50

votes

9

answers

How to enable explicit_defaults_for_timestamp?

mysql

asked 2013-03-29T10:39:15.503

177

votes

29

answers

Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

mysql macos navicat tablespace

asked 2013-03-28T23:49:53.377

102

votes

5

answers

mysqldump - Export structure only without autoincrement

export mysql database-schema auto-increment

asked 2013-03-27T10:20:06.807

134

votes

6

answers

jQuery UI Sortable, then write order into a database

php jquery mysql jquery-ui jquery-ui-sortable

asked 2013-03-26T09:22:27.670

28

votes

2

answers

How to structure and query an appointment system based on time slots where each bookable entity has a different time table daily?

mysql database-design relational-database

asked 2013-03-26T00:41:28.253

8

votes

4

answers

How to find the hierarchy path for a tree representation

mysql sql hierarchical-data

asked 2013-03-23T06:23:11.623

22

votes

1

answers

iOS - Core Data and Server Database Synchronization Best Practices

mysql ios core-data synchronization

asked 2013-03-22T02:04:18.777

22

votes

4

answers

Is doing Transaction Management in the Controller bad practice?

php mysql design-patterns transactions

asked 2013-03-21T01:35:57.547

11

votes

3

answers

Magento model won't save values

php mysql magento model module

asked 2013-03-19T21:05:39.733

17

votes

3

answers

MySQL: Dramatically slower query execution if use LIMIT 1 instead of LIMIT 5

mysql performance indexing limit

asked 2013-03-17T11:14:58.780

10

votes

3

answers

mysql_install_db gives FATAL ERROR: Could not find my-default.cnf

mysql database installation

asked 2013-03-16T16:25:27.847

22

votes

8

answers

mysql_secure_installation "Can't connect to local MySQL server through socket"

mysql database-administration mysql-error-2002

asked 2013-03-15T18:07:12.277

44

votes

8

answers

How to group by DESC order

mysql sql group-by

asked 2013-03-13T15:59:44.897

10

votes

3

answers

How to make a multiple column mysql fulltext search where partial words are matched

php mysql sql full-text-search

asked 2013-03-12T20:55:39.753

13

votes

4

answers

SQL: Binary to IP Address

mysql string binary string-formatting

asked 2013-03-12T19:47:09.740

9

votes

4

answers

Fastest way to get JSON object into mysql using node

mysql node.js

asked 2013-03-12T17:01:16.553

18

votes

4

answers

Pasting SQL into the MySQL command line

mysql

asked 2013-03-12T15:11:02.360

8

votes

2

answers

Parsing extremely large XML files in php

php mysql xml xml-parsing large-files

asked 2013-03-12T14:24:36.487

10

votes

5

answers

How to create Triggers to add the change events into Audit Log tables

mysql triggers audit-logging audit-trail change-data-capture

asked 2013-03-12T09:27:54.900

8

votes

2

answers

MySql - concat in query with left outer join

mysql select left-join concatenation

asked 2013-03-09T17:27:49.263

8

votes

2

answers

SQLAlchemy necessary table properties

mysql reflection sqlalchemy create-table

asked 2013-03-08T14:21:57.903

10

votes

1

answers

MySQL: Grouped/Ordered/Left Join query very slow

mysql group-by sql-order-by left-join

asked 2013-03-07T13:46:45.543

Questions tagged mysql