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;
}
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 TABLE?
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.
--
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 the
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?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH
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?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret
atwood' IN BOOLEAN MODE);h1Search font
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/transfer
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} sqltextfile.sql
Just a note: If you want to copy the structure of an
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
--
9 matches
Mail list logo