On 7/16/05, Jonathan Mangin [EMAIL PROTECTED] wrote:
Hello all,
I'm storing data from a series of tests throughout each
24-hour period. I thought to create a table for each test.
(There are six tests, lots more cols per test, and many
users performing each test.)
select test1.date,
On 4/26/05, Jonathan Mangin [EMAIL PROTECTED] wrote:
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q-param(); # HTML checkboxes
foreach my $element (@array) {
my $sql = select col2, col3, col4 from
On 4/26/05, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
The same is true for any other value... Now that the columns have a NOT
NULL
constraint the records that previously contained NULL now hold '0'.
x y
x 0
x z
x 0
Now, how do you uniquely identify the 2nd and 4th rows?
[/snip]
On 4/26/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am wanting to display a random page from my site, But I have over 12,000
articles right now and we add over 150 per day. What I wound up doing was a
Virtual DOS attack on my own server because the 40 mb db was being loaded to
many
On 4/25/05, Ochungo, Pamela (ILRI) [EMAIL PROTECTED] wrote:
Hallo,
I would like to know whether there are any other languages supported by MySQL
apart from SQL.
e.g. MsAccess provides VB for aplications. Does MySQL support any such lower
level language?
I believe you are asking about so
On 4/26/05, Jigal van Hemert [EMAIL PROTECTED] wrote:
And http://dev.mysql.com/doc/mysql/en/create-table.html tells me that A
PRIMARY KEY is a unique KEY where all key columns must be defined as NOT
NULL. If they are not explicitly declared as NOT NULL, MySQL declares them
so implicitly (and