User Profile

Collapse

Profile Sidebar

Collapse
blackflicker
blackflicker
Joined: May 24 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • blackflicker
    replied to How to make connection from Java to MySQL?
    in Java
    Hello WilHob,

    It is really weird. Are you sure that there is a database like that and have you tried to put the .jar into the same directory with your "standalone " application (if it's not a standalone application then you have to put it to the related folder) and adding the path to the classpath. Or/And you may try to pass the class path to the java executable in a parameter too; for just trying. Like:

    java...
    See more | Go to post
    Last edited by blackflicker; May 26 '07, 08:47 AM. Reason: typo

      Leave a comment:

    • blackflicker
      replied to Interrows average value?
      in MySQL
      Hi Motoma,

      Thanks for your time. Your query is really really simple given respectful clues to me how to do the work. Besides, my real table includes a time column which would be sorted before getting an average for row continuity. Actually, the row pattern going to stay as SUM(r2-r1)/COUNT(*)-1, but the rows going to be sorted for the unix epoch time column....
      See more | Go to post

        Leave a comment:

      • blackflicker
        replied to Interrows average value?
        in MySQL
        Hello Pradeep, thanks for your time and the answer. Although not an efficiently query as you have explained, at least I have got some clues how to find it.

        Actually, this is a dummy table but the real table has a lot of columns that should be displayed in the same result set that I would use from PHP, but again I have got the clues because of you and chandu031. Thanks friends....
        See more | Go to post

          Leave a comment:

        • blackflicker
          started a topic Interrows average value?
          in MySQL

          Interrows average value?

          Hello, I have a table which is:

          Code:
          DROP TABLE IF EXISTS dummy;
CREATE TABLE dummy (
  id int(11) not null auto_increment,
  entered int(11) not null default 0,
primary key(id)
);
          And dummy records for you to easily test:

          Code:
          INSERT INTO dummy (entered) VALUES
(100), (150), (200), (250), (350);
          OK !

          I need to find out the average between row.entereds....
          See more | Go to post
          No activity results to display
          Show More
          Working...