Query 2 « mysql « Java Database Q&A





1. MySQL Query help..    coderanch.com

2. mysql query    coderanch.com

The password supplied was incorrect or you don't have permission to login as root from "localhost". Note that to MySQL "localhost" is a hostname and is not the same as the actual name of your machine. You shouldn't be loggin in as mysql root anyway. Create a new user. Make sure to specify which hosts the user can connect from. Assign ...

3. Java & MYSql query    coderanch.com

just a quick question regarding java and its capabilities with MYSql as i havent had much experience on it (gota book coming this week) im building a employee database application (database in MYSql, interface in Java obviously) which will allow the user to browse through and perform some functions on the database. the GUI will display all the the information in ...

4. Query problem with MySQL 5    coderanch.com

I have a small query problem that I cannot solve. I have an result table which contain all game results mysql> select * from result; +----+---------------------+------------------+-----------+---------+-------+ | id | created | points | player_id | game_id | round | +----+---------------------+------------------+-----------+---------+-------+ | 1 | 2006-06-13 12:52:30 | 3811.88333333333 | 4 | 3 | 0 | | 2 | 2006-06-13 12:53:33 | 3804.55 ...

5. mySql like,query    coderanch.com

6. SQL query problem with MySQL    coderanch.com

Hi guys, I have a table called 'USER', I've just added a new colum (attribute) called regDate (type varchar). Now all the existing records have regDate set to NULL, what I want to do is change all the NULL values to some date. My query is as follow UPDATE USER SET regDate = '19/07/2007 1.11pm' WHERE regDate = NULL; This doesn't ...

7. MySql Query Browser problem!    coderanch.com

