Nothing wrong, besides missing a character.
I tried your instructions with the full word CREATE and it worked fine...
Luis
Patrick Roane wrote:
I am learning the mysql basics and was wondering what
I'm doing wrong. I'm using the MySQL.exe console to
create a simple table, but I keep getting these s
I am learning the mysql basics and was wondering what
I'm doing wrong. I'm using the MySQL.exe console to
create a simple table, but I keep getting these syntax
errors.
All I'm doing is typing the code and than pressing
enter. Is there more I have to do? Here is my code:
CREAT TABLE phonelist(
where can I find a tutorial that can help me use mysql
to update data 'dynamically'(content, URLs'
etc.)contained in an html table, instead of going into
the html code itself?
=
"forget your lust for the rich man's gold. All that you need, is in your soul. You can
do th
One possible reason why it does not work is that the DAY() function does not
exist.
Use DATE_FORMAT() instead.
Ignatius
_
- Original Message -
From: "Disko_kex" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 10:4
Hi
SELECT RegDate FROM table WHERE month(RegDate) = 10 // this is
working
SELECT RegDate FROM table WHERE day(RegDate) = 2 // why isn´t this
working?
I know this isn't the mysql area... but many of you seem very knowledgeable in this
area and I would appreciate your input...
What kind of field setup should I create if I want a field which will, essentially
hold several distinct items, but never a set number of them? I am going to be
selecti
.
- Original Message -
From: "Bobo Wieland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 6:21 PM
Subject: [PHP-WIN] MySQL - question
> I'm most of the time using MySQL in conjuction with PHP and I hope that
it's
> okey to post quest
I'm most of the time using MySQL in conjuction with PHP and I hope that it's
okey to post questions regarding MySQL. There isn't much traffic here anyway
so I hope you can live with it...
Anyway... I'm going to put two different translations of the bible in a
MySQL-db. And before I do anything I w
Just a quick question maybe someone working with PHP and MySql has already
come across it before.
Is it possible for MySQL to store specific language characters eg, japaneese
or Korean?
