RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for

Re: MySQL or MS SQL?

Hi, the question is what operating system you are going to use. If your DB gets to large you will have problems not with tha database but with the filesystem. Best Regards Bernhard - Original Message - From: "Alexander Chernienko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wedn

Re: Transaction for MySQL

Hi everyone, Would someone help me out with these questions? I know these may be something obvious/ in the manual .. etc but I would like to have someone showing me if I am on the right track and maybe share some of these in greater detail. Greatly appreciated. Regards, Michael -

RE: mysql.org

First, I support mySQL and Open Source community. Maybe you can fight them with their own weapon. They have made some extra applications based on mySQL, and they sell it. You can create same applications as Open Source. - Befor

Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem

Thanks Ken ! - Original Message - From: "Ken Sommers" <[EMAIL PROTECTED]> To: "Sunento Wu" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 1:45 PM Subject: Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem > Better read the m

Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

-- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA <___/

Errors on log files

Hi All, Not sure if the last email got through to the list! But On our log files we are get alot of Error number zero's does anyone have any idea what this means? We are running a system that Uses MySQL 3.23.39 and PHP 4.0.5. Any input would be appreciated thanks in advance. Drew And

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, w

Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem

Better read the manual: http://www.innodb.com/ibman.html#InnoDB_start Enjoy, Ken - Original Message - From: "Sunento Wu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:34 PM Subject: Can't initialize InnoDB as 'innodb_data_file_path'

Re: Solaris +SMP + mysql problem

Hello, I have thread_concurrency=4 already in my.cnf, but mysqld don't want to use more than 50% of CPU resources. (Solaris8 x86 MU3 on Dual PIII Xeon with 1GB RAM) Alexander > On Wednesday 18 July 2001 07:41, Alexander Belyaev wrote: > > Hello, > > I have a similar results on my Solaris8 x86 +

mysql + ssl.

can mysql support ssl connection? luwim+ (axishift.ath.cx) PGPID : 0xDABA60C7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Info needed!

Hi Asha Yes, you are correct. Please refer to the following link for more details: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W Thank you Venu Anuganti -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/

Can't initialize InnoDB as 'innodb_data_file_path' Problem

Hi, I am still new in mysql. I just install mysql to my win 98. When I try to run the server, mysqld, I got this error : === C:\mysql\bin>mysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set === Have some one experi

Info needed!

I need to run a query from a java program to : 1) get the list of tables in a particular db] 2) get the desc of each table in the list I get Can I use the show tables; and desc tablename as a query to get the desired RESULTSET in java(sql package) ?? Plz do respond at hte earliest! Thanks and re

Re: Multiple statements via ODBC

Hi Jon MySQL/MyODBC doesn't support nested SELECT statements. Please check the following links, whether that helps you. http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html #Missing_functions http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79974:200107:dkdliiiacininpiok lg

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

Hi Luc Here is the common syntax, that is used as the connection string through JDBC-ODBC Driver. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:TestDSN"; Coonection con = DriverManager.getConnection(url,"username","password"); Before connecting, make sure you intslled t

Error 127

I have determined that error 127 is 'index has crashed', but I have no idea if this is recoverable. I have a table with just under 7000 rows, and I am getting this error when I try to count the records and set up the variables to page through the records n at a time. Is there any practical limit t

Re: MySQL: Multiple INSERTS syntax ...

- Original Message - From: "Philippe L. Houze" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 8:09 AM Subject: MySQL: Multiple INSERTS syntax ... > When running: INSERT INTO customers3 (firstname) select TRIM(trailing > char(10) FROM firstname) FROM customers

stability of freebsd 4.3, gcc 2.95.3

Hi there I posed a question a couple of days ago about segfaults occurring in mysql_free_result(), but have received no response, possibly because my question was too vague. I'd like to try again, and express the problem differently. Has anyone had unfavourable experiences with FreeBSD 4.3-STABL

RE: jdbc connectivity

i have the same problem too. because the java program worked with mysql server residing on a win2000 os, i came to the conclusion that my problem was not with the java program but with the mysql server setup on linux. Do we need myodbc + jdbc? i ask this question because i only installed jdbc. re

Re: unsuported function

Try a PHP mailing list, This is off topic. axel yson wrote: > > Fatal error: Call to unsupported or undefined function mysql() in >/usr/local/share/apache/htdocs/test.php3 on line 13 - Before posting, please check: http:

