Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

adodb.recordset error '800a0cc1', php save mails as eml, WWWXXXAPC, sqlexpress database file auto-creation error, sqlexpress database file auto-creation error, dbf2mysql parameter, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO

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