precompiled queries

Hello, MySQL does not use precompiled queries so that it has to parse the text of the query at each request. Do you know why this choice has been done ? and if it is planned to add this fonctionnality to the API and if not, why ? -- Loïc mel : [EMAIL PROTECTED] toile :

Access is denied

Hello, I installed Mysql on NT workstation. The installation finished successfully. I launched the winmysqladmin.exe file and define a user for my DB. When I tried to connect to this DB with the user I have just defined I got an error : Access denied for user : 'usr@localhost' using password

Re: Access is denied

you probably forgot to do any one of the things described in the manual which are required for permissions changes to take effect - Original Message - From: Meital Issers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 6:04 PM Subject: Access is denied Hello, I

How connect MsAccess to MySQL

Hi! I used ODBC driver to connect to MySQL server from MsAccess. Is there another method how I can get data from MySQL and show it's in MsAccess forms? Thanks for any response! Andis

Re: Root account cannot access Mysql

On Wed, Jun 13, 2001 at 04:56:23PM -0400, RIDLEY, JAMES A. (AIT) wrote: Hi, I somehow locked out the root account from MySQL. How can I get access back as root on the Unix system? Try this : /path/to/mysql-directory/libexec/mysqld --skip-grant-tables In a second term, just run mysql -p -

Re: load-balancing with NFS

On Wed, Jun 13, 2001 at 08:55:50PM +0200, Sven Huster wrote: Hi Hi, As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html Thanks, I'll skip the plan. No

how do I do this

Hi, I have two table: mysql select * from hotel limit 10 - ; +++ | id | hotelname | +++ | 1 | Adams Beach| | 2 | Aegean Village | | 3 | Angela | | 4 | App. in Ayja | | 5 | Apt Alfaga | | 6

Re: mysql and MyODBC

Hi Benjamin, On Wed, 13 Jun 2001, Benjamin Pflugmann wrote: Sounds as if you have to install a newer MySQL package. Use Seems like. Which is the stable version now? rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0 The result mysql-3.23.22-6 Or compile it yourself. ;-) That is my last

lotus smart suit and myodbc

Hi All, I'm new at your list and I need your help. On my linux-server (suse7.1) runs mysql. I want to work from a win2000-client with lotus-aproach on my linux-database. I've installed myodbc and it works with ms-access but not with lotus. I hope somebody can tell me how I have to configure

tuning user's variable understanding

hi ppl! I have two consequent queries select @g1=user from user_space where connects10 and select connect_time from connects where user=@g1 To prevent misunderstanding I say that I don't want to use joining as in my case tis very slow operation. My question is: when I proceed these two

Re: Getting MySQL-3.23.35/up working on my box.

SDiZ Cheng writes: I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the

Help: Replication between 2 tables

Hello, I am trying to set up mysql replication between 4 machines each with version 3.23.38 installed. My problem is that the master database has a table called metadata and the slaves have the same table but called METADATA. Is there a replicate-rewrite-table option, or do I need to trap the

mysql compilation problem

hi, had some problems while installing mysql-3.23.38 unzip and tar already did the following: 1) ./configure --prefix=/usr/home/domain/mysql --with-low-memory \ --with-unix-socket-path=/usr/home/domain/mysql/mysql-domain.sock 2)unlimit 3)make everything was going fine until an error

RE: Help: Replication between 2 tables

http://www.mysql.com/doc/N/a/Name_case_sensitivity.html Rename the METADATA table on the slaves to metadata and start mysqld with -O lower_case_table_names=1. Hello, I am trying to set up mysql replication between 4 machines each with version 3.23.38 installed. My problem is that the master

Re: Multiple CPU's in Freebsd

Hi! What is the version of FreeBSD that makes this possible ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus

Re:innodb text fields

Ryan, I hope it pays to wait. If you compile MySQL/InnoDB yourself, you will get unlimited BLOB and TEXT fields within 16 days. I am writing the support for them now and I will release the source code at my website. It will also be in the next binary release of MySQL/InnoDB, unless Monty

hi

