1. MySQL Query help.. coderanch.com |
2. mysql query coderanch.comThe 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.comjust 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.comI 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.comHi 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.comhello 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 |
9. how to use triggers on mysql - query produce error coderanch.com |
10. Mysql Query.. how to get a difference in 2 results?? coderanch.comThere 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.comHi 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.comI 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.comThis 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.orgGood 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.orgHi 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.orgHere 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.orgtry{ 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.orgHello 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.comHi 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.comHey 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.comMaybe 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 |
26. Displaying Japanese in Browser from MySQL query forums.oracle.com |
27. how to cache mysql query results? forums.oracle.comMy 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.comHi everyone pls forgive me i am new to java. can someone pls tel me where i am going wrong wit this mysql query? |
29. MYSQL Query Real Time forums.oracle.comHi. 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.comHy . 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.comHello, 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.comHi 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 ... |