would like to be able to use MS Access
for reporting purposes.
I don't think odbc is available via the hosted webspace so I may have to export the
data periodically to the MS Access database using cron/scheduling.
Any recommendations?
Matth
The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI
isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table
Maintenance and Crash Recovery
- Original Message -
From: "Sigurd Urd
no one is using the tables while you are
running myisamchk. In MySQL Version 3.23 the easiest way to avoid this
problem is to use CHECK TABLE instead of myisamchk to check tables.
- Original Message -
From: "Sigurd Urdahl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
You should use what you referred to as an insertion counter field. I'd call
it a "id" field that uses auto_increment. It's very useful to use this and
by definition it enables you to retrieve the data in the order that it was
inserted.
> - Original Message -
> From: "Murad Nayal" <[EM
>The only problem I see is when there are concurrent access to the table
>"livreTemp", e.g. when there are multiple simultaneous requests of that
>kind. Is there a better way for achieving this under mySQL 3?
Yes, concurrent access would be a problem. I think I have the answer using a
single que
In Windows MySQLCC open a query window; select query menu; query window
options; query options tab; set SQL_BIG_SELECTS=1.
http://www.mysql.com/doc/en/SET_OPTION.html
Quote:
SQL_BIG_SELECTS = 0 | 1
If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. T
This isn't a complete answer but it may point you in the right direction...
I had some experience of using localized text (most of the popular
languages) in a database a couple of years ago. That was using Oracle but
the lessons are the same.
Initially Oracle was not UTF-8 enabled. Alot of text c
try the PHP function htmlspecialchars()
see the following article:-
http://www.yellowmarker.co.uk/articles/unicode/index.php
- Original Message -
From: "Steffen Gebert" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, August 09, 2003 11:48 AM
Subject: Fi
Yes, you can store HTML, Javascript, and Flash code in MySQL (since they are
processed by the client web browser).
And yes, you can store PHP code in MySQL, but since this has to be processed
on the server side you need to use the eval() function to execute it once it
is retrieved from the databa
you were close, try:-
update books, authors set books.AuthorID = authors.AuthorID where books.first_name =
authors.first_name and books.last_name = authors.last_name;
Notes
- you have loaded the existing flat file into a MySQL table called books.
- you mentioned that you have altered the b
see section '4.8.2 mysql, The Command-line Tool' in the manual
if you normally see 'mysql>' as your prompt. the following command would do
it:
mysql> prompt \d>
resulting in, for example, the prompt of 'test>' where you are using the
database 'test'.
'\u' would give you the username, e.g.
mysq
It's not enough to just specify the user name in the grant statement. You
need to specify the host or '%' for any host (section 4.3.1 GRANT and REVOKE
Syntax in the manual).
Try...
mysql> grant all on marksstuff.* to 'mark'@'localhost' identified by
'password';
mysql> flush privileges;
Then to l
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 16, 2003 11:48 AM
Subject: Re: Can I change the date format...
> Karam Chand <[EMAIL PROTECTED]> wrote:
> > Is there anyway to change the default date format
> > (possibly
ng a MySql table.
Thanks in advance, Braulio.
--
_____
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web development
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
timeout| 28800
$
+-+-
--------$
--
_
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web development
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
infile is a lot faster.
Matthew McNicol
Michael Gale wrote:
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local i
How are you trying to do the updates (command line, web application, etc.)?
Matthew McNicol
T UmaShankari wrote:
Hello,
Actually i am running mysql in my localpc. when i was trying to update
some contents during runtime it is not updating. But mysql is running.
Can anyone please tell me where
17 matches
Mail list logo