Hai, i gone thro u'r mysql documentation. but they haven't mentioned clearly. it's really big headache for users. using c language i want to connect to datadase and perform some queries(select,update,insert and delete).according to u'r documentation u said that first use

Character sets!!

I was wondering if there were any good instructions somewhere on how to make custom character sets for MySQL. Is it necessary to compile them into the database and are the values in the arrays ASCII character values or maybe Unicode? Thanks in advance! Stefán Jökull Sigurðarson - Programmer

concated comparisons stopped working properly

mysql select (1 5 3); +-+ | (1 5 3) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql select (1 5 and 5 3); ++ | (1 5 and 5 3) | ++ | 0 | ++ 1 row in set (0.00 sec)

Replication and primary key autoinc issue

Hello! I have two databases that i want to replicate: each database should contain the same information. That's why i have set a circular replication relation. All works fine, except that one of the table is filled in real-time; this table has a primary key with autoinc type. When a new record

Re: hi

Try link is with -L/path to your library -lmysqlclient You need library libmysqlclient which is currently in instaldir/lib/mysql/... --- Dvoøáèek Michal mailto:[EMAIL PROTECTED] - Before posting,

Fwd: Re: Access Database into mysql

My replies seem to never send to the mysql-list but to the ppl who sent a request only, so I am forwarding this again. Maybe it will help other ppl as well :) Nessi Date: Wed, 13 Jun 2001 11:36:41 +0100 To: Ute Hoffmann [EMAIL PROTECTED] From: Nessi [EMAIL PROTECTED] Subject: Re: Access

RE: Replication and primary key autoinc issue

Goodday This is exactly what I have had problems with, and in the manual it tells you that autoincrement fields are not supported in circular replication. I posted a MSG on this group asking for feedback from the developers but got nothing. You have to dump he autoincrement, and do it manually

help exporting to spreadsheet

I would like to use MySQL to manage my company data, but my clients want all their information sent to them in an Excel spreadsheet. Presently I use Access, and export a SELECT statement into Excel, and then make a couple changes to the Excel file (I just high-lite the updated data). I want to

Re: HAVING [cond...] problem

Have you tried: HAVING ( Avg_Xmit 28800 ) AND ( Samples = 10 ) ? Cliff Daniel wrote: I'm having some difficulting on 3.23.38, linux x86... When I write the following query the HAVING clause is only listening to the 'AND Samples = 10' and displas all Avg_Xmit regardless if it's less

Re: concated comparisons stopped working properly

nsabbi wrote: mysql select (1 5 3); +-+ | (1 5 3) | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql select (1 5 and 5 3); ++ | (1 5 and 5 3) | ++ | 0|

Re: Multiple CPU's in Freebsd

Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection

Re: Multiple CPU's in Freebsd

Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package

Re: Re: Cannot install mysql from source distribution

On Wed, Jun 13, 2001 at 06:02:52PM -, [EMAIL PROTECTED] wrote: database,sql,query,table [Hint to list maintainer: add 3.23 as a string that gets a message through - even better, collect a copy of the next 100 legitimate messages you bounce, and collect keywords from them sufficient to get

[ANNOUNCE] MM.MySQL JDBC Driver Version 2.0.5 Released

CHANGELOG: - Fixed ResultSet.getBlob() ArrayIndex out-of-bounds - Fixed ResultSetMetaData.getColumnTypeName for TEXT/BLOB - Fixed ArrayIndexOutOfBounds when sending large BLOB queries (Max size packet was not being set) - Added ISOLATION level support to Connection.setIsolationLevel() - Fixed

MySQL 4

Hi. Our clients are asking for AND searches in fulltext fields. The manual says it's already implemented in the 4.0 tree. Can anyone tell me when we will see a public version of MySQL featuring AND searches in fulltext fields? =

mySQL client

Hi, I'm looking to get a mySQL client on a PPC LynxOS board talking to a MySQL Server on PPC Linux. The server is up and running, but I now need to get the LynxOS client, and am cross compiling from Solaris to Lynx with the Lynuxworks toolkit v3.1 and unfortunately not getting very far. So

Re: Multiple CPU's in Freebsd

---Reply to mail from Sinisa Milivojevic about Multiple CPU's in Freebsd Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should

MySQL Crashing

I use MySQL with PHP on a BSD server. For the last week or so I've been getting errors. My problem is that I'm not sure how to read the error code: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) in

