I have a large mysql database. I need perl to connect to this database, and pull 2 fields from each record, and set to 2 perl variables. The code needs to loop through the database instead of just loading all into an array as the database is very large. This should be very VERY easy for any knowledgeable perl/mysql programmer.
I'm just a beginner, and I'm getting stuck on this.
mysql server: local host
mysql database: database_name
mysql user: root
mysql pass: none
connect to server
set mysql[variable1] = perlvariable1
set mysql[variable2] = perlvariable2