Re: PHP bias

2002-11-10 Thread Phil Straw 
My experience of MySQL is very recent. I only started using it a few weeks
ago. I got great support from the list (Thanks !) when I had an initial
problem specific to MySQL VARCHARand it's not just Perl and PHP that
work. After I had my database created in the command line I downloaded the
JDBC drivers and had Java working with the database in about 20 minuteit
just worked.

Now I'm off to rip out a commercial database (O***le) and replace it with
MySQL. 

I also just got a copy of MySQLManager (EMS). That makes things very easy.

FYI, I am independent, I am not affiliated at all with any company but my
own.
P/.



On 11/9/02 11:31 PM, Georg Richter [EMAIL PROTECTED] wrote:

 On Sunday 10 November 2002 14:12, Robert Macwange wrote:
 
 PHP is an inferior language. Deal with perl instead.
 
 Looks like you're not very familar with the spirit of Open Source:
 
 Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
 benefits and of course some disadvantages. But this competition helps each
 one to improve and become more popular.
 
 The same with MySQL, Postgres, SleepyCat, ... etc.
 
 There is no better or inferior: Just define your needs and choose whats the
 best for you.
 
 Regards
 
 Georg
 
 
 -
 Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Help with creation...CREATE

2002-11-05 Thread Phil Straw 
OK guys, I am a relative newbie with MySql, but know something at least of
databases. Please can you direct me as to where this CREATE statement is
wrong. I am lost.

I get ERRORCODE 1064 which looks to be near DB_ERROR_SYNTAX in the code.
Before wading through all that I though I might ask the experts

create table test.Links (
  url TEXT NOT NULL,
  safe SMALLINT NOT NULL,
  broken TINYINT,
  summary VARCHAR NOT NULL,
  details TEXT,
  averating SMALLINT,
  addedbyuser VARCHAR NOT NULL,
  urlhash CHAR NOT NULL PRIMARY KEY
)

Followed by
SQLSTATE   42000
ERRORCODE  1064

MESSAGE:
Syntax error or access violation: You have an error in your SQL syntax
near 'NOT NULL,
details TEXT,
averating SMALLINT,
addedbyuser VARCHAR NOT NULL,
' at line 5


Any help welcome !
P/.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php