RE: access-mysql
I saved the email last time this was posted, didn't look into it but someone suggested looking at this site. http://www.intranet2internet.com . Another option was to link the table, not exactly sure of all the steps but maybe create an empty table in mysql with all fields and data types, then 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 them how to program, you will frustrate them for a lifetime. -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is it possible to export data from access to MySQL?
A quick way. If you don't have phpMyAdmin running set it up. It has a great import feature. Just dump the access table to a delimited text file. Then go to phpMyAdmin, from the main page - create a new database, or select an existing one. from there scroll down to create a table, enter the 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 them for a day. If you teach them how to program, you will frustrate them for a lifetime. -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:38 AM To: MySQL General Mailing list Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is it possible to export data from access to MySQL?
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, November 26, 2002 12:50 PM To: MySQL General Mailing list; [EMAIL PROTECTED] Subject: Re: Is it possible to export data from access to MySQL? you're gonna get lots of neat high tech answers to your problem, so here's a low tech answer just because it's fun. construct the database in mysql. copy the access database to a working copy to be safe. in the working copy, link to the mysql tables. open the access table a and copy the data. open the mysql table a and paste the data. : ) the kid in me loves doing that. copy and paste is the most powerful concept in windows. the only reason that i don't use it in corereader is that it would permanently tie corereader into ms. windows. Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server no longer starts after data folder copy.
Hi All, I have messed up my server just a bit, it no longer starts ;) I have 2 servers one on a 98 machine for testing, and another on a 2000 box that is being set up for intranet applications at my company. I usually do changes etc on the 98 box then just stop both servers and copy the data folder from my 98 box to the 2000 box. This time when I wen't to restart the service on the 2000 box i get a message Fails to start the service, please wait 30 seconds and try again. I did and no go :( I'm new to mysql and db admin stuff so what I have been doing is probably not the best way to do this, but it has worked for me so far. So can anyone tell me what I can do to fix this? Also by simply stopping the service on the 2000 box am I actually shutting down the server? Is there another way I should be doing this kind of thing? I am running mysqld-max-nt on the 2000 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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
startup on win2000 as service not working.
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 because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: startup on win2000 as service not working.
Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the 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 sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. 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 because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: startup on win2000 as service not working.
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 working. Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the 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 sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. 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 because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL as a desktop DB
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: Re: MySQL as a desktop DB I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] phpMyAdmin is this possible
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 configured correctly. To create a new database just type the name in the box on the home page and click create, from there you can create new tables etc. hth Steve. -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 3:12 PM To: MYSQL; Php-General Subject: [PHP] phpMyAdmin is this possible I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] time field query problems.
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: Re: [PHP-DB] time field query problems. Steve, 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.23.49-max) time field, allows nulls, default is NULL. If this cannot be done in a query, whats the best way to compare time in php? The best way to compare time in PHP is to use the MySQL RDBMS that is managing/retrieving the data for you. Recommendation 1: do not use a Time field (you did mean the back 'half' of a Date-time field didn't you?). Because you are (apparently only) using this field to temporarily lock a row, the value is only ever used for computation (cf display). A Timestamp field is best for computation - a Time field for presentation. Consider also storing such data as an integer field or beware the automatic update feature for Timestamp fields. Recommendation 2: re-consider the (default) use of NULL - this may be the root of the question you're asking: what if the row has never been 'locked' and attempt the (above) SELECT? (then the last comparison clause would be illogical) If the default were zero (0 or 00:00:00) and the retrieval logic updated slightly, things should be less complicated. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DATE INTERVAL question.
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 conjunction with PHP. SELECT EDIT_LOCK FROM ordmaster WHERE ORDER_NO = '5' AND EDIT_LOCK 0 AND EDIT_LOCK EDIT_LOCK + INTERVAL 10 MINUTE; TIA, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: DATE INTERVAL question.
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: [EMAIL PROTECTED] Subject: Re: DATE INTERVAL question. Hi. On Mon 2002-07-29 at 11:35:03 -0400, [EMAIL PROTECTED] wrote: 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. This does not make sense. This will always be true: A A + 10 = 0 10 = true 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 conjunction with PHP. SELECT EDIT_LOCK FROM ordmaster WHERE ORDER_NO = '5' AND EDIT_LOCK 0 AND EDIT_LOCK EDIT_LOCK + INTERVAL 10 MINUTE; Well, does SELECT EDIT_LOCK FROM ordmaster WHERE ORDER_NO = '5' return any rows? What about SELECT EDIT_LOCK FROM ordmaster WHERE ORDER_NO = '5' AND EDIT_LOCK 0 EDIT_LOCK 0 should work as expected. The rest should resolve to true, so I do not see any reason why you do not get the desired result. Exclude PHP from the equation, i.e. run the query in the mysql command line client. Greetings, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
time field query problems.
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.23.49-max) time field, allows nulls, default is NULL. If this cannot be done in a query, whats the best way to compare time in php? Thanks, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB or MyIsam?
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 insert statements in a loop didn't work you could rollback the changes or if they all worked, you would commit the changes to the database. You can't use transactions with MyIsam. -Steve. -Original Message- From: Konstantin Yotov [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 7:29 AM To: [EMAIL PROTECTED] Subject: InnoDB or MyIsam? Hello! :) I'm wondering which table type is better and why for web project with about 100 000 customers. May be InnoDB gives better query performance? I'm using now MyIsam, but is this better idea to move to InnoDB? Thank you! :) __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb and transactions
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://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Innodb and transactions
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('Insert something'))){ mysql_query('COMMIT'); } else { mysql_query('ROLLBACK'); } I'm working from memory here. I use the ADODB wrapper and it works a little different. (Look into it, it's a great piece of code) HTH, =C= -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 7:58 AM To: [EMAIL PROTECTED] Subject: Innodb and transactions 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://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
indexing?
-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 question is about Over Indexing. I have a MySQL MyISAM table that stores inventory transactions, in, out etc. I store numeric fields that are primary indexes in other tables, 2 datetime fields and a qty field, Paul DuBois' MySQL book says that anything used in a where clause or join clause is a candidate for an index. It turns out that 7 out of eight fields fit this description,1 primary key, 4 smallints, and 2 are datetime fields. Should I use all these indexes or is this overkill? Thanks for any input -Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: data compare and duplicate entries..
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 for an SQL statement or script that whould allow me to compare data when it was entered into a mysql-php field on a web page so that it checks whether the data entered has not been used before in the database.. In short, when data needs to be entered, the statement/script must check in the database whether the data is not already entered into the database and if its there, return with an error.. and not allow the data to be entered... if the data is not there, then it may be entered.. Thanx Willem Pretorius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database security
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: database security Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new to MySQL
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.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie question.
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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: newbie question.
Ya I am running it on my local machine and I'm doing some development, I have some people here excited about mysql and they want to play with it so I granted them access through apache via ip address and created databases for them, however I really don't wan't them to be able 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 you running the db server on your local machine? Or are you having it hosted somewhere and using PHPMyAdmin? In the second case, you will have to contact your hosting company to find out how they handle it. Some hosting companies severely restrict your access to the security tables. If you have full access, check out: http://www.mysql.com/doc/P/r/Privilege_system.html and http://www.mysql.com/doc/U/s/User_Account_Management.html Hope this helps! Craig Ostrander At 10:30 AM 4/16/2002, you wrote: 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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php === Craig Ostrander Blue Forest Software and Development Inc Database Design Consultants Worldwide MySQL // SAP DB // Oracle // Microsoft SQL Server // Microsoft Access Need help now? [EMAIL PROTECTED] or +1 530 326 5680 === spam filter: sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php