Select Code to Download

Select or download this

root@localhost [project_db]> describe articles_table;
+------------------------+--------------+------+-----+---------+------
+-+
| Field                  | Type         | Null | Key | Default | Extra
+ |
+------------------------+--------------+------+-----+---------+------
+-+
| db_art_id              | bigint       | YES  | MUL | NULL    |      
+ |

Select or download this

root@localhost [project_db]> SELECT MAX(db_art_id) FROM articles_table
+;
[...]
...
1 row in set (0.01 sec)

root@localhost [project_db]>

Select or download this
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM articles_table' at line 1
Select or download this
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"articles_table"' at line 1

Select or download this

    my $my_articletable = 'articles_table';
    my $p_db_art_id = 'db_art_id';
...
    logit("SQLCMD: '$sqlcmd'");
    my $sth = $p_dbh->prepare($sqlcmd);
    $sth->execute();