[Gllug] Why not to use MySQL...

[Richard Jones]

On Tue, Nov 25, 2003 at 11:40:14AM +0000, Sean Burlington wrote:
> LIMIT, AUTO_INCREMENT, SHOW CREATE TABLE, SHOW TABLES

I'm guessing here, but:

LIMIT (limit number of tuples returned?) is just LIMIT, as in:

  select * from foo where bar = 1 order by 1 limit 10

AUTO_INCREMENT would probably be SERIAL, as in:

  create table foo
  (
    id serial not null primary key,
    description text
  );

  insert into foo (description) values ('hello');

  select currval ('foo_id_seq');
	 currval 
	---------
	       1
	(1 row)

  select * from foo;
	 id | description 
	----+-------------
	  1 | hello
	(1 row)

SHOW CREATE TABLE - I have no idea what this could do.

SHOW TABLES - Probably the \d or \dt commands in psql which list
relations and tables respectively.

---

For quick help, fire up psql and type \? to list psql commands and
\h select (for example) to list the syntax of the SELECT statement.

For more detailed help, you need to read the user manuals which are
online at http://postgresql.org.

Rich.

-- 
Richard Jones. http://www.annexia.org/ http://freshmeat.net/users/rwmj
Merjis Ltd. http://www.merjis.com/ - improving website return on investment
NET::FTPSERVER is a full-featured, secure, configurable, database-backed
FTP server written in Perl: http://www.annexia.org/freeware/netftpserver/

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug