連番を挿入する場合、色々な方法があるかと思いますが、 AUTO_INCREMENT なんかだと欠番が出来ちゃうし… MAX 関数で取得した最大値+1 を INSERT 時に一緒に挿入して…だと 同時アクセスされた時にうまく値をもってこれなかったりするし、 それに 2 回 SQL を発行 ...

MySQL database servers may not come with graphical administration tools, but that is the price your small business pays for free database software. The fact that MySQL's standard administrative tool ...

I have an application that reads an image file and puts it into a MEDIUMBLOB. Or at least that's what it's supposed to do. What it actually does is nothing. I can do the database insert, which gives ...

How to add data into MySQL tables from the command line Your email has been sent So you’re new to MySQL database administration. You’ve probably already installed ...

I have an IIS6 box w/ PHP installed. One of the php pages requires a connection to a remote MySQL 5 box (same subnet, so no fw issues).<BR><BR>With this same user on the MySQL box itself, I can ...