nihilism machine wrote:
> Ok, I read the php.net info. so with this function though:
>
> public function select_one($sql) {
> $this->last_query = $sql;
> $r = mysql_query($sql);
> if (!$r) {
> $this->last_error = mysql_error();
> return false;
>
> CREATE TEMPORARY haha ( KEY (field1), KEY (field2) )
> AS
> SELECT po_no, po_date, item_no FROM . WHERE
> Then I don't need the privilege for ALTER TABLE.
I meant I could build index on a temp table without
the privilege to use "ALTER TABLE" by making the index
definitions as part of t
> You didn't send much info along, so I assume you're using some version
> of MySQL 5.0.
Thanks. I figured it out (doesn't need 5.0):
CREATE TEMPORARY haha ( KEY (field1), KEY (field2) )
AS
SELECT po_no, po_date, item_no FROM . WHERE
Then I don't need the privilege for ALTER TABLE.
-
Man-wai Chang wrote:
> I tried to post to mysql.general, but the message never appeared. So I
> am trying my luck here.
>
> How could I build an index for a table created using the "CREATE
> TEMPORARY TABLE ... SELECT ... FROM ..." syntax, using an account
> without the privilege to use ALTER TAB
John Taylor-Johnston wrote:
> Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I
> get results in no real structured heirachy. Any thoughts?
>
> atwood' IN BOOLEAN MODE);>Search color="blue">ccl.ccl_main For: margaret
> atwood - 275 record(s) found
>
> John
The results fr
I would have at least expected it give me 'margaret atwood' before it gives me
'margaret' and then 'atwood'.
> Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I get results
> in no real structured heirachy. Any thoughts?
>
> BOOLEAN MODE);>Search ccl.ccl_main For: color=
Christian Calloway em Friday 26 July 2002 17:30 foi agraciado com uma
resposta por:
> Sorry this may be a little offtopic, but I am currently moving a site I
> was developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading
> somewhere that there is a utility that will convert/transfe
Got it figured out --
To export table structure:
C:> mysqldump -d {database name} {tables} >sqltextfile.sql
Then to import the new Table Structure:
To import table structure / data
C:> mysql {database name} mysqldump -d mydb subscribers >subscribers.sql
** edit the "subscr
You can use an id field in your table structure that is set to auto
increment for each entry into database then just do a query on the id number
you wish to view... of course this would mean that you would need to create
a new field on your table but that should get you what you need.
Jas
--
P
9 matches
Mail list logo
