User Profile

Collapse

Profile Sidebar

Collapse
bthalapathi
bthalapathi
Last Activity: Feb 14 '09, 04:33 PM
Joined: Sep 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bthalapathi
    replied to Help in creating Table View
    in MySQL
    Thanks for helping me! Atli.

    First I will answer, your questions,

    [Atli.] your "FruitList" table is the one that actually lists the available fruits, and the "FruitSaleL ist" is the one that logs each fruit that is sold?

    [thala] Absolutely, you are correct. "FruitList" is the table having unique fruits. Sales logs are available in "FruitSaleL ist" table.

    [Atli.]...
    See more | Go to post

      Leave a comment:

    • bthalapathi
      started a topic Help in creating Table View
      in MySQL

      Help in creating Table View

      I had a table called 'FruitSaleList' , that contains the following columns

      sl.no, shop_id, fruitName, price, ....

      I had also another table called 'FruitList' that contains the columns

      shop_id, fruitName, salesManId, ....

      the problem is 'FruitList' table doesn't contain a column like fruitId.

      Let us assume there are following fruits are available in all shops

      ...
      See more | Go to post
      • bthalapathi
        replied to Need help, installing mysql in Perl v5.10.0
        in Perl
        Finally it is working, ofcourse following your instructions. Lot of thanks KevinADC.

        I followed the below

        Start -> Run -> PPM , this opens the PPM GUI and

        Edit -> Preferences -> Repositories -> Add Repository

        First I selected 'uwinnipeg' it was not listed the DBD:mysql then I selected 'bribes' and this too not helped but selecting 'trouchelle' finally listed DBD:mysql which...
        See more | Go to post

          Leave a comment:

        • bthalapathi
          replied to Need help, installing mysql in Perl v5.10.0
          in Perl
          Thanks for your reply.

          Yes, the DBD:mysql is not installed successfully. The mysql.pm is not available either in C:\Perl\lib\DBD or C:\Perl\site\li b\DBD

          Through google I find that we have to execute 'ppm install DBD:mysql' in the command prompt to install DBD:mysql. But this is not helpful for me for some reason.

          I don't know the way to install DBD:mysql successfully. Is there any alternative way to install...
          See more | Go to post

            Leave a comment:

          • bthalapathi
            started a topic Need help, installing mysql in Perl v5.10.0
            in Perl

            Need help, installing mysql in Perl v5.10.0

            I have written a script to connect the mysql db

            Code:
            #!/usr/bin/perl  -w

use DBI;
#definition of variables
$db="MYTEST";
$host="localhost";
$user="root";
$password="rootpass";

#connect to MySQL database
my $dbh   = DBI->connect ("DBI:mysql:database=$db:host=$host:3366",$user,$password)
            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...