Re: unsuported function

"axel yson" <[EMAIL PROTECTED]> wrote: > Fatal error: Call to unsupported or undefined function > mysql() in /usr/local/share/apache/htdocs/test.php3 > on line 13 This is a PHP error, not a MySQL error. PHP does not have an internal function mysql() so unless you defined a function called mysql(

Multiple statements via ODBC

I'm having problems getting multiple statements that need to be executed as one thread (for user variables) through via the ODBC interface (Syntax Error near ";SELECT" on line 1) . This works directly from mysql but not through other tools (they don't seem to accept the `;' to end one statement as

Re: SQL question (set operator)

"Marie-Christine Fauvet" <[EMAIL PROTECTED]> wrote: > I'd like to program in the SQL language supported by MySQL the following > query: > > select R.A, R.B from R > minus > select S.A, S.B from S > > It doesn't work (syntax error, set operators are not supported). > So, I've tried: > > select

unsuported function

Fatal error: Call to unsupported or undefined function mysql() in /usr/local/share/apache/htdocs/test.php3 on line 13

MySQL Timing out

I have an include file that includes my mysql connect information. Its sole purpose is to login to mysql. Strangely on my Win9x development system with apache, sometimes, almost randomly, the connection will time out. Then if I press refresh it works prefectly. I am only connecting once per pag

SQL question (set operator)

Hi, I'd like to program in the SQL language supported by MySQL the following query: select R.A, R.B from R minus select S.A, S.B from S It doesn't work (syntax error, set operators are not supported). So, I've tried: select R.A, R.B from R where not exists (select * from S

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

the method signature for getConnection is: public static synchronized Connection getConnection(String url, String user, String password) throws SQLException try PURE JSP Java Server Pages by James Goodwill from Sams. a nice book. has some coding errors. At 04:02 PM 7/18/01 -0600, you wrote:

Re: MySQL question

Have a look at what the error logs say. If that doesn't help, post the command used and error messages/logs (if relevant) to the list. - Original Message - From: "MIKE TURNER" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 2:05 Subject: MySQL question

Re: Problem compiling with GCC 3.0

due to some problem with the mailer, some unknown multibyte characters got included in my previous message. Here's the configuration line again : CC=gcc CFLAGS="-O1" CXX=gcc CXXFLAGS="-O1 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --with-low-memory --wit

Problem compiling with GCC 3.0

Would appreciate any help / tips regarding the following problem : Trying to compile mysql-3.23.39 with GCC 3.0 ( on Solaris 8 ) and the following configuration options : CC=gcc CFLAGS="-O1" CXX=gcc CXXFLAGS="-O1 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --pref

Re: Network connection

How about using Ora_Logon to connect to an oracle db? It is the prescibed procedure. mysql_pconnect ist used to connect to mysql dbs. > $db = mysql_pconnect ("anothermachine:oracleport", "user", "passwd") or > die .. > I need to connect to an oracle DB - can I? Or do I have to run a ?cgi? >

Re: Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

> (begins: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1029.html ) By chance, this points me to an archive of this list. I already looked for a hint at the trailer and on the website, but, as I didn't find any, assumed that there wasn't any. Wouldn't it be helpful to add links at bot

Solution (but only a temporary one) Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

After the latest post, curiosity got the better of me (which is always good in a debug situation). I tried to change all 6 fields that compose the FULLTEXT index, so that they accept NULL values. The result? The error is gone. Is this a valid solution however? I've never been a great fan of the

Re: FreeBSD issues

Ken, Thank you for your very helpful notes. We took your advice and updated to FreeBSD 4.3 and the last version of MYSQL. We are still experiencing problems with MYSQL, though. We installed it fresh, with no freeBSD tweaks. I was not able to locate the email you referred to regarding FreeBSD

query.preview() stored in an edit box

Hi, I recently downloaded mysql++ and the tutorial that came with it. Unfortunately they used "cout" in the examples... they used the following code cout>>query.preview(); and that worked great but... How do I get the result back as a string which I can store in a CString or char variable?? Th

using mysql to build a delphi program

well well, as seen i brought the delphi and mysql power to built an application wich i am installing myself in the client nowadays although i'd like to make a more friendly installation pack in wich the client does not need to install the mysql and afther that install the program, i am using the i

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

Finally I was able to produce a complete step-by-step to corrupt the index ;-) Do the following in the mySQL console (with e.g. a fresh and empty table): mysql> insert into visitkort (kategori_id) values (108); Query OK, 1 row affected (0.01 sec) mysql> select last_insert_id(); +--

select field(3)

Hello all, I haven't been using MySQL very long. I'm more in the 'playing with it' stage, trying to learn all the in's and out's. So, here is my current dilemma: I want to be able to reference (select) a field/column by it's position in the table rather than by the field's name. Is there a wa

RE: MySQL loves FreeBSD (but not NetBSD) ...

Ken, I have absolutely no complaints at all about the support I got on this mailing list from the MySQL team -- they were very helpful, and provided many good suggestions. Unfortunately none of them worked, but such is life. I am happy that MySQL is stable on FreeBSD -- I was ready to go all th

RE: FreeBSD issues

Ken, Thank you for your very helpful notes. We took your advice and updated to FreeBSD 4.3 and the last version of MYSQL. We are still experiencing problems with MYSQL, though. We installed it fresh, with no freeBSD tweaks. I was not able to locate the email you referred to regarding FreeBSD

how to give database connection to oracle and mysql

My application is to give database connection to oracle which is in sun solaris machine and to mysql which is in windowsNT machine. How to write a java program to establish connection. please help me.

Buffering SELECT results without using temporary tables; "Locked tables while 'Sending data'" revisited

We are currently working with a table containing ~650MB of data in 700,000 rows. In attempting to select from this, we would typically find long holdups with process states listed as creating temporary tables. By using SQL_SMALL_RESULT we were able to greatly reduce the time taken for select oper

RE: MySQL or MS SQL?

Hi, Agreed Just because software is developed on a 'Free' platform, doesn't mean that the customer expects the application to be free, or even cheap. Our experience is that if you give something away, then people expect the support/upgrades/customisations to be free to. If you charge, even a no

MySQL: Multiple INSERTS syntax ...

Hi, I found syntax for INSERT command in both Paul DuBois excellent book and online manual but for single insert. And it works... which for a newbie like me is thrilling. But, I am stuck for multiple inserts. I am trying to remove from a database trailing characters (ascii 10) that have shown up

java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the pro

Problem with keys in MyISAM tables

The MySQL documentation says that one can have 32 keys/table for MyISAM table and that this can be extended to 64 keys/table without recompiling myisamcheck. I could not find any info on how to extend this limit. Could anyone help me about it? -- Marek Wójcik [EMAIL PROTECTED]

Re: using InnoDB ==> transactions (rollback) don't work

George, the default in MySQL is set autocommit = 1; To be able to do rollbacks you have to execute set autocommit = 0; Then you can do insert into ...; rollback; I assume you specified in CREATE TABLE ... (...) TYPE=INNODB? Regards, Heikki Copied message: . Hello everybody

Network connection

Haven't been able to find this in the docs. $db = mysql_pconnect ("anothermachine:oracleport", "user", "passwd") or die .. I need to connect to an oracle DB - can I? Or do I have to run a ?cgi? style script / program to get there? Tks Chuck L. ---

Re: innodb on nt4

Hi! I tested what happens if you already have a data file but in my.cnf you have not specified the file size. Then InnoDB just exits because there is a syntax error in innodb_data_file_path You should delete all your data and log files, write your my.cnf or my.ini so that you specify also the d

Re: MySQL or MS SQL?

I like MySQL, and I'm fairly new at it, but if I were to need to store and retrieve tens of Gb's, I would want an IBM AS/400. Base configurations are quite reliable, and you can easily add RAID and other types of redundant support, up to and including redundant machines. I work with numerous

Transaction for MySQL

Hi all, I am new using MySQL. I found out that the default table type used in the binary isn't support transaction and would like to make MySQL uses another table type which supports transaction. The following are my questions regarding the issue: 1) which one should I use InnoDB or BDB?

Re: MySQL loves FreeBSD (but not NetBSD) ...

On Tue, Jul 17, 2001 at 10:05:24PM -0400, Haapanen, Tom wrote: > ... or should that be "FreeBSD loves MySQL"? > > I finally caved in after a year of increasing (and unexplained) MySQL > crashes, despite numerous updates to more recent versions of NetBSD and > MySQL, and dozens of experiments with

replication issue with FreeBSD 4.2-RELEASE

I'm exploring mysql replication under FreeBSD 4.2-RELEASE. Two machines, named 'master' and 'slave', each running FreeBSD 4.2-RELEASE and MySQL 3.23.36-debug. I've followed the instructions at All very straight forward. When I spin every

Inserts Broken after database move

I am using 3.22.32. The directrory where the databases lived was nearly full. Following the instructions in the manual, I stopped mysqld, I tar'd up the db's, moved them to the new location, created symlinks in the original location, restarted mysql (using safe_mysql). I now have the problem that

Replication Offset off by 22 bug fixed

Hello, everyone: Good news - I was able to repeat and fix the bug that several people have reported but were not able to repeat. No wonder - even after I noticed the problem in the source, it took some creative work to be able to write a test case for it. ( We try to write a test case for ever

Re: PLEASE help me!! MySQL Linux Problem

Read the man page for gcc and note the command line switch to point the linker at specific libraries, then use those switches on the command line. This is a linker error, rather than a compiler error: Example: g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient On Wednesday 18 July 2001 1

Re: innodb on nt4

I did, see below from my prev email, that part works fine: innodb_data_home_dir=c:/mysql innodb_data_file_path=ibdata1 like I said, the system created a 10mb file called ibdata1 in c:\mysql But to recap, when I try to add the specifications for logs, it wort start, that's the next line: innodb_

Re: MySQL or MS SQL?

On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote: I think people who use proprietary software systems are just accustomed to being gouged by ridiculous software costs. Not to mention that it also costs us more to accomodate them. Basically, distorting the argument a little, you cou

PLEASE help me!! MySQL Linux Problem

I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I co

Re: innodb on nt4

Hi! You have to specify also the data file size in innodb_data_file_path. The following example is from the manual at www.innodb.com: Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' for InnoD

Re: innodb on nt4

Ok, got the following line working in my.ini, it created a 10mb ibdata file: innodb_data_home_dir=c:/mysql innodb_data_file_path=ibdata1 set-variable=innodb_mirrored_log_groups=1 but, when I add innodb_log_group_home_dir=c:/iblogs mysyl won't start. I created a iblogs directory. Any ideas? P

Restoring mysql database from backup and logging

When restoring a backup, the binlog will record all of the backup's commands (create tables and insert into's). Would it therefore be a good idea to flush the logs before a restore and then flush the logs immediately after so that the "restoration log" can be deleted (or ignored)? ---

RE: MySQL or MS SQL?

I'm sure if done right, MySQL could do whatever you want satisfactorily. Same with MS SQL (ignoring cost). However, something few people seem to know, but I've realized from experience is that when you offer people services based off free software, you get a different kind of customer. And not th

Configuration error

Help me: I am install mysql-3.23.39 on BSDI4.1 I have error on configuration: How solution this problem Atte, Cesar real Universidad Autonoma de Nicaragua Leon --- configure:3950: checking for opendir in -ldir configure:3969: gcc -o conftest -O3 -mpentiumco

RE: how to elect slave as master?

Thank you. But then how can mysql replication be used for high availability? If I always rely on 1 master only, what happens if the master goes down? I've tried two-way master-slave and I understand there are problems. :-( On Wed, 18 Jul 2001, Warren van der Merwe wrote: > Hi Ricardo > > >Fr

RE: how to elect slave as master?

Hi Ricardo >From my opinion, and yet again the pro's may dispute it, I understand what you actually want is a two way slave situation, in that way, when one goes down the second is there to take over, and when server1 comes back up if will update itself's from server2 and carry on. The rest of (f

Re: mysql.org

It seems to me that the bottom line is that any outcome that results in there being a fork in the development of MySQL (with the result being two completely different types of MySQL), or in NuSphere retaining control of the mysql.org domain should be vehemently rejected by the MySQL community.

MySQL question

I have just installed MySql and when I tried to set the root password and it gives me an error(I don't recall the exact text) but I looked and the daemon isn't running. I tried starting it but still nothing? Did I miss a step? Sorry if this ends up to be a stupid mistake. Hope you can help me. M

Mysqlhotcopy regexp problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Using the mysqhotcopy that came with the most recent MySQL (3.23.39) on a RedHat 7.1 box with perl 5.6.0, I am getting the following errors when trying to back up all databases: mysqlhotcopy --password="foo" --allowold --regexp=".*" /usr/backups/ \

Re: How does this work in MySQL?

On Wednesday 18 July 2001 13:32, you wrote: > I recently got into a discussion with a colleague that was interesing. He > is a database warehouse guy, so I assume he knows more than I do on this > subject, but he was unable to explain things to me very well :) > > The question is how does mysql o

Re: Faults

Werner Stuerenburg wrote: >> The main aspect I'm interested in is avoiding data loss. So I want that any >> change to database must immediatly (or at least on regular intervals) be >> made persistent. Is there any configurable parameter to do this? > > > > You may want to read about transact

Re: InnoDB logging meachanism (newbie ;)

George, the binlog is exactly you must have switched on and you must keep the binlog files. The binlog contains the SQL statements you run into your database, and by re-running it against your database backup you can recover from your backup to the present state. You need the binlogs in disaster

MySQL or MS SQL?

Hi all, I'm currently writing proposals for a customer who want to hire our little programming team for creating corporate information system, wich includes huge database with number of records between 1-10 millions (incl. blobs - pictures). Expected database size is tens of Gb. There is idea of

Re: Database Replication

Make sure it is world readable. Jeremy Zawodny wrote: > On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote: > >> We are looking to replicate a couple of databases on to a second >> server. Having looked through the manual it says we need to add >> various commands to my.cnf. >> >> It t

Re: How does this work in MySQL?

In the last episode (Jul 18), Bryan Coon said: > In this paradigm, my colleague says that there are no guarantees that > the records will be retrieved in any kind of order, and may in fact > be random. How does this work? > > He also states that auto_increment does not guarantee consistent > incr

Replication & Load InFile

Hi If you use the load infile to insert images into a blob field, and then the path does not exist when the replication takes place, will there be an error, or is it clever enough to get the blob data from the db? THanks ~ Warren van der Merwe Software Director

how to elect slave as master?

Hi everyone, I'm wondering how I should configure my.cnf if I have a master-slave scenario where I would like to declare the slave master if the master goes down. What I mean is, let's say I have 2 database servers: server1 = master server2 = slave so normally my.cnf for server2 would have se

How does this work in MySQL?

I recently got into a discussion with a colleague that was interesing. He is a database warehouse guy, so I assume he knows more than I do on this subject, but he was unable to explain things to me very well :) The question is how does mysql organize data between the physical table, the select s

Re: MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

In the last episode (Jul 18), S A said: > Is there some way to take the following 2 queries & make them into > one ? Nope. Do them separately (or do the count(*) once and cache it for the rest of the session). > I want to be able to in one query get the # of overall rows and do a > LIMITed resu

How to find the port Mysql listens to?

Hi, Guys! I have difficulties to talk to MySql via Java Servlet and Resin. Platform: We use Solaries, and Resin as Servlet container. The server I use and the server with MySql database is connected via LAN. What I have done: 1. I have put resin's mysql jdbc driver in resin/lib, and set up

Re: Converting ACCESS or EXCEL Data to MySQL

At 08:47 AM 7/18/01 -0700, Dennis Salguero wrote: >Notice that I haven't really mentioned MySQL at all. As much as I like >MySQL, if you already have a SQL Server that can connect to the Internet, I >don't understand the need to use MySQL in this scenario ??? Obviously, if >this is a web page that

RE: [PHP] Email Software

LOL!!! -Original Message- From: Dan Harrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:47 AM To: Wee Chua; PHP (E-mail); MySQL (E-mail) Subject: RE: [PHP] Email Software try http://www.spamcop.net, they are experts in it. > -Original Message- >

performances

Bonjour, Je voudrais avoir une idée sur les performances de MYSQL, du genre capacité maximale , temps de réponse. Et puis comment faire pour modifier les parametres surtout le TIMEOUT. Merci - Before posting, please check:

RE: Re[2]: AW: password-recovery for root-user?

the link got split over 2 lines when it was copied/pasted... manual_Privilege_system.html instead of manual_Privilege_system.h -ravi. -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:25 AM To: Ravi Raman Cc: [EMAIL PROTECTED]; Risch

MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

Is there some way to take the following 2 queries & make them into one ? I want to be able to in one query get the # of overall rows and do a LIMITed result set to get the first NN rows. Is it possible to to do this in one query ? Presumable MySQL has to figure out what the overall # is to re

Re: Converting ACCESS or EXCEL Data to MySQL

- Original Message - From: "Oliver Hohlfeld" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 8:13 AM Subject: Converting ACCESS or EXCEL Data to MySQL > I'm currently working on a bigger Project. Uh oh, wasn't that the plot to "The Spanish Prisoner" ?? ;-) >

ERWIN, stored procedure, release date MySql questions

I am not a subscriber to this message board, please copy replies to [EMAIL PROTECTED] Greetings, A few questions - *regarding trying to determine how to use stored procedures with Mysql, 1 approach I have heard is to put all your sql in a text file -how does this compare to just embedding the

Re[2]: AW: password-recovery for root-user?

> http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h FYI: The link you requested was not found. Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24: >>mysqld --skip-grant-tables > section 6.3 on this page: > http://www.mysql.com/documentation/mysql/bychapter/manual_Pr

BLOB storing

I'm trying to save BLOB values in a table from a little java application, but i found only null values in the table. I've configured the max_allowed_packet parameter, I've controlled the path of the file I want to save, but nothing. Anyone can help me? Thank you Damiano --

Re: Small Problem with a function

mysql support should be built into php. I experienced this twice under Winxx. The first time I found a remedy which I don't remember. The second time I upgraded to the newest version of php. > Fatal error: Call to unsupported or undefined function mysql_pconnect() > in ./db_mysql.php on line 38

RE: Small Problem with a function

You must compile PHP with the mysql module enabled. See the PHP manual for more information. (Or search the excellent php mailinglist archives at http://www.php.net/support.php) > -Original Message- > From: Rick Makla [mailto:[EMAIL PROTECTED]] > Sent: 18 July 2001 17:02 > To: [EMAIL PRO

Re: Small Problem with a function

Did you build PHP with mysql support, and are you requring the mysql/php module in your program, something is not set up correctly. On Wednesday 18 July 2001 11:01, Rick Makla wrote: > What can I do to fix this error or can you referance me to a point where > I can look at to try to fix the prob

Converting ACCESS or EXCEL Data to MySQL

Hi there, I'm currently working on a bigger Project. There is a company who want to publicate their article database daily on the internet. The database is located in a Microsoft SQL Server and they use Access as frontend. So, exporting the Data to Excel is no problem. I'm currently thinking abo

Small Problem with a function

What can I do to fix this error or can you referance me to a point where I can look at to try to fix the problem. Fatal error: Call to unsupported or undefined function mysql_pconnect() in ./db_mysql.php on line 38 Rick Makla Digital Media P: 803.758.4057 F: 803.779.9455 [EMAIL PROTECTED] ---

Re: Modifing A Table

alter table TABLENAME add COLUMN_NAME etc, etc... ie: alter table members add firstname varchar(50) not null; If you want to put it after a specific column you can do the following: alter table members add firstname varchar(50) not null after lastname; -- Jason On 7/18/01 10:32 AM, Paul C

Re: MySQL loves FreeBSD (but not NetBSD) ...

Hi Tom, As another user of MySQL on FreeBSD, I can tell you from my own experience that the MySQL Team is dedicated to having MySQL run on as many platforms as possible. I say this as an almost direct quote from e-mail Monty sent me. Things were not always smooth with FreeBSD threads, it is

Re: Modifing A Table

mysql> alter table mytable add newcolumn varchar(16); Have a look at the ALTER TABLE syntax in the manual... http://www.mysql.com/doc/A/L/ALTER_TABLE.html On Wed, 18 Jul 2001, Paul Castiglione wrote: > Hello > > Is there a way to add addition feilds to a table after it been created. > >

Modifing A Table

Hello Is there a way to add addition feilds to a table after it been created. Thank in Advance Paul

RE: AW: password-recovery for root-user?

>mysqld --skip-grant-tables section 6.3 on this page: http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h tml -ravi. -Original Message- From: Andy Tanner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 10:03 AM To: Werner Stuerenburg; Rischbode, Hor

  1   2   >