Stack Overflow
Stack Overflow

Questions tagged [mysql5]

The MySQL™ software delivers a fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server.

The MySQL™ software delivers a speedy, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server.

MySQL Server is intended for mission-critical, heavy-load production systems and embedding into mass-deployed software.

Active development for MySQL Database Server version 5.0 has ended. Most recent version is .

###Link The reference manual

Related tag

227 questions
1409
votes
16 answers

How can I get a list of user accounts using the command line in MySQL?

I'm using the MySQL command-line utility and can navigate through a database. Now I need to see a list of user accounts. How can I do this? I'm using MySQL version 5.4.1.
burntsugar
  • 57,360
  • 21
  • 58
  • 81
220
votes
6 answers

Are table names in MySQL case sensitive?

Are table names in MySQL case sensitive? On my Windows development machine the code I have is able to query my tables which appear to be all lowercase. When I deploy to the test server in our datacenter the table names appear to start with an…
benstpierre
  • 32,833
  • 51
  • 177
  • 288
71
votes
19 answers

Can't connect to MySQL server on 'localhost' (10061)

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance. Everything worked fine until I got to "Applying Security settings", at which point it gave me the above error (Can't connect to MySQL server on 'localhost' (10061)). I…
Cameron A. Ellis
  • 3,833
  • 8
  • 38
  • 46
58
votes
11 answers

SELECT INTO and "Undeclared variable" error

When I try to execute following query: SELECT id_subscriber INTO newsletter_to_send FROM subscribers I get an error: #1327 - Undeclared variable: newsletter_to_send What is wrong with that query ?
hsz
  • 148,279
  • 62
  • 259
  • 315
53
votes
9 answers

MySQL 1062 - Duplicate entry '0' for key 'PRIMARY'

I have the following table in MySQL version 5.5.24 DROP TABLE IF EXISTS `momento_distribution`; CREATE TABLE IF NOT EXISTS `momento_distribution` ( `momento_id` INT(11) NOT NULL, `momento_idmember` INT(11) NOT NULL, …
Kapil Sharma
  • 10,135
  • 8
  • 37
  • 66
32
votes
2 answers

storing negative value in mysql

How can I store negative value in mysql decimal? I have data from DMS to Decimal having negative values, so it is decimal and negative. So what can I use to store such value?
Hafiz
  • 4,187
  • 12
  • 58
  • 111
27
votes
1 answer

What does the information_schema database represent?

I have one database in mysql. But when i log into phpMyAdmin , it shows another database called information_schema. Is that database always present with one database? I mean to say is there a copy of information_schema for every database present in…
John
22
votes
3 answers

How to take mysql dump of selected columns of a table

I have a requirement in which I have to take mysql dump of just one column of a table. Since that table has too many columns, I don't want to take dump of the full table. I have to get this dump of the table from one server to another. Any idea how…
user1085195
  • 365
  • 2
  • 5
  • 16
21
votes
3 answers

mysql5 - As 'root' can't create database or do anything (Access denied)

I'm on Mac OS X Lion and just installed mysql5 using MacPorts. Then I successfully ran: sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql I'm able to start the server and connect as 'root' fine, but I can't create any databases. $ mysql5…
John Jorgensen
  • 521
  • 1
  • 4
  • 9
20
votes
4 answers

MySQL efficiently copy all records from one table to another

Is there a more-efficent, less laborious way of copying all records from one table to another that doing this: INSERT INTO product_backup SELECT * FROM product Typically, the product table will hold around 50,000 records. Both tables are identical…
crmpicco
  • 16,605
  • 26
  • 134
  • 210
16
votes
3 answers

How to Run PHP on IIS7.5 Express?

I have Win XP SP3 and have installed IIS7.5 Express and want to run PHP on it. I am able to run simple HTML code on the server, I am able to start and stop the server by running iisservices.exe, but I am not able to run php scripts on it. If I have…
Saurabh
  • 161
  • 1
  • 1
  • 3
13
votes
7 answers

JDBC Driver class not found: com.mysql.jdbc.Driver

I am developing a web application using maven spring and hibernate and I need to create schema using hibernate for which I had the following in my pom.xml to connect to MySQL 5.5 database. …
skip
  • 12,193
  • 32
  • 113
  • 153
13
votes
1 answer

MySQL to find all tables with a Full Text indexed column in them

I need to run a repair on all the tables in all my databases on my MySQL5 server because I have updated the MySQL full text search stopwords file. Is there a query or command I can run to do this?
Treffynnon
  • 21,365
  • 6
  • 65
  • 98
12
votes
2 answers

What does using a negative value for MySQL LIMIT do?

So what happens when you use a negative value in a LIMIT clause? Will there be negative consequences (slight pun intended)? I don't see any documentation on this, and MySQL forums, as I recall, sux. Background: I'm using MySQL CE 5.5.20. I wrote a…
b01
  • 4,076
  • 2
  • 30
  • 30
12
votes
2 answers

How to replace all double quotes to single quotes using mysql replace?

I need to replace all double quotes to single quotes using mysql query. How can I do that. My sql should be in double quotes. mysql="select replace(text,'\"',''') from mytable" throwing error. How can I escape that single quotes inside query?
DEVOPS
  • 18,190
  • 34
  • 95
  • 118
1
2 3
…
15 16