n set up
an odbc connection to mysql then link the empty table from access to mysql
and copy data from access table to linked mysql table, this way its all done
in access.
HTH,
Steve Bradwell
MIS Department.
"If you give someone a program, you will frustrate them for a day. If
you
teach t
I like that one.
Steve Bradwell
MIS Department.
"If you give someone a program, you will frustrate them for a day. If
you
teach them how to program, you will frustrate them for a lifetime."
-Original Message-
From: John Ragan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Novembe
table name
and amount of fields. Enter all field names and types. Save it, then scroll
down to "Insert data from a textfile into a table" and follow the
instructions. Its a piece of cake from there.
Steve Bradwell
MIS Department.
"If you give someone a program, you will frustrate th
000 box, with innodb.
Steve Bradwell
MIS Department.
"If you give someone a program, you will frustrate them for a day. If you
teach them how to program, you will frustrate them for a lifetime."
-
Before posting, please
That was it! Thank you all for your help.
Steve.
-Original Message-
From: Iikka Meriläinen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 2:21 PM
To: Steve Bradwell
Cc: [EMAIL PROTECTED]; Oluwagbamila Oyekanmi; Bruce Lewis
Subject: RE: startup on win2000 as service not
startup folder the server does not
start.
Thanks again,
Steve
-Original Message-
From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 12:10 PM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: Re: startup on win2000 as service not working.
Check your ini file to make
Hi everyone,
I have recently moved my mysql server from a win98 machine to a win2000
machine. After running the self extracting setup for mysql, I copied my
existing my.ini file over from the win 98 box, made neccesary changes to
start mysqld-max-nt from correct dir, I copied the my.ini file beca
I use MySQL as a desktop db. It is alot faster than access, and much more
efficient. A great front end I use is phpMyAdmin.
www.phpMyAdmin.org
-Steve.
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 1:58 AM
To: MySQL List
Subject: R
Do you have phpMyAdmin running yet? If so you create new databases with the
click of a button. The first page you see should say Welcome to phpMyAdmin
...ver etc. If you have set phpMyAdmin to run on an existing MySQL install,
the drop down boxes "should" contain your existing databases if configu
Thanks,
I wasn't sure what kind of field to use, I'll give the timestamp a try and
set 0 as default.
Regards,
Steve.
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 6:34 PM
To: Steve Bradwell; [EMAIL PROTECTED]; Php-Db (E-mail)
Subject
Ya I ran them from the command line and they all work except for when I do
the EDIT_LOCK + INTERVAL 10 MINUTE. It actually returns NULL. Very Strange.
-Steve.
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:13 PM
To: Steve Bradwell
Cc
Sorry to repost but I typed in the wrong sql statement in my previous post.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE < now()
AND ORDER_NO = '5' AND EDIT_LOCK > 0;
-EDIT_LOCK is a MySQL (ver 3
Hi,
I am trying to run a query that will check to see if a time field is less
than the the time in the field plus ten minutes. The field must also be
greater than 00:00:00. The query below executes without error but doesn't
return rows. Can I do this or is there a better way. I'm using MySQL in
c
It all depends if you need to use transactions. If you are entering items
from a cart into a database you may want to use transactions to make sure
ALL items get written correctly before you actually commit the changes to
the database. With InnoDB tables you can use transactions so if one or all
i
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('I
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://ww
> -Original Message-
> From: Steve Bradwell
> Sent: Friday, May 03, 2002 10:31 AM
> To: '[EMAIL PROTECTED]'
> Subject: indexing?
>
> I've been doing some reading on indexes but I thought I should get an
> experienced persons input. My ques
Are you writing a php script, perhaps with a form and a submit button,
that connects to mysql?
-Steve.
-Original Message-
From: Tech @NorthWeb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:32 AM
To: mysql
Subject: Fw: data compare and duplicate entries..
hi,
I was looking f
Hey Everbody,
I am still pretty new to MySQL and I was wondering if somone can explain the
difference
between ISAM tables and MyISAM, HEAP, innodb and Merge?
Thanks alot,
Steve
-
Before posting, please check:
http://www.
I just bought this book, it's really good so far for MySQL but not sure how
indepth the security content is
http://www.webmasterbase.com/article/225
Steve.
-Original Message-
From: Paras Mukadam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 12:19 PM
To: MySQL
Subject: datab
le to access my databases.
Is there a way I can do this with phpMyAdmin?
Thanks,
Steve
-Original Message-
From: Craig Ostrander [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 12:34 PM
To: Steve Bradwell
Cc: [EMAIL PROTECTED]
Subject: Re: newbie question.
Hi Steve:
That depends. Are
Hi everbody,
Super newbie question here,
How do I set up password protection on a single database. I am using MySQL
with phpMyAdmin.
Thanks alot,
Steve.
-
Before posting, please check:
http://www.mysql.com/manual.php (th
22 matches
Mail list logo