Re: My SQL

On Mon, 25 Nov 2002, Miki Tan wrote: Hello, I am Miki Tan from Gleneagles Medical Centre. I am interested in MySQL database development. 1.Can I know with platform is suit for MYSQL ? Hi, and welcome to the wonderful world of open-source database development! See this for platform notes:

Re: New charset for MySQL

Dear Sir, Thank you for the tip.I am going to look the page you mentioned. Shyamal - Original Message - From: Dean Harding [EMAIL PROTECTED] To: 'Alexander Barkov' [EMAIL PROTECTED]; 'Shyamal Banerjee' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 1:03 PM

Multi-Table Updates

I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1 When I connect and execute my quiries as root user my query of multi-table update works fine update Stockists , areas set Stockists.a_nm = areas.aname where Stockists.area=areas.acd Query Executed OK , one row affected

Re: search query crashing mysql ..... :S

thnx gerald plz tell me how can i run the qoute() function on $srch i tried to look the function up in mysql doccumentation online but no luck . thnx a million toby .. From: gerald_clark [EMAIL PROTECTED] To: toby z [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: search

This is just a test: sql,query,

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

Re: New charset for MySQL

Dear Sir, I found the following page after a google search on Bengali Character set:- http://www.alanwood.net/unicode/bengali.html Thanks Shyamal - Original Message - From: Alexander Barkov [EMAIL PROTECTED] To: Shyamal Banerjee [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday,

The sales@mysql.com

The email [EMAIL PROTECTED] is disabled or moved ? I am post a mail asking details of licence ( mysql-pro and mysql-standard) and not receive a reply... exists other email to explain my licence questions ? ( this is very important for me :( ) sql,query

Re: The sales@mysql.com

Dyego, - Original Message - From: Dyego Souza do Carmo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 12:26 PM Subject: The [EMAIL PROTECTED] The email [EMAIL PROTECTED] is disabled or moved ? I have not heard that [EMAIL PROTECTED] would have

Re: Quick Nasty upgrade...

Daniel, - Original Message - From: Daniel Kasak [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 2:22 AM Subject: Quick Nasty upgrade... Hi all. I am running MySQL-4.0.4 and have just compiled 4.0.5. On the MySQL website, I found a bit that

Re: Server shuts itself down. Starting takes 10 minutes

Michael, - Original Message - From: Michael Frey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 12:49 PM Subject: Server shuts itself down. Starting takes 10 minutes I've got MySql 4 on a Win98 machine. I am using a program written in VB.net on

Have a problem when I try to connect MySQL( on Linux) thru win32

He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got

Newbie Help! Can't connect to MySQL server on 'localhost' (10061)

Well, not so much a newbie as scratcher of the surface :) I've used MySQL on my desktop under windows for a while. Never had any issues with it from the straight install. Am using 3.23.38 and MyOBDC 2.50-36. Recently (I don't know if this is relevant) upgraded to win XP Pro SP1. Now I've

Newbie Help! Can't connect to MySQL server on 'localhost' (10061)

Sorry should have made clear that is what phpMyAdmin gives me in the browser. WinMySQLadmin seems to be fine. -Original Message- From: Martin Wright [mailto:[EMAIL PROTECTED]] Sent: 26 November 2002 11:19 To: '[EMAIL PROTECTED]' Subject: Newbie Help! Can't connect to MySQL server on

re: Multi-Table Updates

ajitdixit, Tuesday, November 26, 2002, 10:33:04 AM, you wrote: aasdcdi I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1 aasdcdi When I connect and execute my quiries as root user my query of multi-table aasdcdi update works fine aasdcdi update Stockists , areas set

re: Re: search query crashing mysql ..... :S

toby, Tuesday, November 26, 2002, 10:55:38 AM, you wrote: tz plz tell me how can i run the qoute() function on $srch tz i tried to look the function up in mysql doccumentation online but no luck tz . Here is described how QUOTE() function works:

re: Have a problem when I try to connect MySQL( on Linux) thru win32

Cem, Tuesday, November 26, 2002, 1:13:45 PM, you wrote: CY I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is CY working successfully on the server, and can response all request CY comming on Server. But, when I try to connect to the database thru CY any client running on a Windows

Ïð½º

ÄãºÃ£º ÎÒ¹«Ë¾ÊÇÒÔ¾­ÓªÌØÖÖÏ𽺡¢ÏðËÜ¡¢Ä¦²Á²ÄÁÏ¡¢Èó»¬ÓÍÌí¼Ó¼Á¡¢µçÀ²ÄÁÏ¡¢ÂÖÌ¥²ÄÁÏ¡¢Õ³ºÏ¼ÁΪÖ÷£¬ÏàÓ¦¼¼Êõ·þÎñΪ¸¨µÄ¶àÔª»¯¹«Ë¾¡£ÏÖÖ÷Òª¾­ÓªÆ·ÅÆ£¨¶¡ëæ¡¢·ÛÄ©¶¡ëæ¡¢ÒºÌ嶡ëæ¡¢ÈýÔªÒÒ±û¡¢¹è½º¡¢·ú½º¡¢±ûÏ©Ëáõ¥¡¢

javascript =php= mysql

hi all, my question is very simple following is my code: ? while($row=@mysql_fetch_array( $result1 ) ) { $SrNo=$row[SrNo]; echo $SrNo; echo tr bgcolor=\#dfeaf4\ valign=\top\ td width=\10%\a href=\edit.php?SrNo=.$row[SrNo].\.$row[SrNo]./a /td td

Linux conf files in mysql tables

mysql,query Hi List Not sure if this is the right list to post to, might need a cross posting on a general Linux list as well, anyway; I would like to explore the possibilities of having (or converting) all Linux services use mysql tables for their configuration files instead of the usual

[MySQL v3.23.53a] BLOB Data and Table Size

I have two tables containing a BLOB cloumn as; -- supposed to be able to handle up to about 16MB CRETAE TABLE gallery1 ( idINTEGER, titleVARCHAR(255), mediumimageMEDIUMBLOB ); -- supposed to be able to handle up to about 4GB CRETAE TABLE gallery2 ( idINTEGER,

mysql proxy

hi all, anyone knows if exist a program load balancing and hotswap in a mysql cluster system (a sort of proxy for mysql)? Thanks in advance. __ Per te Blu American Express è gratis!

RE: The sales@mysql.com

I will contact. Gerardo Narvaja Ph: +1 425 373-3434 Fax: +1 413 825-5665 Orders https://order.mysql.com/?ref=gerardo MySQL User's Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

Concurrent queries 'wait for each other'

Hi! I have a problem with MySQL that hangs when concurrent queries run. The symptom is this: A) A Perl program that performs several queries using temporary tables takes 8 seconds to run. CPU utilisation around 30% (using the 'top' command) B) Running two instances of the same perl program in

re: Multi-Table Updates

I have update priviledge on all the tables mentioned in the query I am able to update one table at time with the same connection There is some more requirement or bug in mysql for multi-table update Regards Ajit - This mail sent through

Re: hello to new guy

Hi, In the DOS database (EDIBASE) I use at home, each organization is seperate, I exported all data as a text file, then I had to create individual web pages for each one. I have a list of each numbered web page. I would like to have only one database, instead of changing individual ones as

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

Multi-slave master

Is there any plan to be able to have multiple slaves for a master (each for different databases)? I'd like to have a backup site that remotely replicates user data from multiple sites ... any ideas? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock

Grant - questions

Greetings, I created a database. I am having problems connecting to the database remotely. Getting Access Denied. If I log into the machine that the database is on and mysql -u darryl -ppassword I get in. If I try to connect from another machine, Access denied for [EMAIL PROTECTED]. How do I

Re: Is it possible to export data from access to MySQL?

Download MySQL-Font v2.5 This is what I used when I switched from Access to MySQL. Once installed just load MySQL-Front and click on Im-/Export on the toolbar. Select ODBC Import. Viola! On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: Is it possible to export data from MS Access

RE: Is it possible to export data from access to MySQL?

I ran across several quick and dirty, but very effective little converters at this site: http://www.intranet2internet.com Regards, Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November

Re: Is it possible to export data from access to MySQL?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve, It is quite possible. You can use MyODBC to connect your current Access database(s) into your MySQL server directly, the major drawback is that you'd have to create the overall table structure in MySQL first and then link the table from

Re: Grant - questions

Hi! RTFM :-) These URLs will help you: http://www.mysql.com/doc/en/User_names.html http://www.mysql.com/doc/en/GRANT.html http://www.mysql.com/doc/en/Adding_users.html Iikka On Tue, 26 Nov 2002, Darryl Hoar wrote: Greetings, I created a database. I am having problems connecting to the

