Hi Ferindo
>The intended effect is to get a timestamp field that inserts the
current system
>time on inserts and continues to update the field with the current
timestamp
>on updates without the application or use needing to specify it
are you
>saying that the timestamp attribute alone wil
Thanks Peter. I did originally use this table in a Postgresql db. Thanks
for you advice. Your suggestions below allowed me to create this table
and I learned a thing t two about proper usage of the TIMESTAMP data
type. The intended effect is to get a timestamp field that inserts the
current sys
Ferindo
One problem is:
employment_status_id INTEGER REFERENCES employment_statuses(id) NOT
NULL,
NOT NULL should be before REFERENCES.
Also, in:
last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
(i) NOT NULL is superfluous since the default is given by
CURRENT_TIMESTAMP.
(ii)
I have been trying to create a table but mysql 5.0.15-nt-max is having a
problem parsing the statement. Anyone know what the problem is in the
syntax of the following table creation statement:
CREATE TABLE registration_and_attendance (
idSERIAL NOT NU
gt;
> mysql> select version();
> ERROR: parse error near '()' at line 1
> Version via mysqladmin shows:
> mysqladmin Ver 5.3 Distrib 3.20.32a, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
The function version() was added in MySQL v. 3.21.13,
released on 29
version();
ERROR: parse error near '()' at line 1
mysql> select 'version'();
ERROR: parse error near '()' at line 1
mysql> select 'version()';
1 rows in set (0.00 sec)
+---+
| version() |
+---+
| version() |
+-------+
mysql> sele
On Thu, Sep 20, 2001 at 12:38:44AM -0400, Anthony Rodriguez wrote:
> Please help! There is a parse error in line10:
>
>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 14 days, processed 255,630,232 queries (210
Please help! There is a parse error in line10:
etc.
Thank you!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
That's the way should be, never enter your database access info directly into
any type of script, be it PHP or Perl or what ever, store it in a separate file,
no accessible separate file, then have the related script(s) call up the
variables thru the PHP's include, or Perl's 'require' or 'use' ..
database, does it need to be enclosed between double
apostrophes inside the double quotes? I imagine, I'd eventually figure that
out after some more trial and error--but hey, if you don't mind???
Joe
> >>On Tue, 10 Jul 2001 17:33:10 -0700, Joe Taraba
> <[EMAIL PROTECTED
> Group;
>
> There is something missing in my understanding of the php mysql_connect
> statement because I am getting a parse error as follows:
>
> http://cxkop.com/Jobs/job_list.php
> Parse error: parse error in
> /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.p
e = "localhost";
>>On Tue, 10 Jul 2001 17:33:10 -0700, Joe Taraba <[EMAIL PROTECTED]> wrote:
>>There is something missing in my understanding of the php mysql_connect
>>statement because I am getting a parse error as follows:
>>
>>http://cxkop.co
Group;
There is something missing in my understanding of the php mysql_connect
statement because I am getting a parse error as follows:
http://cxkop.com/Jobs/job_list.php
Parse error: parse error in
/home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
The database exists and
> Barry C. Hawkins wrote:
> >> Esteemed colleagues,
> >> The php list is down, and I am sure someone knows what to do about
> > this
> >> in this list. The issue is that I receive the error
> >>
> >> Parse error: parse error in config.inc.php3 on l
on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote:
> Barry C. Hawkins wrote:
>> Esteemed colleagues,
>> The php list is down, and I am sure someone knows what to do about
> this
>> in this list. The issue is that I receive the error
>>
>> Parse erro
Esteemed colleagues,
The php list is down, and I am sure someone knows what to do about this
in this list. The issue is that I receive the error
Parse error: parse error in config.inc.php3 on line 1
upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on
the same
Barry C. Hawkins wrote:
> Esteemed colleagues,
> The php list is down, and I am sure someone knows what to do about
this
> in this list. The issue is that I receive the error
>
> Parse error: parse error in config.inc.php3 on line 1
>
> upon trying to access phpMyAdm
In Addation,
Print ("OK 3") line is also missed ':'.
^^
magic words sql database
- Original Message -
From: "MTF" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 12:13 PM
Subject: Parse error?
> I am new to M
hat can't be helping
>
>
>
>
>
>magic words sql database
>-Original Message-
>From: MTF [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 16, 2001 2:13 PM
>To: [EMAIL PROTECTED]
>Subject: Parse error?
>
>
>I am new to MySQL and am using Paul DuBo
OTECTED]]
Sent: Wednesday, May 16, 2001 2:13 PM
To: [EMAIL PROTECTED]
Subject: Parse error?
I am new to MySQL and am using Paul DuBois's book to MySQL guide me. (Great
Book!)
I am attempting to use PHP, My scripts always connect to the MySQL server
OK,
and the Databases to, but my que
I am new to MySQL and am using Paul DuBois's book to MySQL guide me. (Great
Book!)
I am attempting to use PHP, My scripts always connect to the MySQL server OK,
and the Databases to, but my queries always fail with the following message:
OK 1 OK 2
Parse error: parse error in /home/httpd
Petra,
You have a close '}' with no open '{'. Maybe you should move the If
statement to the next line, then it won't be commented out.
len.
-Original Message-
From: Petra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 March 2001 13:21
To: [EMAIL PROTEC
can anybody help?
I get this error
Parse error: parse error in mypath to file\Default.php on line 18
I am just learning right now so if you could help me with what I did wrong
her I'd apreciate it.
Thanx Petra
[EMAIL PROT
can anybody help?
I get this error
Parse error: parse error in mypath to file\Default.php on line 18
I am just learning right now so if you could help me with what I did wrong
her I'd apreciate it.
Thanx Petra
[EMAIL PROT
24 matches
Mail list logo