hello all! i am having a problem with mySql Query Browser and i dont know how to solve it.. i use query Browser to add data in my tables.The problem is that when i try to enter data in greek i get the message Data too long. That message appears even if a write a single letter (and the column is ...

8. MySQL Query    coderanch.com





10. Mysql Query.. how to get a difference in 2 results??    coderanch.com

There isn't a general-purpose thing for finding the difference between two query results. For all we know those queries were based on completely unrelated tables. However if it's a more well-conditioned problem, for example the two queries are related in some way, then it's possible that there could be a variation of query #2 which returns the desired result. Would you ...

11. mysql_query()    coderanch.com

12. Sorting Query problem in MySQL    coderanch.com

Hi all, I developed a Web Application and successfully launched it too. But a day after, the client comes up with a problem.In my application, i use a button to generate number(A number used for reference in my project) and i checked it from two digits numbers. But when they gave 9 and after that the value doesnt get incremented from ...

13. Mysql query    coderanch.com

14. Mysql query    coderanch.com

I am new to mysql, please can anyone explain me the below line KEY `aircraft_model_code` (`aircraft_model_code`) There are two tables created which are as follows. CREATE TABLE `aircraft` ( `tail_num` char(6) NOT NULL default '', `aircraft_serial` char(20) NOT NULL default '', `aircraft_model_code` char(7) NOT NULL default '', `aircraft_engine_code` char(5) NOT NULL default '', `year_built` year(4) NOT NULL default '0000', `aircraft_type_id` tinyint(3) ...

15. Strange problem with MySQL full text query    coderanch.com

This probably has something to do with my understanding of full text search or perhaps a known issue. My Java code creates search term for full text search on MySQL like this - +word* This works fine if the value in the DB column contains more text than the word itself. However, if the value is exact - no result are ...

16. Eclipse MySQL query    java-forums.org

Good day people of Java Forums. I have a little bit of a problem. I am trying to code a java file to authenticate login information from MySQL and it will output a boolean value to the other java file. All of the underlined words show a "cannot be resolved" message and I can't seem to know why. Any kind of ...





17. mysql query performance issue    java-forums.org

Hi All, I am using testlink tool with mysql ( teamst.org/phpBB2/viewtopic.php?t=1938 ). I have found that this query takes 54 secs to fetch data..which is not acceptable.. I am not conversant with mysql tuning... SELECT NHB.parent_id AS testsuite_id, NHA.parent_id AS tc_id, NHB.node_order AS z, T.tcversion_id AS tcversion_id, T.id AS feature_id, TCV.active, E.id AS exec_id, E.tcversion_id AS executed, E.testplan_id AS exec_on_tplan, UA.user_id,UA.type, ...

18. MySQl query taking too much time    java-forums.org

Here is my MySQL query..it takes a lot of time to execute and show results. the results is the content of a set of 24000 articles. SELECT Content FROM AQUA_MASTER WHERE Article_ID IN (SELECT Article_ID FROM AQUA_TAGGING WHERE Tag_ID=1736); why is that? can somebody tell me how i can solve this problem? jessie

19. MySQL JDBC query returns no response    java-forums.org

try{ PCSSafe.sql.result = PCSSafe.sql.sql_statement.executeQuery("SELECT * from pcs_config WHERE cfg_id = 1"); if(PCSSafe.sql.sql_statement.getFetchSize() == 0){ System.out.println("No results from config load"); } PCSSafe.sql.result.next(); --> cassette[0].contents[0] = PCSSafe.sql.result.getInt("cfg_V1_1s"); cassette[0].contents[1] = PCSSafe.sql.result.getInt("cfg_V1_2s"); cassette[0].contents[2] = PCSSafe.sql.result.getInt("cfg_V1_5s"); cassette[0].contents[3] = PCSSafe.sql.result.getInt("cfg_V1_10s"); cassette[0].contents[4] = PCSSafe.sql.result.getInt("cfg_V1_20s"); cassette[0].contents[5] = PCSSafe.sql.result.getInt("cfg_V1_50s"); cassette[0].contents[6] = PCSSafe.sql.result.getInt("cfg_V1_100s"); cassette[0].balance = PCSSafe.sql.result.getFloat("cfg_V1_bal"); cassette[0].denomination = PCSSafe.sql.result.getInt("cfg_V1_denom"); cassette[0].field = PCSSafe.sql.result.getString("cfg_V1_field"); cassette[0].name = PCSSafe.sql.result.getString("cfg_V1_name"); } catch (Exception e){ System.out.println(e); } ...

20. Problem with mysql query in for loop    java-forums.org

Hello all, i have been making a tool for work which stores data such as account attributes in a database, then allows you to search through the database using simple sql queries. All has been fine with being able to add a new row to a table in a database, delete a row, count the number of rows and make a ...

21. how to pass mysql query id through url parameter to a detail page    forums.oracle.com

Hi there, I am a newbie to JSP and I am trying to pass a url parameter to a detail page so that it will query a mysql data query to show the details of that query. How can I write the query on the details page so that it will display the query results on the page. eg select * ...

22. I need to do a select query against a mysql db in my java project    forums.oracle.com

Hey guys! I hope you can help me! I have a column "date" in my table of my MySQL DataBase. Well, when I prepare my statement in my java program, I can't compare a date to get all the rows where the date is the one that I'm trying to compare. I'm trying to do something like this: ResultSet rs = ...

23. Need help with MySQL Query...Again    forums.oracle.com

24. don't get a result set from a query to mySql database    forums.oracle.com

Maybe it's not the function executeQuery(query) that gives you the nullpointer. I think it may be that there is no connection to the DB, in which case the statement variable is null. Call to a method through this variable will trigger a nullpointer. Could you please post the exception text here? It may tell you where the NullPointerException occurs. //Chris

25. Query on mysql    forums.oracle.com

27. how to cache mysql query results?    forums.oracle.com

My program fills combo boxes from database and it's kinf of slow I want my window to open in split second but it takes like 1-2 seconds. So I'm thinking maby I should get all necessery variables loaded before I open any windows? Because I have 5 windows and more in future then where should I save my data so that ...

28. help with mysql query plz anyone i am begging!!!    forums.oracle.com

Hi everyone pls forgive me i am new to java. can someone pls tel me where i am going wrong wit this mysql query? SELECT ParishName, OwnerOccupierHousehold, OwnerOccupierPercOfOverall, OwnerOccupierCo2Emissions, SocialRentedHousehold, SocialRentedPercOfOverall, SocialRentedCo2Emissions, PrivateRentedHousehold, PrivateRentedPercOfOverall, PrivateRentedCo2Emission, TotalHouseholds, TotalPerc, Average, Total2001, TotalEstimatedTotal2006, EmissionsPerPerson, EmissionPerHousehold, EmissionsPerParish, EnergyChampionsNeeded, NumberOfPeopleAtWork, NumberOfSchoolAgeChildren FROM base_data as b WHERE b.id = ?

29. MYSQL Query Real Time    forums.oracle.com

Hi. I'm new to java so hang in there with me. What I need to be able to do is have a Java app that queries a very small amount of mysql data every 1 or 2 seconds. I need that data refreshed real time. I have created the project in Netbeans and it queries the mysql data correctly. How do ...

30. Java Mysql query problem    forums.oracle.com

Hy . I am executing a query from a Jframe and the result are displayed in a JTable. The problem is the following: in the db table I have an IP address stored as an Integer , and in order to see the ip "correctly " x.x.x.x , I have to write in the select like this SELECT INET_NTOA(IP_SRC)......... ; in ...

31. how to insert mysql function into query in java    forums.oracle.com

Hello, i've got a problem here : i try to use mysql function NOW() for example: sql query is INSERT INTO users (NAME,TIME) values("John", NOW() ) In java i use bean to connect to DB String query="INSERT INTO users (NAME,TIME) values('john','now()')"; dbaccess.statement.executeUpdate(query); but it doesn't work, it is because there is function NOW() with special characters () how can i solve ...

32. How to get the value of mysql Query.....    forums.oracle.com

Hi CeciNEstPasUnProgrammeur, Thanks for your valuable reply......but tell me in this example how i can get the integer value of query..... I know how to use rst(ResultSet)... Actually i have an application where i have to read data from database to excel file but i am stucking on column value. when i am giving hardcorded value for the column according to ...