The MySQL™ software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server.
0
votes
0answers
11 views
Needed help dynamic pivot query group_concat dynamic column from 4 tables MYSQL
Need help with query
I Have 4 table
table sizes (sizes goods)
DROP TABLE IF EXISTS `size_goods`;
CREATE TABLE `size_goods` (
`id` int(11) NOT NULL ...
1
vote
1answer
88 views
How to Sum multiple Column with multiple value
I am looking for a solution to the following:
Go in to the users table and find a user who has listed items on the site. In this users table, there is no column about auctions. Instead, it is ...
0
votes
1answer
30 views
Sql Query For my case
I Have table in format mentioned below
USER_ID ORDER
1 0
1 1
1 2
1 3
2 0
2 1
2 3
3 0
3 2
I want to find list of user id whose ...
79
votes
5answers
68k views
How to get a list of MySQL user accounts
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.)
2
votes
4answers
10k views
Hibernate: org.hibernate.AssertionFailure: null id in com.xxx.Bean entry
I was faced to the following error:
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract void com.xxx.Service.save(com.xxx.Bean)' threw an unexpected exception: ...
-1
votes
1answer
48 views
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL
I was forced to update to MySQL 5 and PHP 5 as my service provider is no longer supporting older versions. I have a working site with this MySQL search that was working fine. The following is an ...
22
votes
6answers
7k views
Are table names in mysql case sensitive?
Are table names in mysql case sensitive? On my windows dev 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 ...
0
votes
1answer
50 views
MYSQL 4 password hashing -> MYSQL 5
I have a bit of a plight. My mysql 4.1.0 database has to be upgraded (1and1) but it seems the application used PASSWORD() for hashing. With the mysql 5 upgrade PASSWORD() gives an entirely different ...
0
votes
2answers
116 views
Is it possible to put MySQL database in single user mode?
How can I put a MySQL database in single user mode?
Or even better, in read mode only.
I use select * into outputfile in MySQL side and bcp in in Sybase side to pass data and I want them to be the ...
1
vote
5answers
31k views
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.
I do ...
7
votes
4answers
230 views
Handling Deletes/Inserts/Select in a huge table
I have a dating website
In this website i used to send daily 10 photo matches to a user and store them in the structure as
SENDER RECEIVER
11 1
12 1
13 1
14 1
I maintain two ...
5
votes
2answers
8k views
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
Hi
When I try to connect to the datasource using JNDI, I am getting this error:
[org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
...
1
vote
1answer
142 views
SQL finding ancestors/decendants in a self-referencing table
I have a table which references itself, like this:
CREATE TABLE Foo (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
parent INT NULL,
name VARCHAR (30) NOT NULL,
FOREIGN KEY (parent) REFERENCES Foo(id) ...
0
votes
1answer
55 views
Which design to choose and why? [closed]
I have a table structure that stores images like
id image1 image2
example:
1 http://random.com/1_1.gif http://random.com/1_2.gif
2 http://random.com/2_1.gif http://random.com/2_2.gif
3 ...
0
votes
0answers
314 views
MySQL, PHP, and Apache errors while connecting to DB
I'm having two errors when I test the "mysql_connect()" function in php. I just installed PHP and MySQL from scratch. These errors may be related, so I will post them both here:
Warning: ...
