Duplicate of Everything in Table

You're right. Is there anyway around this hassle of having to do all the different IDs? Something like: DELETE FROM Page wheres articleid=articleid and pageid=pageid limit 1 Would that work? Ryan Shrout Production Manager Athlonmb.com http://www.athlonmb.com [EMAIL PROTECTED]

Re: REPOST: SELECT syntax

"Thalis A. Kalfigopoulos" wrote: Check you don't have empty strings as empty remarks, but that you have NULLs. Even with empty strings as remarks though you can bypass them with an extra WHERE condition :-) That was it. I was storing empty strings, instead of NULLs. Thanks! AMK4

full text indexes

Hi, I am facing aproblem in full text index catalog. I have uploaded tables using sql server 7 from client to server having database mysql server. I am finding that while connecting to the server the full text index feature becomes inactive, though on client machine it is active. Now I am not

Some more about mysql perfomance.

Hello mysql, I made one more test of mysql perfomance. PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 I had the followings table with 12.000.000 rows (well I checked this with 1 rows as well but the speed does not differs much) in it and I checked how fast I can select data by hash

quota's ?

Hi... Is there a way to limit the amount of disk space a mySQL server can use ? Or to limit this for a specific database on the server ? (or preferably both ?) (apart from limiting this in an external way, like the quota's on the linux file system or something like that) Also, is it possible

Problem in connectivity through C++

Hello Sir , I have RedHat Linux7.0 . I install MySql-3.23.36 . By using C++ I am trying to coonect to database . I use C++ wrapper classes for the same which in build uses the Mysql++ API.I can compile and also link the programe. And when I run that programe if i give the

HELP me!

I have a little matter for begin my server mysql... When I want to connect to mysql, it happends that : RROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) and when i want to start ma server manuelly : $/mysql.server start $Starting mysqld daemon with

Re: HELP me!

The error log in ~mysql/var should give you a hint as to your problem. P On Fri, 6 Apr 2001, Franois Grenapin wrote: I have a little matter for begin my server mysql... When I want to connect to mysql, it happends that : RROR 2002: Can't connect to local MySQL server through socket

MySQL error 1114: The table 'SQL7db1e_0' is full

Hi, I have problem with left join on two table. Version on MySQL is 3.22.25 and it started under linux. The table is: tb_a: id (int) name_sid (int) tb_b: id (int) type_id (int) value (varchar) record on tb_a is 1 and record on tb_b is 1000 When I exec that query: SELECT a.*, b.value

swinstall_HPUX10.20

Wo kann man mysql als depotsoftware mysql.full fr HPUX10.20 laden ??? Rckmeldung bitte an [EMAIL PROTECTED] Mit freundlichen Gren Adelbert Rohder

Re: HELP me!

the file error_lod said me that : 10406 10:59:50 mysqld started 010406 10:59:51 Can't start server : Bind on unix socket: Permission non accorde 010406 10:59:51 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 010406 10:59:51 Aborting 010406 10:59:51

[MySQL] MySql can support Multi-Lingual??

Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun. Would you help me for MySql? ^^: I will develop some web-sites by Japanese, Chinese, English etc. These sites will service at one server, one O/S. Many reference sites say: "Japanese site will service very well at Japanese

RE: HELP me!

