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 infile
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
$
+-+-
$
--
_
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]
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]
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?
Matthew McNicol
- 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 in a .ini
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
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
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.
mysql
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
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: Filtering
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
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.
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 query
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 [EMAIL
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
. 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: Matthew McNicol [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 4:04 PM
Subject: Re
17 matches
Mail list logo