Re: sql password issue

Hi John Do you email your provider? What did they say? Greetings Andres Berger -- Gerente de Marketing -- OnLynux Aloja tu Web $14.99 Anual -- www.onlynux.com/hosting

reg:time difference

I need some help in finding the time/day difference as i want to know the session times is there a way/function to calculate time difference in mysql thanx heaps chandra __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http:/

mysql load issue

I have been trying to get mysql db to run but keep getting access denied. The error is: Warning: Access denied for user: 'mine@localhost' (Using password: YES) in /home/gulf/public_html/SiTeS_1/pUbS9_A/test/config.inc.php on line 106 Warning: MySQL Connection Failed: Access denied for user: 'mine

Re: sql password issue

I have been getting access denied and am stuck. How do i change the password for root in mysql? I am hosting on a third party site. The allow me to use phpmyadmin. Thanks --- [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to > be either spam or > simply off topic to

Reg: Myisamchk

Hello all, In mysql tables if i want to exclude some tables to do myisamchk how can i do that. As if i use myisamchk *.MYI it is taking too much time to check all the tables. For that i can exclude some previous days dynamic tables and i can execute this How to do that??? Thanx in advance.

Data base driven web page idea - need help!

I need help. I am building a database for a small college that wants to be able to update their program information for each department through an web/gui program. I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my web page this way) Here's my QUESTION! Because some of th

re: re: Multi-Table Updates

Hi , Result for Show Grants is as under SQL result Host: localhost SQL-query: SHOW GRANTS FOR aldixit@localhost; Grants for aldixit@localhost GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost' IDENTIFIED BY PASSWORD 'xx' GRANT SELECT ON `mysql`.* TO 'aldixi

=?unknown?q?=BFConoces?= verdaderamente el calostro bovinomysql@lists.mysql.com?

Saludos [EMAIL PROTECTED]! Intento informarte, mas no molestarte al invadir tu privacidad para presentarte algo que esta por encima de cualquier remedio o medicamento que conozcas. EL CALOSTRO BOVINO DE NUEVA ZELANDA. Puedes visualizarlo aqui http://www.hispa21.com/agente.asp?id=1310001 Te inv

Re: Lost connection to MySQL server during query

- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 4:44 PM Subject: re: Lost connection to MySQL server during query > Mark, > Tuesday, November 26, 2002, 7:32:15 AM, you wrote: > > M> Yes, again. :( Although relu

YourSQL: a Mac OS X MySQL graphical client

Not sure if this has been mentioned here yet, but there's a graphical client named YourSQL available for Mac OS X. It runs native with an Aqua interface. Acts something like the DBTools and MySQLFront apps that run on Windows. http://www.osdir.com/modules.php?op=modload&name=News&file=article&si

Records missing from web query

Situation.. main table in a relatively small database. Table contains approx 370K rows. Table is indexed on the unique identifier. New table, fresh import of clean data. Querying on a single field... run from the command line, returns 3 rows, run from phpMyAdmin, returns 3 rows. Identical query

Ïð½º

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

Building mysql w/ Intel's C++ compiler...

Anyone have tried to build mysql with intel's c++ compiler? Does it build stable binaries and faster than the one built w/ gcc? query -- Chung Ha-nyung Sayclub NeoWiz - Befo

Re: hello to new guy

From: Norm Lamoureux <[EMAIL PROTECTED]> > I downloaded the lastest version of MySQL the other day but it > all looks greek to me, not like a database like ACCESS or Alpha Five. Now I'm with you! You're talking about a database being a program with a nifty front end for the users as well as a ba

Re: hello to new guy

Hi, You got part right, the database I use at home is Edibase for DOS, the program has been updated for Windows, too expensive for that and the web plug in ($5,000.00 I think) I am trying to port it over to a Windows Database. I downloaded the lastest version of MySQL the other day but it all look

Re: hello to new guy

From: Amer Neely <[EMAIL PROTECTED]> > I think what Norm is trying to do... is search a DOS-based database > using a script from Excite. > The data has to be updated on the server, but in a format searchable > by the script. Ohhh, that makes sence for his descriptions so far. > Why not ask you

RE: script

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 9:51 AM > To: Mysql maillist > Subject: script > > > Hi All. > I have written a SQL script that should retrieve all the rows from a > table that match a value given as parameter

Re: where to download v4.0.5 (was: MySQL/InnoDB-4.0.5 is released)

Hi. Please do not cross-post without a very good reason. Removed win32 list from CC. On Wed 2002-11-27 at 10:38:25 +1100, [EMAIL PROTECTED] wrote: > hi > > i have had a look for a download of this release (ie 4.0.5) and the latest > release that i have been able to locate a download for is for 4

Trying to install DBI

I get the following error when trying to do a 'make' after doing a perl Makefile.PL to DBI 1.1.8 cc -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -O -DVERSION=\"1.18\" -DXS_VERSION=\"1.18\" -I/usr/opt/perl5/lib/5.00503/aix/ CORE -DDBI_NO_THREADS Perl.c /bin/sh: cc

Re: Lost root password.

I'm not sure if you've gotton your answer or not yet... (i have 150 more mailing list messages to go!) Try http://www.mysql.com/doc/en/Resetting_permissions.html On Monday 25 November 2002 06:05 pm, Jacek Mach wrote: > Hello, > > I have made the mistake and now have no root access to mySQL.

Re: MySQL/InnoDB-4.0.5 is released

hi i have had a look for a download of this release (ie 4.0.5) and the latest release that i have been able to locate a download for is for 4.0.3. is there a url that anyone can direct me to to download 4.0.5 (or even 4.0.4) or are these commercial releases? thanks. - Original Message -

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... > [ snip ] I think what Norm is trying to do (Norm correct me if I'm wrong) is se

mysqld-nt --local-infile=1 not working

Environment: MySQL = 3.23.53-max-nt Windows 2000 Pro SP3 Apache 2.0.43 PHP 4.3.0 dev Configure mysql startup as "Manual" in Windows 2000 Services. From command prompt, run E:\mysql\bin>mysqld-nt -local-infile=1 The mysqld server would run but still does not allow LOAD DATA LOCAL INFILE. Next r

Left Join more than one table

HI I'm using ver 3:23:49 & 3:23:53, I thought "A LEFT JOIN B USING (c)" is Identical to "A LEFT JOIN B ON A.c = B.c" It seems it is NOT the case if you are joining more that ONE table & one of them is EMPTY. Please see the following Example mysql> select * from room; +-+-

RE: Question about slave server

If you don't care about the data being out of sync with the master and are not concerned with any problems it might cause, such as the slave thread stopping due to replication errors caused by out of sync auto_increment fields and the like. -Original Message- From: Heikki Tuuri [mailto:[EM

Re: Setting variables in XP

Peter, - Original Message - From: ""Peter Boivin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 11:25 PM Subject: Setting variables in XP > I would like to put "SET AUTOCOMMIT=0" in my.ini. When I put it under > "[mysqld]", mysql will not star

Re: Question about slave server

Carl, - Original Message - From: "Carl McNamee" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 11:10 PM Subject: Question about slave server > sql,query > > In a replicated environment, are slave servers "read only" or can a user > attach to one a

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. " http://www.mysql.co

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 b

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 instructio

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 core

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 t

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] ---

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)

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: http://w

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". > >

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

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 Da

Re: LIMIT in MySQL

From: Jim Esten <[EMAIL PROTECTED]> > LIMIT is "LIMIT ,"...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 arguments are given, the first spec

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 finis

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: 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...

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 Subscr

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 sendi

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 1

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)? > > SELE

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

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}; exec(qq{e

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 numeri

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 , i.e. you are asking for rows 30-89 Bye, Benjam

RE: LIMIT in MySQL

LIMIT is "LIMIT ,"...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 not be awake yet. Why is this qu

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: 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 -AL

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: 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'

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 $result

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 foll

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 P

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: 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 dat

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

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

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: http://www.mysql.com/ma

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. A

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 /usr/lib/libSystem.B.d

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

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 La

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: http://www.informs

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

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 mysq

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 è g

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 L

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 ~ St

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 retu

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 Bro

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: 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" <

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 posti

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 ha

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 rown

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: [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> -- suppo

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 slav

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 co

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: 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 w

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:

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" doe

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: 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 na

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

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: 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

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?

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: 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 da

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 MySQL

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?

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 Acce

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 d

  1   2   >