Maybe you just have to change the PORT NUMBER in the configuration file. (I think in UNIX is my.cnf, I don't know because I work with Win NT) It seems like there's sombody listenning at this port I Hope this helps !!! good luck Santi -Mensaje original- De: Franois

Re: Signal to Noise Ratio...

On Thu, Apr 05, 2001 at 09:12:08PM -0400, Steve Werby wrote: "Michael Widenius" [EMAIL PROTECTED] wrote: This thing has been up a couple of times over the years. The problem is that requiring people to be subscribers to the mailing list before posting will only confuse the poor people that

Re: turning logging on/off while server is running

On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote: On Thu, 5 Apr 2001, Roel Vanhout wrote: Hi all, Is there a way to turn the query logging on and off while the database server is running? Right now I have a script that stops and restarts the database with

Re: DSN

HN How can I set a datasource name (DSN) for a database in MySQL? Get MyODBC for the platform where you want the DSN available, then enter the MySQL server database details for a "machine DSN" using your ODBC administration facilities on the platform where you want the DSN to be available.

Re: HELP me!

please : give me the solution! Just a few thoughts.. you connect via PHP.. your php.ini is not pointing to the right location mysql.sock would normally live in /tmp Normally.. other location could be.. Do a ps -ax and see if mysqld shows up.. If not, it's not running at all..

Re: turning logging on/off while server is running

Agreed - I'd love to be able to turn it on/off on demand. regards, P On Fri, 6 Apr 2001, Tim Bunce wrote: On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote: On Thu, 5 Apr 2001, Roel Vanhout wrote: Hi all, Is there a way to turn the query logging on and

Re: Mysql speed :)

On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote: for ($j = 0; $j 10; $j = $j + 1) { $dbh-do("insert into speed1 values ($j, $j, $j)"); } That would run faster if you do a prepare with placeholders outside the loop and then just use $sth-execute($j, $j, $j) inside.

UDF kills mysqld with longer strings

Description: UDF working with strings longer than (I believe) 255 bytes kills the server. Even if the initid-max_length is set to the length of the string that will be returned, as the manual suggests. Please not that in this case, no additional memory is needed -- the function just copies the

Re: Mysql speed :)

Heikki Tuuri writes: Hi! I tried a test similar to Peter. There is a table with 3 integer columns. There is a primary key on the first column and a non-unique key on the second column. I wrote a Perl program which inserts rows one at a time, and also selects rows one at a time.

Re: Mysql speed :)

Richard Ellerbrock writes: Are the Mysql supplied statically linked binaries built using these optimised glibc 2.2 libraries, or are they just the stock standard 2.1.3 libraries? -- Richard Ellerbrock [EMAIL PROTECTED] Hi! Our binaries are based on our patched glibc and not on

Re: Avoiding roundtrips

Tomas Eriksson writes: Hi. I guess we all are waiting for subselects in Mysql...but can you do many sql-commands in a single execution, with a nice finally-result-select at the end? Many roundtrips feels bad... kind regards Tomas I truly do not understand what feature are

Help on MySQL for win95

I have installed MySQL for win95 in d:\mysql on my Intel Pentium-S,24MB RAM PC. On running Winmysqladmin.exe utility I get "ACCESS VIOLATION AT ADDRESS 004026C1 IN MODULE WINMYSQLADMIN.EXE READ OF ADDRESS ." I tried fiddling with d:\w95\my.ini file and tried reducing the memory

Re: Re: Avoiding roundtrips

Thanks for your answers, Sorry for not being clearly...i mean like select into temporary/select into another temp/select the result from these in just one "sql-string". I tried separating with both ; and \n but it complains about syntax error near this. I thought that doing 5+ or something

Re: Running crash-me against remote M$ SQL Server

Vivek Khera wrote: "GC" == Gerald Clark [EMAIL PROTECTED] writes: GC Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that

Firewall logged probes on mysql port

Dear Y'all - Gary Huntress writes: I've looked around at basic security sites (sans.org, whitehats.com) This is slightly off topic but another security site I'm finding useful is http://icat.nist.gov/icat.cfm. Yours - Billy

Re: Perl - DBD:DBI Errors

You are logged in as root, are you not? Chris Becker wrote: Gerald, I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the error message: rpm -ivh zlib-1.1.3-6.rpm Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory. I'm logged in as root.

[Problems running scripts/mysql_install_db]

Description: when installing the MySQL Binary Distribution the script scripts/mysql_install_db produced the following output: scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table