indexing = NP complete??

Just kidding! But it seems that way... Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon 1.33Ghz w/512MB. Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still hasn't finished. Obviously this isn't a linearly scaling operation, but it is seeming dang

: log event entry exceeded max_allowed_packet

Hello, I'm trying to set up replication, but I cant get any further than this message on the slave. Error reading packet from server: log event entry exceeded max_allowed_packet My max allowed packet size is 512M which I've gradually reached while trying to stop the above error message.

Crazy Query

Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal Reports running reports on another machine. Everytime the report is ran and CR grabs it's data through the query listed below, it ties up mySQL (top reports processor % used is 90%+) and never seems to end. We've

Re: Getting MySQL-3.23.35/up working on my box.

I am using the MySQL offical binary. It's okay now.. Just curious.. what distro and gcc/glibc version MySQL team use to compile their linux binary? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3

RE: Crazy Query

What happens when you run this with the OPTIMIZE command? Simon -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: 14 June 2001 17:03 To: Mysql (E-mail) Subject: Crazy Query Hi: We have a set-up that consists of mySQL running on Linux (rh6.2) with Crystal

RE: Crazy Query

Yes. I actually forgot to specify that. We thought maybe the ODBC/CR was causing some overhead problems. So we did go straight to the monitor. But we got the same problem. -Original Message- From: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:12 PM To:

Re: indexing = NP complete??

On Thu, Jun 14, 2001 at 11:31:32AM -0400, Robin Senior wrote: Just kidding! But it seems that way... Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon 1.33Ghz w/512MB. Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still hasn't finished.

problem using mysql_fetch_row in C API

hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row. (which is ok) but i cant seem to convert them into int, using something like temp

RE: concated comparisons stopped working properly

And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1. ( 1 5 3 ) should then return 1. Or am I missing something? I think probably becuse ( 5 3 ) returns 0. Depends how you read it, either as 1 is less than 5 and less than 3 or 1 is less than 5 and 5 is

Re: threads mysql

On Thu, Jun 14, 2001 at 08:16:01AM +0100, Dvoøáèek Michal wrote: Hi there, little problem. I have program (like phorums) and there is command mark all posts as readed. On one board is about 4000 posts, and if is new user and want mark all posts as readed - it's problem (big). All is

RE: Crazy Query

And there are about 27000 records in agency_location...thouh I hope the number of records isn't the problem. Thanks for the suggestions. I am doing them now. Thanks! Jeremy -Original Message- From: Hise, Jeremy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 12:13 PM To:

mysql-relationships

Hey all, This is actually more of a theory question than anything else. I have most of my databases built to 4th normal form. So that means I am have tons of foreign keys to primary keys and what-not. Almost every table is linked to another table. The only problem I can forsee is when you

Install help for x86 Solaris 8

Hi, I hope someone out there has an answer to this problem I'm having. I'm trying to get mysql installed on a x86 Solaris 8 box, the version I'm trying to install is 3.23.39. The configure script goes through fine, when then try to make it dies out giving me this SNIP E_RWLOCK_T -c

Re: indexing = NP complete??

On Thu, 14 Jun 2001, Jeremy Zawodny wrote: I have a few comments and questions: (1) Is this a unique index? If not, consider doing a partial index on the column. Index the first 32 characters or so. I'll save a lot of disk I/O, memory, and CPU time but still yeild pretty

Mysql SELECT command

Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: concated comparisons stopped working properly

Mysql version 8.0, distrib 3.22.32 select (1 5 3) = 1 select ((15) 3) = 1 select (1 (5 3)) = 0 In this version, apparently left to right. Regards, Rich At 05:16 PM 6/14/01 +0100, Jon Haworth wrote: And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1.

create table ... select bug

