mysql functions as per the
manual examples and you'll soon find where the error is.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
I'm having an emotional outburst!!
*/
-
Before posti
h this name "'w4-1".
>
> But, i can't create the table with this name. The request is rejected.
>
> Has anybody an explanation ?
>
You need to enclose the table name with backticks, eg:
CREATE TABLE `w4-1` (
name varchar(10) NOT NULL default '',
category order by rnd;
+--+---+
| category_description | rnd |
+--+---+
| Figure | 0.200211824104387 |
| Magnet | 0.565105185438977 |
| Feng Shui| 0.811984655272201 |
| Candle | 0.953237160996755 |
+---
ed
result[$key_field_val][$key]::$result[$key_field_val][$key]"; }
else {
#$result[$key_field_val][$key] = $field; echo "Assigned
result[$key_field_val][$key]::$result[$key_field_val][$key]";
$tmp[$key] = $field; #echo "Assigned
result[$key_field_val][$key]::$result[
url is not null
>
> order
>
> > > by rand() limit 1");
> > > I have tried everything, but nothing seems to work. Can anyone help.
> > >
> > > Rob
The solution presented by Kodrik does work. What is the problem?
--
Jason Wong -> Gremlins As
t
> there're defaults files for My.cnf like /etc/my.cnf or datadir/my.cnf or
> ~/.my.cnf, but still i couldn't find that file.Please i need some advices.
It's OK, if they're not there, just create one.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
QOTD
ne has to write his own program to do
> this.
You can use something like this:
SEC_TO_TIME(UNIX_TIMESTAMP("2001-11-03 16:11:50") -
UNIX_TIMESTAMP("2001-11-03 15:48:00"))
which would return
00:23:50
hth
--
Jas
DATE/TIME field then
HOUR(myfield) will extract the hour portion from myfield.
Thus you can have
WHERE HOUR(myfield) = 14
will select only those rows in myfield where the time is 2:XX PM.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
The Abrams' Principle
above)
SELECT * FROM table WHERE category LIKE '%christmas%'
should do the trick.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Horngren's Observation:
Among economists, the real world is often a special case.
*/
--
On Thursday 29 November 2001 02:01, Auri Net SAC wrote:
> Hi
>
> please who knows a package that install apache + php + mysql in linux,
> i know phptriad but its for windows
> Thanks for your answer
> rvj
>
ApacheToolBox http://www.apachetoolbox.com
--
Jason Wong -
eness it should be usable if you do not have too many rows to
deal with.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Baker's First Law of Federal Geometry:
A block grant is a solid mass of mone
g
In your form, you should name your multiselect fields as "name[]". In
your case it would be "zimmermulreg[]". This would then give you an
array when the form is submitted and thus make implode happy.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
d what I am suppose to do with
> it. I type in commands and it just does another -> What is that?
The -> indicates that it is waiting for the rest of the query. You need
to end each query with a semi-colon. Thus:
mysql> show tables;
hth
--
Jason Wong -> Gremlins Associates ->
ould be returned should be:
>
> 4385 - 1
> 4513 - 2
> 4382 - 3
> 4533 - 7
try:
SELECT MAX(storyID), storyCategoryID, title
FROM newsStories
GROUP BY storyCategoryID;
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
HR 3128. Omnibus Budget Re
amounts of text, since TEXT data
> type does not support binary encoding?
>
> lease ... or i´ll do harakiri
You could try using a BLOB.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
"After one week [visiting Austria] I couldn't wait to go back to
omains(
dName,
payPrYr,
nextPayDay,
timeCreated)
VALUES(
'$domainName',
'$payPerYear',
'$nxtPayDay',
'$tid')&qu
RY = "INSERT INTO bandbook (user, ect1, ect2...)
VALUES ('$userdb', '$ect1', '$ect2', ...)";
print("$QRY"); ## For debugging
$rows=$dbh->do($QRY) || die "Error";
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
---
e as well.
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
n
> Linux. I have a concatenated primary key of multiple fields. And I
> also have a unique index on each of these fields. There are
> 1,734,291 bytes of data in the table with an average row length of
> 61.
Sometimes it's quicker to drop the indices, insert your data, then
recreate the i
19 matches
Mail list logo