Re: swinstall_HPUX10.20

On 06.04.2001 11:46:53 vblkuer wrote: Rckmeldung bitte an [EMAIL PROTECTED] Nein, hier gefragt - hier die Antwort!! Zumal so eine Antwort bestimmt auch andere interessiert - mich zum Beispiel! - Before posting, please

Re: Running crash-me against remote M$ SQL Server

Dear Y'all - Joshua Chamas writes: I believe that perl's DBD::Sybase can be used to connect to MS SQL server. I've never done it myself mind you, but heard it to be true. Vivek Khera writes: Except that perl/DBI requires an underlying C library for the DBMS in question. I

Re: [mysql] cant start mysqld process

Old Style ISAM type files are NOT archecture independent. "Thalis A. Kalfigopoulos" wrote: On Thu, 5 Apr 2001, Gerald Clark wrote: Another thought. These are isam tables, not myisam tables. Unless the two machines are the same hardware type and operating system, you can't just

Re: Duplicate of Everything in Table

Do an: alter ignore table add unique ( firstcol, nextcol, ... lastcol ) This will create a unique index on all fields, and delete the duplicates. You might want to leave this index there to avoid this problem in the future. Vigile wrote: You're right. Is there anyway around this hassle of

Re: Problem in connectivity through C++

[EMAIL PROTECTED] writes: Hello Sir , I have RedHat Linux7.0 . I install MySql-3.23.36 . By using C++ I am trying to coonect to database . I use C++ wrapper classes for the same which in build uses the Mysql++ API.I can compile and also link the programe. And when I run that

Re: MySQL error 1114: The table 'SQL7db1e_0' is full

It is in the Problems and Common Errors section of the manual. Petio Tonev wrote: Hi, I have problem with left join on two table. Version on MySQL is 3.22.25 and it started under linux. The table is: tb_a: id (int) name_sid (int) tb_b: id (int) type_id (int) value (varchar)

Re: UDF kills mysqld with longer strings

[EMAIL PROTECTED] writes: Description: UDF working with strings longer than (I believe) 255 bytes kills the server. Even if the initid-max_length is set to the length of the string that will be returned, as the manual suggests. Please not that in this case, no additional memory is

Re: Duplicate of Everything in Table

That syntax didn't work for me: SQL-query: ALTER IGNORE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text ) MySQL said: You have an error in your SQL syntax near 'Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text )' at line 1 Ryan Shrout Production Manager Athlonmb.com

Re: Duplicate of Everything in Table

Sorry: ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text ) Vigile wrote: That syntax didn't work for me: SQL-query: ALTER IGNORE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text ) MySQL said: You have an error in your SQL syntax near 'Pages ADD UNIQUE (

Re: Duplicate of Everything in Table

That gave me: SQL-query: ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text ) MySQL said: BLOB column 'PageTitle' used in key specification without a key length I guess because PageTitle and Text are [text] fields I can't do that. Ryan Shrout Production Manager

RE: Mysql speed :)

But does that really change anything on the database server side ? In other words is MySQL doing anything with respect to using prepared statements ? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 3:01 AM To: Heikki Tuuri Cc: [EMAIL PROTECTED];

Re: Duplicate of Everything in Table

Are you checking the manual and following along, or just plugging in my hints? You have to specify a length for the text fields. Your total key length must be less than 256 if I remember correctly. Choose values that are long enough to be unique. EX: ALTER IGNORE TABLE Pages ADD UNIQUE (

Visual C++

Hi, I am getting an error c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error C2146: syntax error : missing ';' before identifier '_STDAFX_H' c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error C2501: 'ifndef' : missing storage-class or type specifiers

Re: Visual C++

Nicholas, Is this anything to do with mysql ? P On Fri, 6 Apr 2001 [EMAIL PROTECTED] wrote: Hi, I am getting an error c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error C2146: syntax error : missing ';' before identifier '_STDAFX_H' c:\development\microsoft

Re: Mysql speed :)

