Top "Mysql" questions

As I SET cust_fax in a table in MySQL like this: cust_fax integer(10) NOT NULL, and then I …

I have this MySQL query. I have database fields with this contents sports,shopping,pool,pc,games shopping,pool,pc,…

Is it possible to change my default MySQL data directory to another path? Will I be able to access the …

I'm trying to figure out how to locate all occurrences of a url in a database. I want to search …

I've just started getting into Node.js. I come from a PHP background, so I'm fairly used to using MySQL …

ID FirstName LastName 1 John Doe 2 Bugs Bunny 3 John Johnson I want to select DISTINCT results from the FirstName column, but …

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them?

I created a table in MySQL with on column itemID. After creating the table, now I want to change this …

How do I get the current AUTO_INCREMENT value for a table in MySQL?

I have a MySQL table which is as follows: id | name | parent_id 19 | category1 | 0 20 | category2 | 19 21 | category3 | 20 22 | category4 | 21 ...... Now, I want …