RE: Is it possible to export data from access to MySQL?

Cheers. Sorted very quickly using MySQL front. Good thing is I can use that to get the SQL and then cut and paste it to any DB I like which is PDG! Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -Original Message-

Re: [MySQL v3.23.53a] BLOB Data and Table Size

On 26 Nov 2002, at 8:52, Pae Choi wrote: Q: How come the size of table does not decrease after deletion? MySQL will reuse that space when you insert new records. To recover the space, you need to optimize the table: http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html P.S.: MySQL, SQL,

Re: Is it possible to export data from access to MySQL?

MySQL-Front is quite good for this... - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: MySQL General Mailing list [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 4:37 PM Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS

SQL Row Counting in MySQL

Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10 (where rownum is not a specific column, just a count of how many rows have been returned)

Re: Re: hello to new guy

From: Norm Lamoureux [EMAIL PROTECTED] In the DOS database... each organization is seperate... ...exported all data as a text file ...individual web pages for each one. Individual web pages for each one, does this refer to items like: http://www.informsarnialambton.org/listing/36.HTM I

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

Re: Is it possible to export data from access to MySQL?

Hi! Yes, it's possible. Export your Access data to standard csv files, and then use mysqlimport with appropriate parameters to import the csvs into MySQL. The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA INFILE statements (which can do the same as mysqlimport). Iikka On

Re: [MySQL v3.23.53a] BLOB Data and Table Size

First of all, thanks for your reply as well as a pointer to the Doc. I tried the OPTIMIZE command as follows: mysql optimize table gallery; mysql optimize table gallery2; Both does not contain any entry since I deleted the BLOB data. But the size of tables, gallery.db and gallery2.db does not

re: Lost connection to MySQL server during query

Mark, Tuesday, November 26, 2002, 7:32:15 AM, you wrote: M Yes, again. :( Although reluctantly, I finally decided to upgrade to M 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors. M Alas, 6 out of 10 times when I start a MySQL application, I get an error M like this: M

re: NaNs

Seth, Tuesday, November 26, 2002, 2:00:05 AM, you wrote: SN If I have a key on a float and attempt to insert a NaN I get SN ERROR 1034: Incorrect key file for table: 'foo'. Try to repair it SN if I attempt to update/delete that row. SN If I remove the key from the float it seems to behave when

re: Lost root password.

Jacek, Tuesday, November 26, 2002, 2:05:40 AM, you wrote: JM I have made the mistake and now have no root access to mySQL. Could you JM help me, please, to reset the root password. Please, look at the manual: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical

re: Grant - questions

Darryl, Tuesday, November 26, 2002, 4:46:32 PM, you wrote: DH I created a database. I am having problems connecting DH to the database remotely. Getting Access Denied. DH If I log into the machine that the database is on and DH mysql -u darryl -ppassword DH I get in. DH If I try to connect

re: MySQL 3.23.49 - strange replication error

Liz, Monday, November 25, 2002, 6:47:35 PM, you wrote: LC I've got a master database with 2 slaves. I've had them up and running for LC quite a while now with no problems, but today I noticed an error - there was LC a slave running on the master! LC I checked /etc/my.cnf - no mention of slaves

re: [MySQL v3.23.53a] BLOB Data and Table Size

Pae, Tuesday, November 26, 2002, 6:52:20 PM, you wrote: PC I have two tables containing a BLOB cloumn as; PC -- supposed to be able to handle up to about 16MB PC CRETAE TABLE gallery1 ( PC idINTEGER, PC titleVARCHAR(255), PC mediumimageMEDIUMBLOB PC ); PC -- supposed to

re: re: Multi-Table Updates

ajitdixit, Tuesday, November 26, 2002, 4:18:42 PM, you wrote: aasdcdi I have update priviledge on all the tables mentioned in the query aasdcdi I am able to update one table at time with the same connection aasdcdi There is some more requirement or bug in mysql for multi-table update Show me

Re: SQL Row Counting in MySQL

There is SQL function called COUNT. Check it out and see of that helps you. Pae Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10

Re: SQL Row Counting in MySQL

Tom Place wrote: Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10 (where rownum is not a specific column, just a count of how many rows have

access2mysql:MacOSX

I have a similar question, but for access2mysql under MacOSX--any tools out there that facilitate the import process easier--that is, easier than access export to csv/txt, then import from csv/txt into mysql? PSA - Before

Re: SQL Row Counting in MySQL

Hi, Select * from Blah where stuff=true limit 10; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Tom Place

re: SQL Row Counting in MySQL

Tom, Tuesday, November 26, 2002, 5:01:08 PM, you wrote: TP Is there a simple way in MySQL to only select the first x rows that meet TP a specified criteria. TP For example in Oracle the following would work: TP Select * from Blah where stuff=true and rownum = 10 TP (where rownum is not a

Re: hello to new guy

Hi, Sounds like I am confusing everyone... I only have one database with over 800 records The data on the website is the result of my database. I wish to search on words in each record. I might be able to export each record as a CSV file? Clear as mud (I think) Thanks again, Norm Rodney

Re: SQL Row Counting in MySQL

Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10 ? (where rownum is not a specific column, just a count of how many rows have been returned)

Re: SQL Row Counting in MySQL

On Tue, 26 Nov 2002 15:01:08 -, Tom Place wrote: a simple way in MySQL to only select the first x rows See LIMIT: http://www.mysql.com/doc/en/SELECT.html - Steve Yates - If at first you don't succeed, then skydiving isn't for you. ~ Taglines by Taglinator - www.srtware.com ~

possible problems with FLUSH TABLES WITH READ LOCK

Hi, I am using FLUSH TABLES WITH READ LOCK to get consistent snapshots of my database without shutting it down. The setup is : - bi-P4 Xeon with Redhat 7.3 - 2.4.19 kernel with properly patched LVM (compiled from source) - MySQL server 4.0.4 (compiled from source) - ext3 filesystem on a 44 GB

browse the fulltext indexes

Hi all, I'd like to know if there is a way to browse the fulltext index of a field in a mysql database (e.g. accessing to the tables where the full text indexes are stored). Thanks, Luca Lelli __ Per te Blu American Express è

Insert error

I'm running MySQL as a service on win2k and trying to insert data into a database. Each time I try to do this I receive the following error: ERROR 2013: Lost connection to MySQL server during query The following error was shown when I opted to debug: Unhandled exception at 0x004803c9 in

RE: MySQL 3.23.49 - strange replication error

It only happened the once, I've checked the history and no one executed any odd commands (that I noticed:-) Thanks Liz -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 26 November 2002 15:45 To: [EMAIL PROTECTED] Subject: re: MySQL 3.23.49 - strange replication error

Re: hello to new guy

From: Norm Lamoureux [EMAIL PROTECTED] Sounds like I am confusing everyone... I only have one database with over 800 records The data on the website is the result of my database. I wish to search on words in each record. Search with what? Do you mean the page at:

Re: hello to new guy

there may be some willing to help, but having trouble understanding. i don't know about anybody else, but i've been following this since his first posting, and my simple mind is having trouble identifying his problem. is it technical, organizational, or sociological? mysql From: Norm

Re: Is it possible to export data from access to MySQL?

I used MyAccess to convert my 40mb .mdb file into MySQL and it works great. You can find it and a whole bunch of other conversion tools on the MySQL site in Downloads/Other. Here's the link, http://www.mysql.com/downloads/os-win32.html Good Luck Steve Jackson [EMAIL PROTECTED] 11/26/02 6:37:45

Mac OS X installation problem...

I installed the MySQL (mysql-3.23.51) package from VersionTracker.com on my Titanium PowerBook running Mac OS X 10.2. Whenever I execute any mysql command I get the following error: dyld: ./mysql Undefined symbols: ./mysql undefined reference to _BC expected to be defined in

Connecting via 127.0.0.1 (was Need to force Mysql to use port, NOT socket)

In this episode I figured out that the problem is not stunnel or the remote connection. I simply cant log in with the command: mysql -u root -h 127.0.0.1 -p I just get a connection refused message. There should be a trick here that I'm missing if history is a lesson, but I'm a noob to mysql.

Perl scripts to run concurrent commands on MySQL

Does anyone please have any Perl scripts to execute concurrent SELECT commands on MySQL? Any scripts that do not use fancy libraries would help. Please help. Thanks. - Before posting, please check:

Re: My SQL

From: Miki Tan [EMAIL PROTECTED] I am Miki Tan from Gleneagles Medical Centre. I am interested in MySQL database development. 1.Can I know with platform is suit for MYSQL ? It works very nicely with MacOS X. The only time it ever goes down is when I install an update. SQL SQL SQL SQL

Re: [MySQL v3.23.53a] BLOB Data and Table Size

no database manager that i know of automatically packs the database after every record deletion. it would be too costly. that is one of the reasons that most of us do not store blobs in databases, but store them externally. I have two tables containing a BLOB cloumn as; -- supposed to

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

LIMIT in MySQL

I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike - Before posting,

Re: Mac OS X installation problem...

Try mark linayage's package at: http://www.entropy.ch/software/macosx/welcome.html It is very easy to install and it works great. PSA On 11/26/02 11:28 AM, Michael Burbidge [EMAIL PROTECTED] wrote: I installed the MySQL (mysql-3.23.51) package from VersionTracker.com on my Titanium

Re: Insert error

Mark, Are you working from the command line or using a tool (which)? MySQL version nr? Are you running WinMySQLadmin (the traffic lights in the System Tray)? =dn I'm running MySQL as a service on win2k and trying to insert data into a database. Each time I try to do this I receive the

Re: Perl scripts to run concurrent commands on MySQL

Geetika Tewari wrote: Does anyone please have any Perl scripts to execute concurrent SELECT commands on MySQL? Any scripts that do not use fancy libraries would help. Please help. Thanks. Read up on 'fork' and make yourself a fork_do_query function of some form so you can call: my

Re: Connecting via 127.0.0.1 (was Need to force Mysql to use port, NOT socket)

In the last episode (Nov 26), twig les said: In this episode I figured out that the problem is not stunnel or the remote connection. I simply cant log in with the command: mysql -u root -h 127.0.0.1 -p I just get a connection refused message. There should be a trick here that I'm

RE: LIMIT in MySQL

It is starting at record 30 and sending you the next 60 records. Maybe you want LIMIT 30, 30 ? David -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must not be awake yet. Why is

Re: hello to new guy

Hi, Ok, I guess I was confusing everyone. I thought this was a simple problem, we need a search engine to search through our data, I might be able to convert to csv, or I found another way... example... -NO- SAR1100 -COMMENTS- 999 try6 -ORG_LEVEL_1- SARNIA COMPUTER USERS' GROUP

Re: LIMIT in MySQL

At 12:56 -0500 11/26/02, Mike At Spy wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 No. 30 = number of records to skip 60 = number of records

RE: LIMIT in MySQL

LIMIT is LIMIT starting record,number of records...no? Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must

Re: LIMIT in MySQL

Hello. On Tue 2002-11-26 at 12:56:04 -0500, [EMAIL PROTECTED] wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? Because it's LIMIT offset, amount i.e. you are asking for rows 30-89 Bye,

RE: LIMIT in MySQL

Read the documentation. http://www.mysql.com/doc/en/SELECT.html The link has been sent out on this list about 6 times this morning, all in posts regarding the limit clause. The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two

Re: Executing concurrent select statements from perl on MySQL ISAM tables(fwd)

Sorry, Geetika. It looks like I lost this thread in the mix. Have you tried some Perl like this: # concurrent.pl # Check start time. for my $n (1..$DO_TRIES) { print qq{Doing # [$n] PID [$$]\n}; my $pid = fork(); if ($pid == 0) { print qq{Child [$$] running command.\n};

Re: LIMIT in MySQL

Your command says select 60 rows starting at row 30. You want LIMIT 30, 30 to get 30 rows. Matt - Original Message - From: Mike At Spy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 9:56 AM Subject: LIMIT in MySQL I must not be awake yet. Why is this query

Re: LIMIT in MySQL

its not LIMIT from, to, its LIMIT start, count SELECT * FROM table ORDER BY somefield LIMIT 30,30 On Tuesday 26 November 2002 11:56, you wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT

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

Re: LIMIT in MySQL

At 12:56 PM -0500 11/26/02, Mike At Spy wrote: I must not be awake yet. Why is this query sending me back 60 records? Shouldn't it only send back records 30 through 60 (i.e. 30 records)? SELECT * FROM table ORDER BY somefield LIMIT 30,60 Thanks, -Mike As computers are wont to do, it's

join with OR and LIMIT fails to return result

Description: join with OR and LIMIT fails to return result How-To-Repeat: This query fails to return a result: mysql SELECT Subscriptions.UID FROM Subscriptions, Accounts WHERE Accounts.UID = Subscriptions.User AND (Accounts.Email = 'bill' OR Accounts.UName = 'bill') ORDER BY

Re: Is it possible to export data from access to MySQL?

Dear Steve, Is it possible to export data from MS Access into MySQL? If you don't care to export every single table manually, this is what you do: 1. Install MyODBC 3.51.04 2. Configure a system DSN for your MySQL server. 3. In Access, right-click the table to be exported. 4. Choose Export...

Re: [MySQL v3.23.53a] BLOB Data and Table Size

At 10:36 -0800 11/26/02, Pae Choi wrote: First of all, thanks for your reply as well as a pointer to the Doc. I tried the OPTIMIZE command as follows: mysql optimize table gallery; mysql optimize table gallery2; Both does not contain any entry since I deleted the BLOB data. But the size of

Re: Perl scripts to run concurrent commands on MySQL

From: Michael T. Babcock [EMAIL PROTECTED] Read up on 'fork'... ... (wait for pid1, pid2) ... Geetika, Michael's snippet is better (required) for the end result that you are after. When you get to the point of actually wanting the numbers, you will need to wait for the children to finish.

Re: LIMIT in MySQL

From: Jim Esten [EMAIL PROTECTED] LIMIT is LIMIT starting record,number of records...no? From the 4.0.0-alpha docs, section 6.4.1: The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. If two

Re: [MySQL v3.23.53a] BLOB Data and Table Size

Paul, It really did the trick. Thanks. Regards, Pae - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 10:59 AM Subject: Re: [MySQL v3.23.53a] BLOB Data and Table

Re: hello to new guy

Hi Norm, It sounds to me like we have some lack of clerity. Let me see if I can place some useful definitions: - CSV A text format for representing data. - CSV file A file written in the CSV format. - Database A place to store data. - Program Software that does something. - Database

Fw: Concurrent queries 'wait for each other'

- Original Message - From: gerald_clark [EMAIL PROTECTED] Wrote: Perhaps each process simply requires 8 seconds of disk access. Since they share the same disk it will take 8sec. times the number of processes running to complete. You have a strange definition of hang. Claus

Question about slave server

sql,query In a replicated environment, are slave servers read only or can a user attach to one and perform updates? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check:

Things are a lot better with humor

Not quite sure if this is appropriate for the list, but I had to share it SQL Query http://www.thinkgeek.com/tshirts/frustrations/595d/zoom/ Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Setting variables in XP

I would like to put SET AUTOCOMMIT=0 in my.ini. When I put it under [mysqld], mysql will not start as a service. When I put it under [WinMySQLadmin], the service starts but does not appear to have any effect. Any suggestions? Kindly, Peter Boivin [EMAIL PROTECTED]

Re: hello to new guy

so one of your questions is, if i may paraphrase, what database manager should i use? i believe that you said that it has only eight hundred records? and it's only a single table? you can manage it manually with little trouble? and it's a low volume web site? pardon my sacrilege, but if

Re: join with OR and LIMIT fails to return result

interesting. of course, removing one of the limiting selection criteria would increase the number of possible selected records. and the limit clause does not seem to be correctly constucted. but forgive me if i just don't understand. if you have a windows box for a front end, download

Recovery with binary logs.

Hi, I have a few questions regarding recovery of a database using binary logs. 1) If you have a set of binary logs in your directory mylog-bin.001 to mylog-bin.nmp, is there an easy way to find out which logs you need to run since the last backup? In other words, when according to the

Re: Connecting via 127.0.0.1 --SOLVED (still ironing out details)

Thanks gerald, I totally forgot about the 'identified by' part. Doh! I had to tell mysql to bind to 127.0.0.1 also, which I had tried before but without assigning the password so combining the two steps certainly worked better than one at a time. :) I got in and am now seeing a different error

Re: join with OR and LIMIT fails to return result

Hi, John : I don't see any connection between corereader and this known bug in MySQL-4.0.4 ?? Bill : AFAIK, this problem has been fixed in MySQL-4.0.5, just take a look at the changelog : Fixed a newly introduced bug that caused ORDER BY ... LIMIT # to not return all rows.

  1   2   >