On Fri, Apr 06, 2001 at 06:51:39AM -0700, Martin Hubert wrote: But does that really change anything on the database server side ? In other words is MySQL doing anything with respect to using prepared statements ? No. (Sadly MySQL doesn't support prepared statements. Pity.) But if you're

Re: Mysql speed :)

How do you get it not to try an quote numbers? I realize this should be obvious, but I can't find an exampl in the msql/mysql book. On Fri, 6 Apr 2001, Tim Bunce wrote: Date: Fri, 6 Apr 2001 11:00:57 +0100 From: Tim Bunce [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL

newbie problem... (error 2002)

when i try to run phpmyadmin i got an error message and the log from mysql says: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) any idéa? i'm a total newbie :o) -- D. -

configuration problem

Description: I have BSDI BSD/OS 4.0 system and i got mysql 3.23.36 source code. when i tried to run ./configure --prefix=/usr/local i got "No size for char type" How-To-Repeat: just run ./configure --prefix-/usr/local Fix: I dont know Submitter-Id: Mirian Originator:

Possible silly Question

I am quite a newbie on using MySQL so any help would be appreciated. I have managed to install MySQL smoothly (or so I thought) and the mysqld starts without any problems. However, on trying to use the mysql_setpermission script I get errors of: Cant locate DBI.pm in @inc @inc contains:

Configuration problem

System: BSDI BSD/OS 4.0 I downloaded he source code from www.mysql.com version 3.23.36, when i tried to run ./configure --prefix=/usr/local i got the error below: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static

Re: Visual C++

Hi I think this relates to mysql++. If so VC++ is not fully ANSI compliant therefore it will not compile with VC++ nor will apps that use the libs At 16:30 06/04/2001 +0100, Peter Skipworth wrote: Nicholas, Is this anything to do with mysql ? P On Fri, 6 Apr 2001 [EMAIL PROTECTED] wrote:

Re: MySQLGUI strange behavior

Hi 1, I got packages from mysql site (3.23.33). 2, The mysqlGUI is 100% statical. 3, It crashes after I try to create database and then going to admin panel. 4, I've found something that I've not seen. It end crashes with segfoult. Malmo

Re: free admin/client gui for win32

i recommend dbtools 1.0.8 for windows available for download on mysql download pages. - Original Message - From: Spirit [EMAIL PROTECTED] To: Kevin Xin Lin [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, April 06, 2001 9:01 AM Subject: Re: free admin/client gui for win32

select(count(distinct(status))

hi, I need to make a select like above in the subject count distinct (I need the count of the different values of a coloumn) Hope you guys won't let me die silly! :-) greetings from germany Micha -- A train station is a station where a train stops But what the hell is a workstation?

Re: Possible silly Question

On Fri, Apr 06, 2001 at 04:48:52PM +0100, David Thomas wrote: I am quite a newbie on using MySQL so any help would be appreciated. I have managed to install MySQL smoothly (or so I thought) and the mysqld starts without any problems. However, on trying to use the mysql_setpermission script

Warning: do not use INSERT DELAYED on Innobase tables

Hi! The MySQL manual says that INSERT DELAYED only works for MyISAM and ISAM tables, but the parser does not check that the table type is correct. We have to block this in the parser. If you use it on Innobase tables, that can cause several database corruption! Regards, Heikki Tuuri Innobase

Re: Mysql speed :)

On Fri, Apr 06, 2001 at 08:41:32AM -0700, William R. Mussatto wrote: How do you get it not to try an quote numbers? I realize this should be obvious, but I can't find an exampl in the msql/mysql book. It's magic. Or specifically it relies on Perl's internal magic. Plus, of course, it

Re: Mysql speed :)

