be nice to run the whole thing in DB for
effeciency.
--
Pekka Järvinen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and uses 8+256 bytes in 5.0.
--
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.com
[EMAIL PROTECTED] +46 (0) 73 068 4978
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re the maxlength?
That would use 8 bytes always (1+6 round up to 4 bytes).
If you specify say Varchar(255) then each tuple uses 1+255 bytes,
even if you only store 'abc123' which should take 8 bytes.
This is so in 5.0.
--
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.com
[EMAI
of BLOB and
the bulk of it (in Cluster) is stored in a separate table. This is
usually not efficient.
I hope this helps to decide if Cluster is right solution for you.
--
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.com
[EMAIL PROTECTED] +46 (0) 73 068 4978
--
MySQL General Maili
I get is:
Name of Song
Artist
What I want is:
Name of Song (Artist)
while ($line = mysql_fetch_array($result)) {
print "$line["title"] . " (" . $line["artist"] . ")";
}
-
Pekka Saarinen
http://photography-o
-+
>| alio.zinutes | repair | error| The handler for the table doesn't
>support check/repair |
>+--++--++
>1 row in set (0.00 sec)
REPAIR T
t;) TYPE=MyISAM;
>
>Any Ideas??
>Thanks in advance
Try
OPTIMIZE TABLE `e_genlogmatergroup`
This should get indexes running (you need to have a couple of rows of data
there first).
-
Pekka Saarinen
http://photography-on-the.net
--
Hi,
Is there a way convert result of
SELECT NOW()
or
SELECT SYSDATE()
or
SELECT CURRENT_TIMESTAMP
to GMT, in a query?
Thanks,
Pekka
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
;
exit;
}
$frm = mysql_fetch_array($qid);
or
$qid = mysql_query("
SELECT *
FROM 1_nodedata
WHERE id = '$edit_id'
");
if (!$qid ) {
print mysql_error();
}
if ($qid ) {
$frm = mysql_fetch_array($qid);
}
-
Pekka Saarinen
http://photography-on-the.net
ot;) and then wait that all SQL processes
are finished (SHOW PROCESSLIST may help here), then flush, lock, update,
unlock and open clients again.
-
Pekka Saarinen
http://photography-on-the.net
-
---
ng focus too long on one subject is not good
for the reading process. Who knows. But it is not hard to normalize, and
actually the further you go the more clearly you'll see the real data in
your database.
Pekka
-
Pekka Saarinen
http://photography-on-the.net
---
ust "id" and "size"
otherwise you'll end up using aliases all the time.
- prefix you table names with project name, like "GRT_computers",
"GRT_personnel", this way you can place the database into non-empty
database knowing there almost no chance
error with standard backquotes and how to
fix this??? I'd really like to know what is going on there.
http://www.mysql.com/doc/L/e/Legal_names.html tells backquotes really must
be there.
Thanks,
Pekka Saarinen
http://photogr
Hi there,
A DB newbie question - can I use MS Access for remote mySQL databases using myODBC??
Thanks.
14 matches
Mail list logo
