Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re^5: MySQL Table adding with Perl

by Anonymous Monk
on Mar 06, 2013 at 21:17 UTC ( #1022093=note: print w/ replies, xml ) Need Help??

in reply to Re^4: MySQL Table adding with Perl
in thread MySQL Table adding with Perl

Unfortunately with the addition of that line, there was no output. The scripts runs without error. Thanks Corion for the advice about the passwords, I will definitely keep that in mind.

Comment on Re^5: MySQL Table adding with Perl
Replies are listed 'Best First'.
Re^6: MySQL Table adding with Perl
by Corion (Pope) on Mar 06, 2013 at 21:22 UTC

    Your code cannot run at all:

    $maketable = ("CREATE TABLE $newuser (A,B,C,D,E)");

    This is not valid SQL (except maybe in SQLite). But that doesn't matter because you never run that statement.

    $sth = execute();

    This should never work. You need to call the ->execute() method on your statement handle. Unless you also have defined (but not shown to us) a subroutine with the name execute.

      After the change it is responding with errors. Sorry, beginner Perl programmer mistake. Thanks for the answer!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1022093]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2015-11-27 07:20 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (719 votes), past polls