On Fri, Apr 06, 2001 at 10:16:46AM -0400, Johnson, Gregert wrote: What would really help would be to use multiple row inserts, i.e. INSERT INTO speed1 VALUES (a,b,c),(d,e,f),(g,h,I),... So, prepare a series of inserts, each with a few hundred (or even thousand) row value sets. In

Re: newbie problem... (error 2002)

when i try to run phpmyadmin i got an error message and the log from mysql says: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) AAARG if you would have taken the time to check the archive you would have know it has to do with the location

Warning: do not use INSERT DELAYED on Innobase tables

Hi! The MySQL manual says that INSERT DELAYED only works for MyISAM and ISAM tables, but the parser does not check that the table type is correct. We have to block this in the parser. If you use it on Innobase tables, that can cause severe database corruption! Regards, Heikki Tuuri Innobase

Re: select(count(distinct(status))

It should work fine as printed...but you'll need mysql 3.23.xx On Fri, 6 Apr 2001, Temeschinko, Michael wrote: hi, I need to make a select like above in the subject count distinct (I need the count of the different values of a coloumn) Hope you guys won't let me die silly! :-)

C-API: mysql_thread_id mysql_close and non-persistent connections

I've gone through the mailing list archives on the subject of persistent connections, trying to figure out how to end the threads that mysqld creates, once I'm done. How would I set a program to have NON-persistent connections? I was planning to get the thread id, and use mysql_kill in the

RE: Perl - DBD:DBI Errors

yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 5:59 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You are logged in as root, are you not? Chris Becker wrote: Gerald, I

Re: Mysql speed :)

On Fri, 6 Apr 2001, Tim Bunce wrote: Date: Fri, 6 Apr 2001 17:25:27 +0100 From: Tim Bunce [EMAIL PROTECTED] To: "William R. Mussatto" [EMAIL PROTECTED] Cc: Tim Bunce [EMAIL PROTECTED], Heikki Tuuri [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mysql speed :)

Mysql List Web Archive ?

Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Thanks, Moin - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Duplicate of Everything in Table

You need to specify those columns that need to form a unique combination, "Thalis A. Kalfigopoulos" wrote: Actually you don't have to specify all columns in the UNIQUE index. Just one of them, and the entire row will be dropped for all redundant copies. So just do: ALTER IGNORE TABLE

Re: Running crash-me against remote M$ SQL Server

Hi, http://tlowery.hypermart.net/perl_dbi_dbd_faq.html This contains the info on how to setup the dbi proxy solution. I tried the sybase method today, but had no luck (all the test-* scripts just core, v annoying). Ive also come to the conclusion that the entire odbc thing should just

Problems with MySQL fulltext searching.

Description: The included log How-To-Repeat: Fix: Submitter-Id: Devan Goodwin Originator: Devan Goodwin Organization: National Research Council Canada MySQL support: none Synopsis: Problems with MySQL full text search Severity: serious Priority: low

Re: Duplicate of Everything in Table

Yes, but in his case there is a full duplicate of every row for every column, so just specifying one of the columns will do the job. regards, thalis On Fri, 6 Apr 2001, Gerald Clark wrote: You need to specify those columns that need to form a unique combination, "Thalis A.

Re: Mysql List Web Archive ?

lists.mysql.com It is printed at the bottom of every message posted to list. On 4/6/01 10:54 AM, "Khan, Moin" [EMAIL PROTECTED] wrote: Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Thanks, Moin

Re: Mysql List Web Archive ?

"Khan, Moin" [EMAIL PROTECTED] wrote: Please tell me the web archive of this mailing list , so i not bother you for some already answered questions. Well, you can use the URL listed at the bottom of every email sent to this list (the 2nd URL below):

Re: Does anybody know the formula to convert difference of time in decimal

"lkeeton" [EMAIL PROTECTED] wrote: I need a way in sql or simple programming to take a timpestamp(end time) and a timestamp(beginning time) for instance 12:00:00 is the end time 11:30:44 is the start time See the TIME_TO_SEC() function. The rest is straightforward. -- Steve

