I'm sure this is sitting inches from my nose but I just can't see it.
In Appendix G of the manual it states:
"This is a simplistic reference that skips the details. To get more exact information,
see Henry Spencer's regex(7) manual page that is included in the source distribution."
I can't seem
does mysql provide a command to export table structure and data? i can't
seem to find anything like this in the manual. i'm trying to export tables
and data created on my desktop to my isp...help!
Jeff
-
Before posting, please
I'm very new to mysql and haven't got much of a background in databases
generally, so thanks in advance to any who have the patience to deal with my
question.
I'm trying to get data from ms access 97 to mysql by exporting to a text
file then using the "load data" command to import it.
The data in
Careful here, a left join is not necessarily the same as a join. In
particular a left join will return rows for the left table even if there are
no matching rows in the right table. Under many conditions the two are
identical but definitely not always. That being said, maybe one could use
temp
I run Linux 6.2 and don't have problems with file size. Check the version
of MySQL you run. The maximum table size was recently expanded in 3.23.x I
think. Also, look at the MAX_ROWS parameter for the table. Finally, if
nothing else works perhaps you can define the table as a UNION, check the
In your query your still asking for all rows in the table. To utilize an
index, a restrictive query often works for example:
Assuming you have an index on distance ---
SELECT * FROM loeb WHERE distance = 2;
The random tottid results from your grouping by distance. In effect you
have made group
Are MyISAM tables able to handle large indexes?
I hope I don't have to go back to ISAM tables...
Any suggestions?
Thanks,
Jeff Brewer
Spam filter bypass: (database,sql,query)
-
Before posting, please check:
http://www
Thanks,
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald L. Clark
Sent: Friday, March 09, 2001 4:02 PM
To: Jeff Brewer
Cc: MySQL Mail List
Subject: Re: mysql.host table
Then run some GRANT commands, and see what they do to the privilege
ta
There should be no password for root@localhost initially. Try
$mysqladmin -u root password 'thisIsMyNewPassword'
instead. The password mysqladmin is asking for is the current password.
The one on the command line is the new one. In your situation the current
password is nothi
#x27;t make heads or tails
of it.
-Jeff Brewer
-Original Message-
Did you read chapter 6 in the manual?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
er/db/host)
doesn't always give me the same set of access rights. Can anyone provide an
example of using the host table to grant permissions? Especially useful
would be an example in which using the db table alone would not achieve the
same results as using the db/host tables.
Than
11 matches
Mail list logo