Description: create table ... with a select statement at the end seems to think there are duplicate entries: How-To-Repeat: mysql create table nr_current (id int unsigned not null primary key) TYPE=HEAP select distinct protein_id from nr where current = 1; ERROR 1062: Duplicate entry '0'

Re: Daemon crashing (I'm going nuts here)

The only thing I could suggest is that the version of MYSQL you have is not compatible with something else that is running, like PHP perhaps, or even the version of Linux/Kernel/C-libraries. You are experiencing very strange problems, and these types of things are typically caused by

creating/dropping index - plz help

Hi, I have a database with 14 million rows which contains 3 indexes. I am trying to drop two of these indexes and create another one. However each operation takes about 12 hours. Is there anyway I can make this a lot faster by changing runtime variables and similar things. Thanks in

mysql relationship linking.....

Hey all, This is actually more of a theory question than anything else. I have most of my databases built to 4th normal form. So that means I am have tons of foreign keys to primary keys and what-not. Almost every table is linked to another table. The only problem I can forsee is when you decide

mysqlcheck

I can't use mysqlcheck -m -A and mysqlcheck -e -A It returns with a syntax error.. But i can run mysqlcheck -A with no error. It that a known problem? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3

Re: Install help for x86 Solaris 8

Daniel Vignes wrote: Hi, I hope someone out there has an answer to this problem I'm having. I'm trying to get mysql installed on a x86 Solaris 8 box, the version I'm trying to install is 3.23.39. The configure script goes through fine, when then try to make it dies out giving me this

Re: Mysql SELECT command

On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali [EMAIL PROTECTED] wrote: Well as they say, ...if all else fails, RTFM.. :) Or pick up Paul Dubois's book on MySQL. Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks,

Re: Getting MySQL-3.23.35/up working on my box.

On Thursday 14 June 2001 08:19, SDiZ Cheng wrote: Thanks all.. It's up and running now.. Seems that is a bug in Debian's CVS version gcc. I can't get older version of kernel compile on it too. I will move this to debian's mailing list =) Trying to run MySQL 3.23.35 is trouble (that is why

Re: Getting MySQL-3.23.35/up working on my box.

I have just checked bugs.debian.org . Debian Bug report logs - #81181 gcc: sig 11, reproducible and not machine-specific Somebody have file the same problem, with imapd. not mysql's bug =) -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6

Bugs? Re: HAVING [cond...] problem

Still doesn't work, I've even tried: HAVING ( Avg_Xmit = 12345 ) AND ( Samples = 25 ) 19000 rows returned, none equalling 12345, but all have Samples = 25. It's almost as if this became an OR. Cliff Gerald Clark [EMAIL PROTECTED] writes: Have you tried: HAVING ( Avg_Xmit

RE: mysql-relationships

If I understand you correctly, you probably want to look into left joins. I.e. select a.field, b.field from table1 a left join table2 b on a.id=b.tbl1.id vs select a.field, b.field from table1a, table2 b where a.id=b.tbl1.id The first will show matching rows from table1 even

Re: apache/php/modperl incomp?

I believe that i've seen this on the list before. Read the php docs before compiling, don't use the builtin mysql support, specify --with-mysql=/path/to/mysqllibs HTH Greg wrote: I'm trying to have mod_perl and php running in the same apache server, accessing the same mysql database. At

now I have it compiled, ??

Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ./configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql But after the make install ( and I saw no errors ) there is no

Re: Telnet to MySQL (Was port number)

I was indeed trying to test a remote connection to mysql server. I am actually trying to get JDBC working from a client that does not have MySQL installed, and was just trying to use telnet to see if the connection worked. I have discovered that I must install a JDBC driver of some kind on the

RE: Mysql SELECT command

On the internet specifically I'd say try http://www.mysql.com/manual.php , it's one of the better manuals I've come across (Free Software or Commercial). If you want an excellent book, get MySQL by Paul DuBois. Also 'The Practical SQL Handbook' is good, although not MySQL specific. Best of

Re: Making SQL request from a Mac

I see you're mailing the ODBC lists as well, that may very well be your answer. Mind you I'm not familiar with Mac Programming, however, why not open a odbc connnection to your DB. You can do it with MS Access on windows easy enough, why not on a Mac? Matt Trollboy Wiseman

RE: tuning user's variable understanding

On 14-Jun-01 brainheap wrote: hi ppl! I have two consequent queries select @g1=user from user_space where connects10 and select connect_time from connects where user=@g1 What if there are more than 1 user(s) where connects 10, or none ? To prevent misunderstanding I say that I

Re: now I have it compiled, ??

Complete tutorial on installing Mysql, PHP and Apache can be found on www.devshed.com Have fun. B. At 11:12 14-6-01 -0700, Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ./configure

won't build on hppa

Hello Does anybody know how to get MySQL build on HPPA architecture? bye, -christian- -- Real men don't take backups. They put their source on a public FTP-server and let the world mirror it. -- Linus Torvalds Package: mysql Version: 3.23.39-1

RE: problem using mysql_fetch_row in C API

On 14-Jun-01 Kenneth Johansen wrote: hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row. (which is ok) but i cant seem to

Re: Error 127?

Hello and thanks, can you tell me where can I get information about the errors presented by MySQL? I have that kind of trouble each time the server (the machine) crash and it's no solved after myisamchk with any option. thanks again, Cesar A. Cabrera E.

Re: now I have it compiled, ??

You forgot the mysql_install_db --user=mysql Mark Vann wrote: Hey gang, I got the configure script to run with no errors and got it installed in the /opt directory by using the following. ../configure --with-named-z-libs=no --without-debug --with-mysqld-user=mysql --prefix=/opt/mysql

Borland C++ Builder (reading data).

Caveat: I'm not a seasoned Borland C++ builder programmer so this may very well be just plain stupidity on my part (I'm not even a really good C programmer either !). However, givem some code that looks similar to this: int state; MYSQL_RES *result; MYSQL_ROW row; char sql[250];