RE: Does anybody know the formula to convert difference of time in decimal

I like to work with times as follows: if 1 second = 1 / 86400 or 0.12 then 12 hours = 0.5 24 hours = 1.0 36 hours = 1.5 48 hours and 1 second = 2.12 and so on. Regards, Doug -Original Message- From: lkeeton [mailto:[EMAIL

Help installing Msql-Mysql-modules

Hello All - Help Help Help! I am having problems installing Msql-Mysql-modules-1.2215.tar.gz and have been struggling with this for days. Arghh! I am running Red Hat Linux 7.0, Perl 5.6.0, and MySQL 3.23.32. I read about an issue similar to mine in

Any way to pass variables into a SQL script???

I'm hoping someone can answer my question. I'm trying to pass variables into my sql script using mySQL and I can't seem to find how to do this. What I'm looking for is the mySQL eqivalent to ORACLE's myscript.sql date time where in the myscript.sql date and time are set as 1 and 2 Can

Re: Does anybody know the formula to convert difference of time in decimal

Steve Werby wrote: "lkeeton" [EMAIL PROTECTED] wrote: I need a way in sql or simple programming to take a timpestamp(end time) and a timestamp(beginning time) for instance 12:00:00 is the end time 11:30:44 is the start time set @start = curtime(); SELECT somestuff

Re: Does anybody know the formula to convert difference of time in decimal

"lkeeton" [EMAIL PROTECTED] wrote: from here is where i need a solution that gets me the difference of these two times in a decimal format. Of course once I get that I may need to convert back in english to say there are 30 minutes and 44 seconds. You didn't state whether you're using a web

Signal 11 crash when running 3.23.36 in slave mode on Tru64

Hi! I've run into a problem with a replication setup. I have a 4 CPU EV5.6 AS4100 running a master database. MySQL is 3.23.36, OS is Tru64 4.0F patchkit 4. MySQL is compiled with Compaq CC C++ with the recommended compiler options mentioned in INSTALL-SOURCE. This master database runs without

Re: Any way to pass variables into a SQL script???

Since MySQL does not have a scripting language, you will have to use something else. You could use bourne shell scripts with variable substitution for batch processes. You could write scripts in perl, PHP, or python. They all support variables and parameters. Sandy Lewis wrote: I'm hoping

Re: Warning: do not use INSERT DELAYED on Innobase tables

On Fri, Apr 06, 2001 at 07:26:14PM +0300, Heikki Tuuri wrote: Hi! The MySQL manual says that INSERT DELAYED only works for MyISAM and ISAM tables, but the parser does not check that the table type is correct. We have to block this in the parser. If you use it on Innobase tables, that can

Some more about mysql perfomance.

Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter I made one more test of mysql perfomance. Peter PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 Peter I had the followings table with 12.000.000 rows (well I checked Peter this with 1 rows as well but the

Can't run MYSQL on HPUX 10.2

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Can't run Mysql on HPUX 10.2 have CC Compiler, Debug report] Description:

performance question

I'm very new to mysql. I wonder how good is mysql, and comparing it to MS Access. I know mysql is supposed to be way faster than Access, however, to my surprise, it's not necessary the case. I have a table with 700K records. I issued these 2 queries: Access: select top 30 * from rawdata

MySQL Perl list

Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? Thanks, Kris- _ Get your FREE download of MSN Explorer at http://explorer.msn.com

Can't run MYSQL 3.23.36 on HPUX 10.2

I'm Trying to install the Binary Installation of Mysql 3.23.36 on HPUX 10.2. I receive the following error when I run the "scripts/mysql_install_db" Command. Warning: setrlimit couldn't increase number of open files to more than 60 . Warning: Changed limits: max_connections 50 table_cached:64

Re: MySQL Perl list

On Fri, Apr 06, 2001 at 03:03:40PM -0700, Kristopher Briscoe wrote: Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? Thanks, Kris- I dunno if it's _good_ or not, but it's a repository: http://www.kitebird.com/mysql-perl/

backup feature/permissions

When doing a backup of tables using BACKUP TABLE blabla TO '/tmp'; the permissions are RW for root (both user and group). But since I only have 'root' access to the mysql-server and not the machine its running on I cant really use the backup to anything. I was going to make a script that could

Re: Problems with MySQL fulltext searching.

Hi! mysql SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t; +--++--+ | a| b | x|

Re: Some more about mysql perfomance.

On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote: The reason singly queries are slower are of course that the initialization phase (reading the data from a socket, parsing, locking, checking which keys to use) is about half of the query time. Peter Heikki made tests

Logging connections and show processlist

I'm trying to write a simple windows client to monitor my MySQL server. I'm using ADO and I can connect to the server fine from a remote host and issue queries using the ADO connection object like: set rs = conn.execute ("show databases") conn.execute("use " strDBName ) set rs =

Search Query,

I posted a question regarding a search query we are trying to get to work, and was hoping someone can tell why this query doesn't work. It should return results as all the search criteria is there in the tables( for test purposes) QUERY: SELECT bi.bus_name,bi.address,bl.city,bl.state,

RE: Perl - DBD:DBI Errors

Gerald - My rpm was hosed. I downloaded from a rh ftp site and got it installed. Now back to installing zlib - see command below: /linuxrpmsrpm -ivh zlib-1.1.3-6.i386.rpm failed dependencies: /sbin/ldconfig is needed by zlib-1.1.3-6 I'm not having any luck figuring this out...

mysql-3.23.32-1.7.i386.rpm

I'm trying to set up a database system for the first time. I installed mysql-3.23.32-1.7.i386.rpm on my RedHat Linux version 7.0, but it doesn't seem to have set up correctly. Is anyone familiar with how to proceed from the point of installing this RPM to getting the server configured and

Re: Search Query

Hello All, Just to add some additional info to our problem. If I do a simple query: select * from bus_search where match(title,keywords) against('Best Car Deals') I get nothing! and its there! Is it possible the table is not set up properly?? Or I'm I wishing something here?? Table Info:

Re: MySQL Perl list

On 6 Apr 2001, at 15:03, Kristopher Briscoe wrote: Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? As you are using the DBI you should be on the DBI list: http://lists.perl.org/showlist.cgi?name=dbi-users but you might be

Double your website traffic

Do you want to double the number of visitors to your homepage everyday? The perfect solution is PopUp Window Exchange! It's a brand new concept from LinkExchange. It will pop up websites instead of traditional banners. As a result, it can bring you REAL web traffic

Enquiry

Dear Sir, This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest version MYSQL 3.23 for win95/98. But now we don't know how to install it on

Re: Enquiry

In a message dated 07/04/2001 05:13:18 GMT Daylight Time, [EMAIL PROTECTED] writes: This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest

Re: Foreign Keys

On Thu, 5 Apr 2001, Dennis Gearon wrote: Date: Thu, 05 Apr 2001 14:24:25 -0700 From: Dennis Gearon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Foreign Keys Are people using Mysql using foreign keys and how are they using them? It seems that the way to use them is with the scripting

Re: Duplicate of Everything in Table

On Fri, 6 Apr 2001, Vigile wrote: Date: Fri, 6 Apr 2001 01:26:05 -0400 From: Vigile [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Duplicate of Everything in Table I have a table, that DOES NOT have a primary key, but is setup like this: Field Type Attributes Null Default Extra

Re: rpm with php

On Fri, 6 Apr 2001, Kenneth wrote: Date: Fri, 6 Apr 2001 10:22:29 +0800 From: Kenneth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: rpm with php Hello All, I'm trying to install MySQL RPM with php. Should I use: --with-mysql or --with-mysql=/usr/bin or

  1   2   >