Re^4: MySQL Table adding with Perl

If you use the following to connect to the database, DBI will tell you more about where things (maybe) go wrong:

my $connect = DBI->connect(
    "dbi:mysql:database=Champ;host=localhost", 'root','pass',
    { RaiseError => 1 },
);
[download]

This saves you adding the error checking in every situation.

A bit more advice - I like to read passwords from a separate file, or from %ENV or anywhere else. That way, I can't inadverently post the database password when posting (or printing) my script.

Comment on Re^4: MySQL Table adding with Perl Select or Download Code

Replies are listed 'Best First'.
Re^5: MySQL Table adding with Perl by Anonymous Monk on Mar 06, 2013 at 21:17 UTC
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.	[reply]
Re^6: MySQL Table adding with Perl by Corion (Patriarch) on Mar 06, 2013 at 21:22 UTC
Your code cannot run at all: `$maketable = ("CREATE TABLE $newuser (A,B,C,D,E)");` [download] This is not valid SQL (except maybe in SQLite). But that doesn't matter because you never run that statement. `$sth = execute();` [download] 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`.	[reply] [d/l] [select]
Re^7: MySQL Table adding with Perl by Anonymous Monk on Mar 06, 2013 at 21:27 UTC
After the change it is responding with errors. Sorry, beginner Perl programmer mistake. Thanks for the answer!	[reply]


Your skill will accomplish what the force of many cannot
	PerlMonks