SQL Aggregator

Hello, I am a graphic designer who does some web design on the side. The store I work at had a website that the boss wanted transferred to a different host. So I downloaded it off the server and uploaded it onto a new one. I knew that I was going to have problems once it was uploaded because the...

hello friends.... I am PHP programmer using mysql as my database... Now it is the time to make fast all my queries ,which im using in my programming... I heard about indexing... Tel me what is indexing,how to put indexing to my table... mainly what are the advantages and disadvantages...or any...

I am using MySQL Connector/J 5.1.6, and I've got the following exception in my application: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1516)

-- moved topic --

Hi All, I am using mysql 5.0.8 connector and tomcat 6.0.10 DBCP. My Application works well for few weeks, but after few weeks it get fail reporting the error, com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 1553186 ms ago. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)

Dear folk, what should I use for Price Field in Data base I have used BigInt But I know I could do it with Decimal , I ned to do it without any Limitation of the size of the digits and the numbers after dot ( . ) so what is the solution .... thanks

I am trying to connect to a web based MySQL database using the ODBC connector, the problem I have is that the user name and database name are 16 characters in length. The connector truncates these to 12 when it tries to connect and therefore displays an error as the information being passed is incorrect. Is there a way of bypassing this truncation in order to send the full user name and database fields? I have tried contacting our ISP to shorten the names and they basically said no it's impossible!!

Hi what sql query will I use to checks the "users_theme" table and finds all the user_id's which exist in this table and not the "users" table. Once I have those id's that exist in the user_theme table that does not exisit in the users table I want to delete all rows with that user id from the...

Sorry for making another post about this common issue, but I have been searching around and the solutions I have found does not work. What seems to be the problem for most people is the skip-networking line in the config file. That line was never there in the my.cnf file so that is not the issue. I have also tried to set the bind address to the servers address and I have tried to uncomment the bind address line.

Hello, I want to ensure that rows inserted into a database table are unique based upon a set of keys (more than the 16 allowed by my version of mysql for PKs). I am new to triggers and do not know how to implement a trigger that would perform such a check. Can anyone please help? Code samples or links welcome. Thanks in advance, Julien.