RE: [PHP-DB] PhpHoo_create database phpHoo\p\g

2002-10-01 Thread John W. Holmes

PostGreSQL?
^   ^

---John Holmes...

> -Original Message-
> From: Russell Griechen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 01, 2002 7:50 PM
> To: Php-Db
> Subject: [PHP-DB] PhpHoo_create database phpHoo\p\g
> 
> I was looking at PhpHoo 'yahoo-like directory'
> What is the  \p\g appended to the code mean?
> I was thinking about using this...just don't understand how to
implement
> the
> appendages.
> 
> create database phpHoo\p\g
> 
> use phpHoo\p\g
> 
> create table Categories (
>  CatID bigint(21) NOT NULL auto_increment,
>  CatName varchar(32) NOT NULL,
>  CatParent bigint(21),
>  PRIMARY KEY (CatID),
>  UNIQUE (CatName)
> )\p\g
> 
> Russell Griechen
> htttp://sportsmenafield.com
> 
> Russell Griechen
> 
> 
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PhpHoo_create database phpHoo\p\g

2002-10-01 Thread Paul Burney

on 10/1/02 7:50 PM, Russell Griechen at [EMAIL PROTECTED] appended the
following bits to my mbox:

> I was looking at PhpHoo 'yahoo-like directory'
> What is the  \p\g appended to the code mean?
> I was thinking about using this...just don't understand how to implement the
> appendages.

You don't necessarily have to.  Basically, those are command line
instructions to MySQL to print the statement and execute it, respectively.

They probably work from the file like that just fine.  Just type them
normally.  Typically, most people use a semicolon (;) instead of \g to send
commands because it's 50% less typing.  :)

For example:

mysql> select NOW() \p\g
--
select NOW() 
--

+-+
| NOW()   |
+-+
| 2002-10-01 21:40:29 |
+-+
1 row in set (0.29 sec)

For other MySQL commands, type a question mark or \h at the MySQL command
prompt.

mysql> ?

Hope that helps.

Sincerely,

Paul Burney

-- 

I'm inhaling Caesar's last gasp...
http://paul.burney.ws/thoughts/caesars_breath.html


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PhpHoo_create database phpHoo\p\g

2002-10-01 Thread Hatem Ben

Just remove and create ure database without \p\g , it will be faster ;-)

Hatem

- Original Message -
From: "Russell Griechen" <[EMAIL PROTECTED]>
To: "Php-Db" <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 1:50 AM
Subject: [PHP-DB] PhpHoo_create database phpHoo\p\g


> I was looking at PhpHoo 'yahoo-like directory'
> What is the  \p\g appended to the code mean?
> I was thinking about using this...just don't understand how to implement
the
> appendages.
>
> create database phpHoo\p\g
>
> use phpHoo\p\g
>
> create table Categories (
>  CatID bigint(21) NOT NULL auto_increment,
>  CatName varchar(32) NOT NULL,
>  CatParent bigint(21),
>  PRIMARY KEY (CatID),
>  UNIQUE (CatName)
> )\p\g
>
> Russell Griechen
> htttp://sportsmenafield.com
>
> Russell Griechen
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php