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.d
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,
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
> m
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
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
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 a