Re: MySQL Crashing

Is something run from cron deleting the socket? The second error is just because your PHP script did not check for the first error. David Addison wrote: I use MySQL with PHP on a BSD server. For the last week or so I've been getting errors. My problem is that I'm not sure how to read the

Re: GRANT ANNOYANCE REVISITED

Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql GRANT ALL PRIVILEGES ON *.* TO monty@% -IDENTIFIED BY 'some_pass' WITH GRANT OPTION; ERROR 1047: Unknown

Re: now I have it compiled, ??

Well, I dont know why, when I do that , it tries to look in /usr/local/mysql, so i just put a symbolic link there and everything seems to be OK. Thanks all --- Gerald Clark [EMAIL PROTECTED] wrote: You forgot the mysql_install_db --user=mysql Mark Vann wrote: Hey gang, I got the

Re: problem using mysql_fetch_row in C API

From: Don Read [EMAIL PROTECTED] On 14-Jun-01 Kenneth Johansen wrote: hi all, ive got a small problem (again). i have a table with an entry foo which is an int(3). my problem is that whenever i collect the values in my c program. they are returned as characters with mysql_fetch_row.

Re: help exporting to spreadsheet

On 14-Jun-01 Terminal Velocity wrote: I would like to use MySQL to manage my company data, but my clients want all their information sent to them in an Excel spreadsheet. Presently I use Access, and export a SELECT statement into Excel, and then make a couple changes to the Excel file (I

Error 22 from table handler

Hello, can you tell me about error 22 from table handler or where can I get some information about it, it denies me grant table level privileges for my users. Thanks, Cesar A. Cabrera E. -

RE: help exporting to spreadsheet

Perl's Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are great for this purpose. Find them on a CPAN site near you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] m] On Behalf Of Don Read Sent: Thursday, June 14, 2001 3:43 PM To: Terminal Velocity Cc:

Re: innodb text fields

From: ryc [EMAIL PROTECTED] I am aware that currently innobase tables can not have abritararly large text/varchar fields and support for this will be released sometime in the month of June. The application I am working with requires text fields (usually less than 64k), and I desperatly need

Error 22 from table handler

Hello, can you tell me about error 22 from table handler or where can I get some information about it, it denies me grant table level privileges for my users. Thanks, Cesar A. Cabrera E. -

include files

I installed MYSQL in Redhat Linux 6.2 and where are the include files? If your include files are not in /usr/include/mysql or /usr/local/include/mysql, I cannot find the include files and I installed from RPM MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm Thanks MIke

auto_increment update

Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. thanks

Where is mysqladmin

Hi, I have mySQL installed under Conectiva Linux 4.2 and I'm not able to find mysqladmin ... Is there something to start to use mySQL? TIA, Juan - Before posting, please check: http://www.mysql.com/manual.php (the

Re: threads mysql

From: Dvoøáèek Michal [EMAIL PROTECTED] Hi there, little problem. I have program (like phorums) and there is command mark all posts as readed. On one board is about 4000 posts, and if is new user and want mark all posts as readed - it's problem (big). All is written in ANSI C (using C API

Re: Install help for x86 Solaris 8

On 14-Jun-01, Daniel Vignes said something totally profound about Install help for x86 Solaris 8 that made me ponder... DV Hi, DV DV I hope someone out there has an answer to this problem I'm having. DV I'm trying to get mysql installed on a x86 Solaris 8 box, the DV version I'm trying to

Re: auto_increment update

At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other

Re: include files

At 3:33 PM -0700 6/14/01, Mike Jimenez wrote: I installed MYSQL in Redhat Linux 6.2 and where are the include files? If your include files are not in /usr/include/mysql or /usr/local/include/mysql, I cannot find the include files and I installed from RPM MySQL-3.23.38-1.i386.rpm

MySQL server has gone away

Description: In testing a script that I want to put in a cron, the mysqld keeps crashing eachtime I run the script to test it. I've tried substituting in raw numbers for the variables in the script, but to no avail. In attempting to troubleshoot, I logged onto the monitor and could

Re: Relationships???

If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? Hello all, Without

Relationships???

Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise

Re: error checking in MySQL

At 12:04 PM +1000 6/15/01, M Felipe wrote: I need help on testing the database for errors. Basically im writing a perl script to operate my database. When i open the database, i need it to return an error code if successful. steps such as: Try running: perldoc DBI and reading the

Re: What's wrong here?

It would help if we knew what the error or problem was? - Original Message - From: Vladimir Kravtsov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 13:13 Subject: What's wrong here? ?php require('common.php'); function DisplayPoll() { connectdb();

error checking in MySQL

I need help on testing the database for errors. Basically im writing a perl script to operate my database. When i open the database, i need it to return an error code if successful. steps such as: open database check for error (did database open?) if error print error message else print

Fork, Or SetEnv Problem: Retain a MySQL Record # in a Shell

Greetings: Working ona shell based application that does an insert when a shell is started, and, needs to update that record on exit. You can't set an environment value back to the parent process, so would a fork() make the most sense? This currently works in a bash shell .profile

What's wrong here?

?php require('common.php'); function DisplayPoll() { connectdb(); mysql_select_db(pollbooth); $sql = select choice from choices; $query = mysql_query($sql); $num_of_voting_choices = mysql_num_rows($query); $sql = select choice from votes; $query = mysql_query($sql);

Re: indexing = NP complete??

On Thu, Jun 14, 2001 at 12:43:41PM -0400, Robin Senior wrote: On Thu, 14 Jun 2001, Jeremy Zawodny wrote: I have a few comments and questions: (1) Is this a unique index? If not, consider doing a partial index on the column. Index the first 32 characters or so. I'll save a

Re: What's wrong here?

Well, that isn't much to go on. I suggest you put a few print statements to find out what's happening and also try the sql statement in the mysql prompt to see if the sql statement does what it is suppose to. Remember, if you're printing this in a table, error messages and results may not

Re: MySQL 3.23.39 released

Changes in release 3.23.39 -- * Fixed problem with shutdown when `INSERT DELAYED' was waiting for a `LOCK TABLE'. * Running `myisamchk --fast --force' will no longer repair tables that only had the open count wrong. -- THANK YOU!

  1   2   >