- 论坛徽章:
- 0
|
- use DBI;
- my $dbname = "url";
- my $location = "localhost";
- my $port = "3306";
- my $database = "DBI:mysql:$dbname:$location:$port";
- my $db_user = "root";
- my $db_pass = "root";
- my $dbh = DBI->connect($database,$db_user,$db_pass);
- $name="xxxxxxxx"
- my $query = "CREATE TABLE '$name'("."
- `No` int(10) NOT NULL auto_increment,"."
- `depth` int(10) NOT NULL,"."
- `Url` text NOT NULL,"."
- PRIMARY KEY (`No`)"."
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
- my $sth = $dbh->prepare($query);
- $sth->execute() or die "create table student error: ".$sth->errstr();
复制代码 这就是建表那块的代码。 我想见一个表名是变量的,是我通过正则获取的。 |
|