creating table for rails

3 Message(s) by 2 Author(s) originally posted in mysql database

From: Thufir

Date: Wednesday, June 20, 2007

I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
oracle-ruby.html>,'d like to adapt the SQL

<language, database, standard> /S Q L/ An industry-standard
	language for creating, updating and, querying {relational
	database management systems}.

	SQL was developed by {IBM} in the 1970s for use in {System R}.
	It is the {de facto standard} as well as being an {ISO} and
	{ANSI} {standard}.  It is often embedded in general purpose
	programming languages.

	The first SQL standard, in 1986, provided basic language
	constructs for defining and manipulating {tables} of data; a
	revision in 1989 added language extensions for {referential
	integrity} and generalised {integrity} {constraints}.  Another
	revision in 1992 provided facilities for {schema} manipulation
	and {data administration}, as well as substantial enhancements
	for data definition and data manipulation.

	Development is currently underway to enhance SQL into a
	computationally complete language for the definition and
	management of {persistent}, complex objects.  This includes:
	generalisation and specialisation hierarchies, {multiple
	inheritance}, user defined {data types}, {triggers} and
	{assertions}, support for {knowledge based systems},
	{recursive query expressions}, and additional data
	administration tools.  It also includes the specification of
	{abstract data types} (ADTs), object identifiers, {methods},
	{inheritance}, {polymorphism}, {encapsulation}, and all of the
	other facilities normally associated with object data
	management.

	The emerging {SQL3} standard is expected to be complete in
	1998.

	According to Allen G. Taylor, SQL does _not_ stand for
	"Structured Query Language".  That, like "SEQUEL" (and its
	pronunciation /see'kw*l/), was just another unofficial name
	for a precursor of SQL.  However, the IBM SQL Reference manual
	for DB2 and Craig Mullins's "DB2 Developer's Guide" say SQL
	_does_ stand for "Structured Query Language".

	{SQL Standards (http://www.jcc.com/sql_stnd.html)}.

	{An SQL parser
	(ftp://ftp.ora.com/published/oreilly/nutshell/lexyacc/)} is
	described in "Lex & Yacc", by Levine, Mason & Brown published
	by O'Reilly.

	{The 1995 SQL Reunion: People, Projects, and Politics
	(http://www.mcjones.org/System_R/SQL_Reunion_95/)}.

	["A Guide to the SQL Standard", C.J. Date, A-W 1987].

	["SQL for Dummies", Allen G. Taylor, IDG Books Worldwide].

	(2005-11-17)

for MySQL, please. Yes, I
know, that's oracle wheras I'm using MySQL. This website

<World-Wide Web> (Or "website") Any computer on the
	{Internet} running a {World-Wide Web} {server} process.  A
	particular website is usually identified by the {hostname}
	part of a {URL}.  Multiple hostnames may actually map to the
	same computer in which case they are known as "{virtual
	servers}".

	(2005-07-12)

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@xxxxxxxxxxx ~]$
[thufir@xxxxxxxxxxx ~]$ mysql -u feeds -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20 to server

1. A program which provides some service to other ({client})
	programs.  The connection between client and server is
	normally by means of {message passing}, often over a
	{network}, and uses some {protocol} to encode the client's
	requests and the server's responses.  The server may run
	continuously (as a {daemon}), waiting for requests to arrive
	or it may be invoked by some higher level daemon which
	controls a number of specific servers ({inetd} on {Unix}).

	There are many servers associated with the {Internet}, such as
	those for {HTTP}, {Network File System}, {Network Information
	Service} (NIS), {Domain Name System} (DNS), {FTP}, {news},
	{finger}, {Network Time Protocol}.  On Unix, a long list can
	be found in /etc/services or in the {NIS} database "services".
	See {client-server}.

	2. A computer which provides some service for other computers
	connected to it via a network.  The most common example is a
	{file server} which has a local disk and services requests
	from remote clients to read and write files on that disk,
	often using {Sun}'s {Network File System} (NFS) {protocol} or
	{Novell Netware} on {PCs}.  Another common example is a {web
	server}.

	[{Jargon File}]

	(2003-12-29)

version

<programming> One of a sequence of copies of a program, each
	incorporating new modifications.  Each version is usually
	identified by a number, commonly of the form X.Y where X is
	the major version number and Y is the release number.
	Typically an increment in X (with Y reset to zero) signifies a
	substantial increase in the function of the program or a
	partial or total re-implementation, whereas Y increases each
	time the progam is changed in any way and re-released.

	Version numbers are useful so that the user can know if the
	program has changed ({bugs} have been fixed or new functions
	added) since he obtained his copy and the programmer can tell
	if a bug report relates to the current version.  It is thus
	always important to state the version when reporting bugs.
	Statements about compatibility between different software
	components should always say which versions they apply to.

	See {change management}.

	(1997-12-07)

: 5.0.27

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

mysql>
mysql>
mysql>
mysql>
mysql>
mysql> show database

1. <database> One or more large structured sets of persistent
	data, usually associated with software to update and {query}
	the data.  A simple database might be a single file containing
	many {records}, each of which contains the same set of
	{fields} where each field is a certain fixed width.

	A database is one component of a {database management system}.

	See also {ANSI/SPARC Architecture}, {atomic}, {blob}, {data
	definition language}, {deductive database}, {distributed
	database}, {fourth generation language}, {functional
	database}, {object-oriented database}, {relational database}.

	{Carol E. Brown's tutorial
	(http://accounting.rutgers.edu/raw/aies/www.bus.orst.edu/faculty/brownc/lectures/db_tutor/db_tutor.htm)}.

	2. <hypertext> A collection of {nodes} managed and stored in
	one place and all accessible via the same {server}.  {Links}
	outside this are "external", and those inside are "internal".

	On the {World-Wide Web} this is called a {website}.

	3. All the facts and rules comprising a {logic programming}
	program.

	(2005-11-17)

<database> A collection of {records} in a {relational database}.

	(1997-06-04)

s;
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've an error

1. A discrepancy between a computed, observed, or measured
	value or condition and the true, specified, or theoretically
	correct value or condition.

	2. <programming> A mental mistake made by a programmer that
	may result in a program {fault}.

	3. (verb) What a program does when it stops as result of a
	programming error.

	(2000-03-28)

in your SQL syntax

The structure of strings in some language.  A language's
	syntax is described by a {grammar}.  For example, the syntax
	of a binary number could be expressed as

		binary_number = bit [ binary_number ]

		bit = "0" | "1"

	meaning that a binary number is a bit optionally followed by a
	binary number and a bit is a literal zero or one digit.

	The meaning of the language is given by its {semantics}.

	See also {abstract syntax}, {concrete syntax}.

	(1994-10-31)

; 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

1. <hardware> An electrical conductor.  For distances larger
	than a breadbox, a single line may consist of two electrical
	conductors in twisted, parallel, or concentric arrangement
	used to transport one logical signal.

	By extension, a (usually physical) medium such as an {optical
	fibre} which carries a signal.

	(1995-09-29)

2
mysql>
mysql> quit
Bye
[thufir@xxxxxxxxxxx ~]$
[thufir@xxxxxxxxxxx ~]$ date
Wed Jun 20 08:36:58 BST

<convention> British Summer Time.  The name for
	daylight-saving time in the UK {GMT} time zone.

	(2000-03-28)

2007
[thufir@xxxxxxxxxxx ~]$
[thufir@xxxxxxxxxxx ~]$

thanks,

Thufir

From: Jeff North

Date: Wednesday, June 20, 2007

On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir
<hawat.thufir@xxxxxxxxxxx>
wrote in message:

| I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
| oracle-ruby.html>,'d 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've 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@xxxxxxxxxxx : Remove your pants to reply
---------------------------------------------------------------

From: Thufir

Date: Thursday, June 21, 2007

wrote in message:

On Wed, 20 Jun 2007 07:41:01 GMT, in mailing.database.mysql Thufir
<hawat.thu...@xxxxxxxxxxx>
wrote in message:
>| I'm working from <http://www.oracle.com/technology/pub/articles/haefel-
>| oracle-ruby.html>,'d 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

Next Message: slow database retrieval