RE: insert was working

Richard, Explain auto_increment field please. Thanks, Jerry -Original Message- From: Richard Whitney [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 10:31 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: Re: insert was working Gerald! Do you have an auto_increment

insert was working

Hi! I was able to insert data with the following: sub insert_sql { my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total, $DEBUG ) = @_; print "[EMAIL PROTECTED]" if $DEBUG; ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total ) = &clean_sq

RE: insert data

John Trammell Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; Gerald Preston Subject: Re: insert data Right. First, I think the logic is flawed. We should successfully prepare() or die. Period. If the call to prepare() failed ($sth is undef), we should not making dying conditional on yet anot

RE: insert data

x27;) WHERE Host = 'local_host' AND User = 'gjwpp88'; SET PASSWORD FOR 'gjwpp88'@'local_host' = OLD_PASSWORD('x'); SELECT 'local_host', 'gjwpp88', Password FROM mysql.user WHERE LENGTH('x') > 16; FL

RE: insert data

> > I am lost here. I have been writing code on a SUN Oracle systems for > over five years. > > Regards, > > Jerry Did you 'grant' user "" access to all the tables in database club? > > -Original Message- > From: Michael Stassen [mailto:

RE: insert data

--- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Monday, February 28, 2005 9:29 AM To: Gerald Preston Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: insert data From perldoc DBD::mysql use DBI; $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

RE: insert data

David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 3:27 PM To: Gerald Preston; mysql@lists.mysql.com Subject: RE: insert data Hi Gerald, The only thing I can think of is that you have a syntax error in your SQL that hasn't showed up in translation to email. Are

RE: insert data

The object used: my $dbh=DBI->connect( 'DBI:mysql:database=club', 'xxx, 'x', { PrintError => 0} ) or die $DBI::errstr; Jerry -Original Message- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 6:37 AM To: mysql@lists.mysql.com Subject: Re: insert data Hi G

RE: insert data

David, Still the same error!. Jerry -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 5:49 AM To: Gerald Preston; mysql users Subject: RE: insert data Hi Gerald, Try something like my $sth = $dbh->prepare("ins

RE: insert data

olfies ( group_name, me, daily, item, unit, qty, amount, tax, total ) values( ?, ?, ?, ?,?,?, ?, ?, ? ) "; my $sth = $dbh->prepare( $sql ); die $dbh->errstr if $dbh->err; What am I ding wrong? Thanks, Jerry ---Original Message- From: Ge

RE: insert data

e) [mailto:[EMAIL PROTECTED] Sent: Sunday, February 27, 2005 5:09 AM To: Gerald Preston; mysql users Subject: RE: insert data Hi Gerald, If this is copied out of your perl code then you haven't put anything into the $sql variable. Try uncommenting the 2 lines above. Regards David

insert data

Hi! I am trying to insert data for the first time using MySQL. In Oracle I used the following: # my $sql = "insert into bar( group_name, me, daily, item, unit, qty, amount, tax, total ) # values( ?, ?, ?, ?,?,?, ?, ?, ? ) "; my $sth = $db

RE: MySQL & Perl

ut my server HOST name is? What else is wrong? I have done this many times working with Oracle and never had this problem! Thanks, Jerry -Original Message- From: Gerald Preston [mailto:[EMAIL PROTECTED] Sent: Friday, January 14, 2005 12:56 AM To: mysql@lists.mysql.com Subject: MySQL

MySQL & Perl

I am trying to get Perl to talk to MySQL that I have setup. According to "WinMySQLAdmin1.4" Local Host Name = GJW Local User name = Jerry Databases: GJW Club bar mysql test I am using the following code: #!/perl use warnings; use strict; use DBI;

creating first table

Hi! Running mysql on a XP command line. Doing "dhow" databases" list the following; Database Club Mysql Test I did a grant all user id; How can I list the rows and columns. I tried "alter table club add < ME varchar( 3));" and get : You have an error in your SQL syntax;

RE: first time accessing

Tom, I am running 'WinMySQLadmin 4.1". Can I use this tool to change anything? Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:24 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE: first time accessing

RE: first time accessing

Tom, I am still getting access denied when I try ',mysql -u root'. Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:24 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE: first time accessing If you are usi

RE: first time accessing

Tom, I still get access denied. I just reinstall the latest version yesterday. What are my options now? Thanks, Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 6:28 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE

RE: first time accessing

wanting to do is connect and create a new table. Any ideas? Thanks, Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 3:52 PM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE: first time accessing Try something like t

first time accessing

I am making my first attempt to access MySQL with Perl #!/perl use warnings; use strict; use dbi; my $dbh=DBI->connect( 'dbi:MySQL, 'user', 'pass' ) or die "Cannot connect -> !$DBI::errstr"; and I get the following error: Can't connect to data source dbi:MySQL, no data driver

starting service

I just installed 4.7.1 for XP Pro. I am unable to Start Service. I do not find any error files? I get: "Cannot Create Windows Service for MySQL.Error:0" Any ideas? Thanks, Jerry

stating service

I just installed 4.7.1 for XP Pro. I am unable to Start Service. I do not find any error files? I get: "Cannot Create Windows Service for MySQL.Error:0" Any ideas? Thanks, Jerry

ppm install problems

I am trying to install ODBC and it does nothing. I am running version 4.1.7 on XP Pro. PPM hangs when I query Tk as well. What is going on? Thanks, Jerry

Re: first dbi access with perl and lost

Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! Jerry Paul DuBois wrote: > At 13:33 -0500 9/22/02, Gerald Preston wrote: > >David, > > > >I am not getting any where.. Do I have create mysql.pm o

Re: first dbi access with perl and lost

David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Thanks, Jerry David Lloyd wrote: > Gerald, > > > Now I am getting the following: > > > > install_driver(mysql

Re: first dbi access with perl and lost

David, Thanks, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? Thanks, Jerry David Lloy

first dbi access with perl and lost

Hi!, I am lost! I am running in win 98 and my perl code is: #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost", "jwp", "x", {'R