creating table for rails

I'm working from oracle-ruby.html>, would like to adapt the SQL for MySQL, please. Yes, I
know, that's oracle wheras I'm using MySQL. This website happens to be
the best rails tutorial I can find for my purposes, and I'd like to
follow along with it.

Here's what's happening:



[thufir@localhost ~]$
[thufir@localhost ~]$ mysql -u feeds -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql>
mysql>
mysql>
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| Comic |
| Legacy |
| dummy |
| dummy_development |
| feeds |
| mysql |
| test |
+--------------------+
8 rows in set (0.01 sec)

mysql>
mysql> use Comic;
Database changed
mysql>
mysql> show tables;
Empty set (0.00 sec)

mysql>
mysql> CREATE TABLE comics (
-> idNUMBER(10) NOT NULL,
-> titleVARCHAR2(60),
-> issueNUMBER(4),
-> publisherVARCHAR2(60),
-> PRIMARY KEY (id)
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
to use near '(10) NOT NULL,
titleVARCHAR2(60),
issueNUMBER(4),
publisherVARCHAR2(60),
PRIMARY' at line 2
mysql>
mysql> quit
Bye
[thufir@localhost ~]$
[thufir@localhost ~]$ date
Wed Jun 20 08:36:58 BST 2007
[thufir@localhost ~]$
[thufir@localhost ~]$




thanks,

Thufir

Re: creating table for rails

On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir

wrote:

>| I'm working from >| oracle-ruby.html>, would like to adapt the SQL for MySQL, please. Yes, I
>| know, that's oracle wheras I'm using MySQL. This website happens to be
>| the best rails tutorial I can find for my purposes, and I'd like to
>| follow along with it.
>|
>| Here's what's happening:
[snip]

>| mysql> CREATE TABLE comics (
>| -> idNUMBER(10) NOT NULL,
>| -> titleVARCHAR2(60),
>| -> issueNUMBER(4),
>| -> publisherVARCHAR2(60),
>| -> PRIMARY KEY (id)
>| -> );

CREATE TABLE comics (
id int(10) NOT NULL,
title varchar(60),
issue smallint(4),
publisher varchar(60),
PRIMARY KEY (id)
) ENGINE=MyISAM;

>| ERROR 1064 (42000): You have an error in your SQL syntax; check the
>| manual that corresponds to your MySQL server version for the right syntax
>| to use near '(10) NOT NULL,
>| titleVARCHAR2(60),
>| issueNUMBER(4),
>| publisherVARCHAR2(60),
>| PRIMARY' at line 2
>| mysql>
>| mysql> quit

[snip]
------------------------------------------------------------ ---
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
------------------------------------------------------------ ---

Re: creating table for rails

On Jun 20, 7:17 pm, Jeff North wrote:
> On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir
>
>
> wrote:
> >| I'm working from > >| oracle-ruby.html>, would like to adapt the SQL for MySQL, please.
[...]
> CREATE TABLE comics (
> id int(10) NOT NULL,
> title varchar(60),
> issue smallint(4),
> publisher varchar(60),
> PRIMARY KEY (id)
> ) ENGINE=MyISAM;
[...]


thanks :)


-Thufir