Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: creating table for rails

Posted on 2007-06-20 09:41:01 by hawat.thufir

I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
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

Report this message

#2: Re: creating table for rails

Posted on 2007-06-20 20:17:10 by Jeff North

On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir
<hawat.thufir@gmail.com>
<hS4ei.40861$NV3.16873@pd7urf2no> wrote:

>| I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
>| 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
------------------------------------------------------------ ---

Report this message

#3: Re: creating table for rails

Posted on 2007-06-21 06:30:25 by hawat.thufir

On Jun 20, 7:17 pm, Jeff North <jnort...@yahoo.com.au> wrote:
> On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir
> <hawat.thu...@gmail.com>
>
> <hS4ei.40861$NV3.16873@pd7urf2no> wrote:
> >| I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
> >| 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

Report this message