C Question: Multiple Results, Same Connection
Greetings:
In Main, I have:
MYSQL *conn;/* Pointer to connection handle */
Then, I do:
if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB, 0, NULL, 0)) !=
NULL)
{
/* Validate the structure of the btime database */
check_btime_structure(conn, BTIME_DB);
mysql_close (conn);
}
In, check_btime_structure:
MYSQL_RES *res_set;
MYSQL_ROW row;
char sql[255+1] = SHOW TABLES FROM ;
int i =0;
strncat(sql, BTIME_DB, sizeof(sql));
if ((res_set = do_query(conn, sql)) != NULL)
{
while ((row = mysql_fetch_row(res_set)) != NULL)
{
for (i = 0; i mysql_num_fields (res_set); i++)
{
check_btime_table (conn, row[i]);
}
}
}
return EXIT_SUCCESS;
}
In check_btime_table:
int
check_btime_table(MYSQL *conn, char *BTIME_TABLE)
/* Validate individual btime table */
{
MYSQL_RES *res_set;
char sql[255+1] = DESCRIBE ;
strncat(sql, BTIME_TABLE, sizeof(sql));
/* Cycle through the table description rows and make sure they're in synch */
if ((res_set = do_query (conn, sql)) != NULL)
{
fprintf(stderr, sql: %s%s%s\n, boldon, sql, boldoff);
}
return EXIT_SUCCESS;
}
The problem occurs because I'm walking through a result set, and, then,
check_btime_table needs to do another query with the ongoing results
processing. Incidentally, do_query does free the result prior to returning,
but, that doesn't seem to affect that fact that when I try the additional query
the result sets seem to step on each other.
I also tried to populate the field names into a linked list, but, those things
give me the willies.
Anyone have a similar application and have some c code that demonstrates
multiple queries with the same connection?
TIA.
Best Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql daemon aborting abnormally (rh linux 6.2)
hi gang!
after much hassle, i seem to have successfully installed mysql 3.23.38. i
now have another problem. the mysql daemon is aborting abnormally upon
startup. i typed in the following from bash:
cd /usr/local/mysql
./bin/safe_mysqld
i got the following output:
Starting mysqld daemon with databases from
/usr/local/mysql-3.23.38-pc-linux-gnu-i686/data
010606 22:51:27 mysqld ended
what the f--k? can someone please help me troubleshoot this.
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Chroot problems
On Wed, Jun 06, 2001 at 03:04:23PM -0700, Van wrote: I've dealt with jails and question the wisdom of using them. There are better ways to do this, and, your application will suffer tremendous portability issues which will probably make it useless for most people. If you're the only one using it, proceed. If you hope to make money with it, good luck. Quick answer: your environment is hosed. There shouldn't be a tutorial on running mysql in a jail because it shouldn't be done. I wish I could agree with you. What's so bad about running MySQL in a jail? Protect the whole box, not just one application. Do both. That way if one fails, the second may save you someday. I have an uncommitted patch for MySQL as well as some documentation for getting it to run better in a chroot() jail. I just need the time to make it useful... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 12 days, processed 78,013,857 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rookie admin needs install help
At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote:
I don't know whether slackware has the RPM software but if it does, use it.
You won't have these problems then. Otherwise I can only suggest you try
one of the other binaries instead.
i'm also a mysql admin rookie. i couldn't get the rpm file to install and
my linux distribution has the rpm software. however, i was able to install
the tarball.
hth
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FROM C to MYSQL
On Wed, Jun 06, 2001 at 09:34:28PM -0700, Jeremy Zawodny wrote: On Wed, Jun 06, 2001 at 01:01:47PM +0200, Alessandro Coppelli wrote: Hi to all. I would write a C programm for write a lot of variables in MySQL database. There are examples ? I try to write a cgi with Boutell library and then write the form variable in a database The MYSQL C API is documented in the manual, as well as instructions for using it. http://www.mysql.com/doc/ The C API chapter of the MySQL book is also available in PDF form as the sample chapter link at: http://www.newriders.com/books/title.cfm?isbn=0735709211 The source code for the examples is available at: http://www.kitebird.com/mysql-book/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 12 days, processed 77,933,253 queries (72/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rookie admin needs install help
Unix rookie as well?
0 | 0
\__/
Off the top of my head, rpm -i file_name should do it. I usually use
redhat's gui. man rpm will give you more details.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 13:20
Subject: Re: Rookie admin needs install help
At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote:
I don't know whether slackware has the RPM software but if it does, use
it.
You won't have these problems then. Otherwise I can only suggest you try
one of the other binaries instead.
i'm also a mysql admin rookie. i couldn't get the rpm file to install and
my linux distribution has the rpm software. however, i was able to install
the tarball.
hth
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL too slow....
i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql daemon aborting abnormally (rh linux 6.2)
Sure it hasn't already started? Do ps -ef | grep mysqld to find out.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 12:57
Subject: mysql daemon aborting abnormally (rh linux 6.2)
hi gang!
after much hassle, i seem to have successfully installed mysql 3.23.38. i
now have another problem. the mysql daemon is aborting abnormally upon
startup. i typed in the following from bash:
cd /usr/local/mysql
./bin/safe_mysqld
i got the following output:
Starting mysqld daemon with databases from
/usr/local/mysql-3.23.38-pc-linux-gnu-i686/data
010606 22:51:27 mysqld ended
what the f--k? can someone please help me troubleshoot this.
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
download for intel solaris 7
Hi , Which source code should I download to install mysql on Intel Solaris 7. Thanks and regards Sujeet
Making SQL request from a Mac
Hi, I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? Thanks for your help. Regards Pascal Miquet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting Error 1067 when trying to start MySQL as service on NT 4.0
Are you using use-symbolic-links as setting in my.cnf. I got the problem when I used it with mysqld-nt. If so delete the service and reinstall the service with mysqld-max-nt. Otherwise delete use-symbolic-links and restart the server. This may be the problem with the binaries but I am not sure. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 06 June 2001 22:08 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Getting Error 1067 when trying to start MySQL as service on NT 4.0 Listers, Apologies in advance for the cross-post. I've run into a problem starting MySQL on a Windows NT 4.0 workstation machine. Installation appears to have gone fine, but I cannot start MySQL as an automatic service. MySQL is listed in the Services panel, but it's currently inactive. When I select MySQL in the Services panel and click start I get a message saying Attempting to start they MySQL service on... A second or two later, I get an error message: Could not start the MySQL service on Error 1067: The process terminated unexpectedly. Any suggestions? Thanks in advance, Andy = Andy Crain The Sarasota Herald-Tribune 941-957-5199 [EMAIL PROTECTED] = - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
errors trying to compile programs with mysql binary
Hi All, I have installed mysql 3.23.38 from binary distribution. Problem is that when I try to compile some program for mysql i got this error message: -- gcc -o nacctd -Wall -O2 -Wstrict-prototypesmain.o daemon.o process.o utils.o config.o capture-linux.o -L/usr/local/mysql/lib/ -lmysqlclient /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [nacctd] Error 1 gcc -L/usr/local/mysql/lib -o radiusd radiusd.o dict.o files.o filters.o util.o md5.o attrprint.o acct.o radius.o pam.o log.o version.o proxy.o exec.o auth.o mysql.o timestr.o cache.o sql_module.o -lmysqlclient -lm -lcrypt /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [radiusd] Error 1 - Can someone please help me troubleshoot this. BR, Jordan
Re: sql server or mysql
Sebastian Murarasu wrote: Hello! Does anyone know which is the best choice between MS SQL Server and MySQL? Context: - TCP/IP protocol over the network - MS Visual FoxPro (5 or 6) as the front end development tool Please reply on my personal email address if possible ([EMAIL PROTECTED]) Thank you very much! Sebastian Murarasu MSSQL. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL too slow
i have MSAccess table with 1 records without any index i import same table in MySQL without any index When i access data from this table through ODBC in ColdFusion: Data from Access took 14 Sec and Data from MySQL took 24 Sec MySQL seems to be halfway back?? Does this the case realy?? Comments?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Speed
Hi, I was wondering where the limits of MySQL are. I need 2000 updates per second on a table with +-20 rows. I was wondering what the ideal hardware to accustom that would be. For the moment a SunFire 280R with 1 CPU and the table in memory (heap) seems to be able to handle 1800 updates a second. Is there a way to gain more speed, to update even more ?? Would a second CPU help? -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! #RandomTag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL too slow....
Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Parameterized and spatial data
Hi all, this is probably a silly question, but as I am a student who wants to use MySQL for a project, I would like to know if MySQL supports parameterized tables and if supports spatial data. Thanks.
tunneling
Hi, I have Windows 98 with ssh v2.4. Also on the server is ssh2 2.4 redhat7.1 Does anyone know of a clear concise howto on setting up tunneling between a client and a server. I tried to set it up but watching the traffic from dbtools or mysqlfront across to the server with tcpdump shows data going across as plain ascii. regards and thanks in advance Scott _ scott alexander tietoverkkosuunnittelija humak amk - finland +358(0)407505640 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
java interface with mysql
Hi,
I found something peculiar that happens when I try to use more then one
databases at the same time via java.
I wrote my own driver which is very basic.
I attached the error log and the files maybe someone can give me an
explanation.
If I open only one database is ok and it work.
DBWrap is the class using jni and WordSearcher instatiate one or more
classes of this kind to connect simultanious to various databases (which
I could not do)
DBWrap.cpp is the implementation used to compile under windows and
DBWrap.h is the header generated by javah -jni
#include windows.h
#include mysql.h
#include DBWrap.h
#include stdio.h
MYSQL_ROW row;
MYSQL_FIELD * fd;
MYSQL_RES * res;
MYSQL* myData;
int opResult;
JNIEXPORT jint JNICALL Java_DBWrap_connectTo(JNIEnv *env, jobject obj, jstring prompt)
{
const char *db = env-GetStringUTFChars(prompt, 0);
printf(%s, db);
myData = mysql_init((MYSQL*) 0);
if (!myData) {
printf( Can't init !\n) ;
mysql_close( myData ) ;
opResult = -1;
return opResult;
}
//try to connect to database
if ( (myData)
mysql_real_connect( myData, localhost , NULL, NULL, db , MYSQL_PORT,
NULL, 0 ) ) {
opResult = mysql_select_db( myData, db );
if ( opResult 0 ) {
printf( Can't select the %s database !\n, db ) ;
mysql_close( myData );
}
} else {
printf( Can't connect to the mysql server on port %d !\n, MYSQL_PORT
) ;
mysql_close( myData ) ;
opResult = -1;
}
env-ReleaseStringUTFChars(prompt, db);
return opResult;
}
/*
* Class: DBWrap
* Method:doQuery
* Signature: (Ljava/lang/String;)I
*/
JNIEXPORT jint JNICALL Java_DBWrap_doQuery(JNIEnv *env, jobject obj, jstring prompt){
const char *str = env-GetStringUTFChars(prompt, 0);
//printf(%s, str);
opResult = mysql_real_query(myData ,str ,strlen(str));
res = mysql_store_result(myData);
env-ReleaseStringUTFChars(prompt, str);
return opResult;
}
/*
* Class: DBWrap
* Method:fetchRow
* Signature: ()I
*/
JNIEXPORT jint JNICALL Java_DBWrap_fetchRow(JNIEnv *env, jobject obj){
row = mysql_fetch_row(res);
return (row == NULL);
}
/*
* Class: DBWrap
* Method:fetchField
* Signature: (I)Ljava/lang/String;
*/
JNIEXPORT jstring JNICALL Java_DBWrap_fetchField(JNIEnv *env, jobject obj, jint i){
return env-NewStringUTF(row[i]);
}
/*
* Class: DBWrap
* Method:freeResult
* Signature: ()V
*/
JNIEXPORT void JNICALL Java_DBWrap_freeResult(JNIEnv *env, jobject obj){
mysql_free_result(res);
}
/*
* Class: DBWrap
* Method:close
* Signature: ()V
*/
JNIEXPORT void JNICALL Java_DBWrap_close(JNIEnv *, jobject){
mysql_close(myData);
}
/* DO NOT EDIT THIS FILE - it is machine generated */
#include jni.h
/* Header for class DBWrap */
#ifndef _Included_DBWrap
#define _Included_DBWrap
#ifdef __cplusplus
extern C {
#endif
/*
* Class: DBWrap
* Method:connectTo
* Signature: (Ljava/lang/String;)I
*/
JNIEXPORT jint JNICALL Java_DBWrap_connectTo
(JNIEnv *, jobject, jstring);
/*
* Class: DBWrap
* Method:doQuery
* Signature: (Ljava/lang/String;)I
*/
JNIEXPORT jint JNICALL Java_DBWrap_doQuery
(JNIEnv *, jobject, jstring);
/*
* Class: DBWrap
* Method:fetchRow
* Signature: ()I
*/
JNIEXPORT jint JNICALL Java_DBWrap_fetchRow
(JNIEnv *, jobject);
/*
* Class: DBWrap
* Method:fetchField
* Signature: (I)Ljava/lang/String;
*/
JNIEXPORT jstring JNICALL Java_DBWrap_fetchField
(JNIEnv *, jobject, jint);
/*
* Class: DBWrap
* Method:freeResult
* Signature: ()V
*/
JNIEXPORT void JNICALL Java_DBWrap_freeResult
(JNIEnv *, jobject);
/*
* Class: DBWrap
* Method:close
* Signature: ()V
*/
JNIEXPORT void JNICALL Java_DBWrap_close
(JNIEnv *, jobject);
#ifdef __cplusplus
}
#endif
#endif
//Author: Herbei Dacian
//Description: Data Base Connection Wraper
public class DBWrap {
public native int connectTo(String db);
public native int doQuery(String query);
public native int fetchRow();
public native String fetchField(int fieldNumber);
public native void freeResult();
public native void close();
static {
System.loadLibrary(JINI);
}
public DBWrap() {
}
public DBWrap(String db) {
this.connectTo (db);
}
}
//Title:Your Product Name
//Version:
//Copyright:Copyright (c) 1999
//Author: Herbei Dacian
//Company: EPFL
//Description: EEDInterface
import java.util.Vector;
public class WordSearcher {
DBWrap strings = null;
DBWrap meanings = null;
DBWrap concepts = null;
DBWrap codes = null;
Vector mVector = null;
public void searchWord(String
Was: C Question: Multiple Results, Same Connection (Resolved...)
Van wrote:
In Main, I have:
MYSQL *conn;/* Pointer to connection handle */
Then, I do:
if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB, 0, NULL, 0)) !=
NULL)
{
/* Validate the structure of the btime database */
check_btime_structure(conn, BTIME_DB);
mysql_close (conn);
}
In, check_btime_structure:
MYSQL_RES *res_set;
MYSQL_ROW row;
char sql[255+1] = SHOW TABLES FROM ;
int i =0;
strncat(sql, BTIME_DB, sizeof(sql));
if ((res_set = do_query(conn, sql)) != NULL)
{
while ((row = mysql_fetch_row(res_set)) != NULL)
{
for (i = 0; i mysql_num_fields (res_set); i++)
{
check_btime_table (conn, row[i]);
}
}
}
return EXIT_SUCCESS;
}
In check_btime_table:
int
check_btime_table(MYSQL *conn, char *BTIME_TABLE)
/* Validate individual btime table */
{
MYSQL_RES *res_set;
char sql[255+1] = DESCRIBE ;
strncat(sql, BTIME_TABLE, sizeof(sql));
/* Cycle through the table description rows and make sure they're in synch */
if ((res_set = do_query (conn, sql)) != NULL)
{
fprintf(stderr, sql: %s%s%s\n, boldon, sql, boldoff);
}
return EXIT_SUCCESS;
}
Greetings, again:
No need to reply to this, since I figured out the problem. It was actually in
the do_query implementation:
Previously the do_query function was:
MYSQL_RES *do_query(MYSQL *conn, char *sql)
{
MYSQL_RES res_set;
if (mysql_query (conn, sql) != 0)
{
// do stuff...
}
}
After putting in the:
fprintf(stderr, do_connect Pointer address is %p\n, res_set);
in the fixed version I realized I was getting the same memory address for the
res_set pointer on each invocation. This was making the above res_set{s} step
on each other. It was returning the same address for each call, which confused
the query processing functions.
To ensure each invocation of the do_query function gets a new address, use the
following:
MYSQL_RES *do_query(MYSQL *conn, char *sql, MYSQL_RES *res_set)
/* Run a query. Return the result set. */
{
unsigned int errno = 0;
char *errmsg = NULL;
if (mysql_query (conn, sql) != 0) /* btime database doesn't
exist */
{
errno = mysql_errno(conn);
errmsg = mysql_error(conn);
fprintf(stderr, There is a problem with the BTime database...\n\n);
fprintf(stderr, The actual error was:\n);
fprintf(stderr, mysql_query error: #%u.\n%s\n\n, errno, errmsg);
fprintf(stderr, The query was: %s\n, sql);
exit(EXIT_FAILURE);
} else {
res_set = mysql_store_result (conn);/* generate result set
*/
if (res_set == NULL)
{
errno = mysql_errno(conn);
errmsg = mysql_error(conn);
fprintf(stderr, mysql_store_result() failed...\n\n);
fprintf(stderr, The actual error was:\n);
fprintf(stderr, mysql_real_connect error: #%u.\n%s\n\n,
errno, errmsg);
fprintf(stderr, The query was: %s\n, sql);
exit(EXIT_FAILURE);
}
}
// fprintf(stderr, do_connect Pointer address is %p\n, res_set);
// mysql_free_result(res_set);
return res_set;
}
Thus, the same connection can be used and note the mysql_store_result (conn)
implementation, rather than mysql_use_result(), which can require more coding
for small result sets.
So throw a MYSQL_RES *res_set in the function declaration that will call the
do_query function, but, not in the do_query function, and pass that pointer to
do_query, which will return the newly allocated pointer in the return.
Ensure you do the mysql_free_result(res_set) in the function that calls the
do_query(), not within do_query(). That's why it's commented out in
NON-C-COMMENTING-NOTATION. I comment with // on debug functions so don't flame
me.
Thought this might save someone else out there 12 hours worth of strange memory
addressing chasing.
Regards,
Van
--
=
Linux rocks!!! http://www.dedserius.com
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try:
Re: download for intel solaris 7
Sujeet Kulkarni wrote: Hi , Which source code should I download to install mysql on Intel Solaris 7. Thanks and regards Sujeet Sujeet: The same tarball that anyone rolling from source code uses: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.38.tar.gz Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making SQL request from a Mac
Pascal MiQUET wrote: Hi, I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? Thanks for your help. Regards Pascal Miquet Pascal: On MAC non-Os X, write a browser app so they can use IE, or Netscape. Perl, CGI, or PHP. On Windows, talk directly through the MyODBC driver. Get it here: http://www.mysql.com/downloads/api-myodbc.html Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Databases not seen with show database query...
Hi All... I m running Mysql 3.23.36 on Redhat Linux 7.0... Installation and configuration has been finished... Mysql is working perfect on some systems but on some systems when i Say show databases it gives the following error... mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | | | +--+ 10 rows in set (0.00 sec) mysql I am not able to see any databases in Mysql while the databases exist in Mysql as it indicates 10 rows.. what is the problem pls help me. Kind regards Harish Gundecha Systems Administrator Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Versaware Technologies (India) Pvt. Ltd. Phone : +91-20-6136028 Extn: 331
Re: MySQL too slow....
I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time - Original Message - From: Van [EMAIL PROTECTED] To: Muhammad Asif [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL too slow....
Muhammad Asif wrote: I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time Muhammad: If the ColdFusion server has PHP support (likely), then, you're all set. Check php.net. Write a test script in your application: Create a file called test.php and put the following line in it: ? php_info(); ? If that works, you can add the following line: ? $link = mysql_connect(localhost, somedude, real_secret);? If you get any response on that one like access denied, or something similar, you're golden. If it responds with something like I don't understand what you mean by MySQL, you have more work to do. If the above tests succeed you have php/mysql support and can write the web application using php/mysql support, which is extremely trivial. Hope that helps. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help on mysql/php
On Wed, 6 Jun 2001, Ian Ford wrote: Name your config file config.inc and if any of the below situations happen your password and username will not show up in plain text for the casual browser. (EXAMPLE: CONFIG.INC ? $DBname = 'test'; $DBuser = 'imatest'; $DBpass = 'Whatever'; $DBhost = 'localhost'; ? INDEX.PHP ? require(config.inc); $conn = mysql_connect($DBhost,$DBuser,$DBpass); mysql_select_db($DBname); ? END EXAMPLE) You can place the config.inc any where you want. My preference is in a includes folder... Actually I tried this out sometime ago and found that it appears as a plain text file. This I believe is because the webserver know that .php or .php3 should be treated as a php file and other in which ever way it can display. -Original Message- From: Neil Zanella [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 12:09 PM To: Don Read Cc: Ed Peddycoart; Mysql@Lists. Mysql. Com; Jorge Oliveira Subject: RE: Need help on mysql/php On Tue, 5 Jun 2001, Don Read wrote: Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is poorly configured. include($DOCUMENT_ROOT/../config.php); This is a very good idea. One day if the system administrator decides to back up all the user data and upgrade the web server and forgets to include support for PHP then all the PHP files become readable as plain text and casual web surfers could sniff your password. Another scenario where this could happen is if there are two web servers and your home directory is mounted on both via NFS or AFS and you may not be aware that the other web server does not have PHP support. If you are serving from /home/httpd/html then store your database access information including passwords in some directory like /home/httpd/secret and set the right ownerships for that directory and files therein. It is also a good idea to control extraneous access to the database by firewalling your site. Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VB3 and mysql
At 10:53 07/06/2001 +1000, Hillier wrote: Hi! My answer is a guess, because I can't install my VB3 because the floppy install disks are damaged. My guess is you can't to use VB3 because its ODBC support is 16 bit since MySQL is a 32 bit application. Anyway take a look on Microsoft support if you find a way to use ODBC 32 bits for VB3, then you can. Regards, Miguel To whom it may affect Jonas Norrman pass this question on to you Is VB3 compatiable for mysql * Visual Basic Thanks Brett Hillier -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql server or mysql
This all depends on your needs. If you're looking for speed and reliability, you can't beat MySQL on a unix based system. However, MySQL lacks features such as subselects and foreign keys. Some are still on the way while others will never be implemented. A good place to start would be the mysql manual, especially their todo list. - Original Message - From: Sebastian Murarasu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 14:18 Subject: sql server or mysql Hello! Does anyone know which is the best choice between MS SQL Server and MySQL? Context: - TCP/IP protocol over the network - MS Visual FoxPro (5 or 6) as the front end development tool Please reply on my personal email address if possible ([EMAIL PROTECTED]) Thank you very much! Sebastian Murarasu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: does show create table work?
fair enough. thanks! Rob - Original Message - From: Andrew Schmidt [EMAIL PROTECTED] To: Rob Agar [EMAIL PROTECTED]; Mailinglist MySQL COM [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 7:02 PM Subject: Re: does show create table work? I believe show ceate table was added in mysql 3.23 and subsequently 3.22 will not have it. thanks, -- Andrew - Original Message - From: Rob Agar [EMAIL PROTECTED] To: Mailinglist MySQL COM [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 11:48 AM Subject: does show create table work? hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem
Hi, I wanted to know how to transfer a text file ( from a Digital Unix system) to a mysql database tha I have created. Thank you in advance. Dandy Mubima, student at the University of Nairobi, Kenya. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL too slow....
How about PhP? Simon -Original Message- From: Muhammad Asif [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 10:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL too slow I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time - Original Message - From: Van [EMAIL PROTECTED] To: Muhammad Asif [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL too slow....
I use PHP, a very special scripting language for the web and has an excellent list of commands to interface with MySQL. I recommend the book professional PHP and also the site php.net thanks, Hasan Impex - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:19 PM Subject: Re: MySQL too slow I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time - Original Message - From: Van [EMAIL PROTECTED] To: Muhammad Asif [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL too slow....
Hello! A lot of people use PHP4 or PERL or C++ and connect *directly using the script. PHP4 has MySql functions built right in for convenience. In PHP for example, just do this: MYSQL_CONNECT(localhost,yourID,yourPassword); mysql_select_db(yourDB); $maxi=mysql_query(select fieldname1, fieldname2, fieldname3 from tablename where ...); There are more examples from other languages in the archives, I believe. Cheers! -warren - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:19 AM Subject: Re: MySQL too slow I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i have to query the database(MySQL) through some scripting language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web browser... Thx in advance for your time - Original Message - From: Van [EMAIL PROTECTED] To: Muhammad Asif [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow Muhammad Asif wrote: i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index etc comments??? Muhammad: ODBC is slow in MySQL. Make sure you're using a current MyODBC driver. If that doesn't help, don't know what to tell you. Many people use straight network queries which avoid this overhead. Keep in mind, ODBC was a standard M$ put in place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC layer if M$ didn't have a monopoly on the desktop. There would be better db communications interfaces, instead. Indexing fields you query often is a given. But, you know this, I'm sure... Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with adding some functions into MySQL
=?iso-8859-2?Q?Ji=F8=ED=20=A9krabal?= writes:
Hi all,
I'm currently working on project, where I need implement some functions to formate
SQL queries.
It's necessary to add these functions into MySQL.
I read about UDF (user def. functions) and I mean, that it is almost what I want.
For examlple,
QUERY()... UDF function, whitch returns string like: SELECT * FROM tab;
What I need is to execute this string like MySQL query.
I know, that it could be done by PHP script (function) like this
function DB_Query( $query, $connection )
{
$tmpquery = SELECT QUERY( $query );;
$result = MySQL_Query( $tmpquery, $connection );
$entry = SQL2_Fetch_Array( $result );
$dbquery= $entry[ 1 ];
$result = MySQL_Query( $tmpquery, $connection );
return ($result);
}
But the problem is, that it requires two DB calls.
It's necessary to add these functions into MySQL, because if I use other API (for
example
DBI, etc.) I need to write all functions like above again.
Is it possible to create QUERY() function which would execute the query?
(not to return string with query, but return query results)
thanx
--Nykolas
Hi!
No, it is not possible, but stored procedures are planned to be
implemented with the end of this year.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored procedures (really sorry for bringing this up)
John N S Gill writes:
The company I work for has been considering moving a key database from
MS Access to a proper database.
We use linux for a lot of the number crunching we do and I was keen for
us to choose MySQL. I happen to think it would be ideal for our
applications.
Unfortunately, those with the task of converting the application
consider stored procedures to be essential. I'm not at all convinced
they are necessary (at least in the short term). I fear the arguement
is already lost.. but...
I saw from the survey that is currently being done that stored
procedures are one feature that appears to be in active consideration,
but I see from the TODO list that they are only in the to be done
sometime category.
So the questions are:
any idea how long it will be before something is in place? would
funding change this?
can also offer some help with the coding (have solid C/C++ but
no experience with MySQL itself)
John Gill.
Hi!
We have plans of implementing stored procedures until the end of this
year, but if it is too far away for you , you can try doing it
yourself.
If you have problems, post your mails to [EMAIL PROTECTED]
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tunneling
You can try stunnel. The guys at www.stunnel.org (non official site) have a nice howto about connecting two mysql over a SSL tunnel. I'm using it and works perfect. Best regards Dario Scott Alexander wrote: Hi, I have Windows 98 with ssh v2.4. Also on the server is ssh2 2.4 redhat7.1 Does anyone know of a clear concise howto on setting up tunneling between a client and a server. I tried to set it up but watching the traffic from dbtools or mysqlfront across to the server with tcpdump shows data going across as plain ascii. regards and thanks in advance Scott _ scott alexander tietoverkkosuunnittelija humak amk - finland +358(0)407505640 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php S/MIME Cryptographic Signature
Re: Compiling in 64-bit Solaris environment
McCaffity, Ray writes:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [Compiling in 64-bit Solaris environment]
Description:
checking return type of sprintf... configure: error: can not run
test program while cross compiling
How-To-Repeat:
Compile any version of mysql using any version of gcc on any 64-bit
install of Solaris (7 or 8)
Fix:
only compile on 32-bit OS installations.
Submitter-Id: Ray McCaffity
Originator:Super-User
Organization:
organization of PR author (multiple lines)
MySQL support: [none]
Synopsis: cannot run or compile mysql in 64-bit environment
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug | doc-bug | change-request |
Release: mysql-3.23.38 (Source distribution)
Environment:
machine, os, target, libraries (multiple lines)
System: SunOS webstats 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc
gcc version 2.95.3 20010315
(release)b/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1759264 Jun 1 22:11 /lib/libc.a
1rwxrwxrwx 1 root root 11 May 30 15:49 /lib/libc.so -
./libc.so.
-rwxr-xr-x 1 root bin 1136692 Jun 1 22:11 /lib/libc.so.1
-rw-r--r-- 1 root bin 1759264 Jun 1 22:11 /usr/lib/libc.a
.so.1wxrwx 1 root root 11 May 30 15:49 /usr/lib/libc.so -
./libc
-rwxr-xr-x 1 root bin 1136692 Jun 1 22:11 /usr/lib/libc.so.1
./configure --with-perl --prefix=/usr/local/mysql --with-gnu-ld
Hi!
A solution to your problem is very clearly described in our manual,
section on Solaris, a part that explains how to edit configure script.
Beside that, our 2.7 binary will work just fine on your 2.8.
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making SQL request from a Mac
I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? Check out MacSQL Monitor ... http://www.runtimelabs.com/ The other options would be a browser-based query tool and I think there may also be some pure java clients as well, but I like MacSQL Monitor. If it's not possible, How can I get access to a PC With windows ? H ... delete Windows, install Linux or BSD or something :-) There are lots of Windows clients ... probably the mysql web site would be a good place to start. -- Ray Zimmerman / e-mail: [EMAIL PROTECTED] / 428-B Phillips Hall Sr Research / phone: (607) 255-9645 / Cornell University Associate / FAX: (815) 377-3932 / Ithaca, NY 14853 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Database into mysql
Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which exceed the data size allowed in a table cell by Microsoft Excel I can't export it via Excel and convert it from Excel into a Text Tabs document (As I did with other tables). I tried all possible export options with Access, but when I try to do a text document it just removes all data, which is not visible on the monitor, when the export takes place. (It is a table with many columns). I can have either a html file or a richtext file with all the data in. Both seem to me not that useful for my purpose. Is it possible to export the data directly from Access to Mysql via the ODBC Adaptor? If so, how? Is there another way to get the data from Access to Mysql without the need of either pasting them in per hand or by putting the tabs and breaks in by hand into the rich text file to end up with a text which is tabs separated and can be imported? I work on a NT machine. The data will be exported to mysql and will then be moved to a MacOsX Server 1.2. Thank you for any suggestions, as doing it by hand will be very inconvenient. sincerely Ute _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New To mySQL
Hi all, I am a new user of mysql DB. I am working with WN NT 4. I already downloaded the mysql binary package for window. I installed it. But, now I don't know where to begin. How to start the DB. Please, I would like to have some ways to begin. Thanks, Geoffrey... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Compiling an PHP 4.0 module with MySQL
Harry, Thank you it worked, although I don't know why, in fact using 127.0.0.1 without the port also worked. Previously I had been using localhost to define the host in my connect functions. I had another reply but this was sent to me directly. This said: ./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars the configuration fails giving the following error: cannot find header files under /usr/bin Try: CPPFLAGS=-I/path/to/mysql.h ./configure --with-mysql=/usr/bin As an exemple I compiled with CPPFLAGS=-I/usr/local/mysql/include/mysql jean-michel I tried this but got an error indicating that my C compiler did not work (gcc). I also tried moving the mysql.h file that came with the PHP source to my /usr/bin/ directory (where I think mysql resides) to see if my original ./configure statement would work, but I still get the message saying it cannot find the header files. I am not sure what these are, but I am wondering if my MySQL installation made with a Mandrake distribution has ignored the header files. I am reluctant to rebuild everything from source files as I think this could take me into even deeper water! Particularly as I now have things working thanks to you, but it would be nice to know if anybody has any ideas. Keith At 14:06 06/06/01 -0600, Harry Bakken wrote: I had the same problem, though I did not know the cause. The work-around I used was to use 127.0.0.1:3306 as the hostname for connecting in the script. Harry -Original Message- From: Keith Attfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 11:39 AM To: [EMAIL PROTECTED] Subject:Compiling an PHP 4.0 module with MySQL I need some help upgrading to PHP 4.0 (version 4.0.5) on my Linux web server running Apache containing a PHP module configured with MySQL. I am trying to install PHP from the source tar downloaded from www.php.net. I am following the installation instructions that say that I can get away without recompiling Apache. The steps in the instructions are: 1 check all library locations are listed in /etc/ld.so.conf and then run ldconfig 2 unpack the php tar, configure then make and install 3 amend the httpd.conf file to: 1) verify the paths, 2) check the Module and Type lines are in place, and 3) remove lines referring to the previous PHP 3.0 installation. At step two above I am running the following to configure the PHP module: ./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars the configuration fails giving the following error: cannot find header files under /usr/bin I am using the path /usr/bin/ because this contains the file mysql, and I also tried /usr/sbin/, because this contains mysqld, but with the same results. If I configure without specifying a path in the --with-mysql option I can make and install and run a PHP script. However, when I run a script containing a MySQL connection statement I get the following error displayed in my browser: can't connect to local MySQL server through socket '/tmp/mysql.sock' The Linux kernel is 2.2.13 and has been installed from a Mandrake distribution. This is also the source of Apache, PHP 3 and MySQL. The distribution puts files in non-standard places so I am wondering if the solution to my problem is to find the right base directory to use in the --with-mysql=/path/ syntax, and/or the header files are in the wrong place. I have searched and tried many option but with no success. Can anybody help me please? Thanks for any help. Keith Attfield (UK) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Parser
Manish Chakrabarti writes:
I have a related question. I am looking for a pretty robust SQL parser which
is also
transparent in the sense that one can go into it and modify the query
processing parts (i.e. actions)?
Does MySQL source distribution include the lex/yacc files specifying the SQL
grammar,
and also are there some hooks into the parser/query processing engine of
MySQL?
So that I can have handles into the parse tree (which I plan to use for my
purpose).
I could not find this talked about in the mysql maling lists. I am basically
interested in
extracting the query parsing engine out of mysql. Is it possible to do that?
Thanks!
Manish
Hi!
No, I am afraid that would not be easy.
The reason for that is that we did our best to make our parser
fastest available, so we actually integrated it very firmly with the
rest of the code. Actually some 5 - 25 % of processing of the query
is performed by the parser.
But that should not stop you adding code to MySQL.
If you have problems on that front, write to
[EMAIL PROTECTED]
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Speed
Thierry Coopman writes:
Hi,
I was wondering where the limits of MySQL are.
I need 2000 updates per second on a table with +-20 rows.
I was wondering what the ideal hardware to accustom that would be.
For the moment a SunFire 280R with 1 CPU and the table in memory
(heap) seems to be able to handle 1800 updates a second.
Is there a way to gain more speed, to update even more ??
Would a second CPU help?
--
Thierry Coopman - [EMAIL PROTECTED]
My opinions are personal, and have really nothing or nothing to do
with Keytrade!
#RandomTag
Hi!
Yes, the above is quite possible.
You should normalize your schema, optimize queries, tune up MySQL and
make a perfect choice of hardware / OS and you can obtain better
results then the one you expect.
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL error
I use mysql with IMP, a webmail application very nice and fast. Till I used the old version of Mysql 3.22.xx i had no problem. Now i upgrade to the new one and often i have problem with mysql cause it doesn't read the packet from the applicatione and it prints a page error on the web. Someone can help me. Thanks --- Aldo Spanò www.italian.it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can i keep a connection to the database open
i want to write a web-based chat application in Perl which runs on Unix server with mySQL as backend. The application needs to continouly interact with database hence instead of opening a DBI connection in each perl page, I wish to keep a live open connection with database. Is it possible ? If yes, how ? Pls reply to my email id : [EMAIL PROTECTED] Reagrds harsh http://mail.indiainfo.com First you had 10MB of free mail space. Now you can send mails in your own language !!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing spreadsheet data into MySQL
What you do after you have it in a Acces Database is make a table that looks like the Acces Database in MySQL. And then create a ODBC connection to that Table. Then you run a Query that inserts all the data into the mySQL database from the Acces database like follow : insert into dbo.mySQLEXELDB select * from ACCESSEXELDB And that is that.. hope it makes more sense Johannes At 16:19 06/06/2001 -0600, you wrote: From: Johannes Pretorius [EMAIL PROTECTED] Date: Wed, 06 Jun 2001 16:49:45 +0200 To: Chris L. Gray [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Importing spreadsheet data into MySQL Hi there Yes you can do this by going into Access and op[ening the XLS file from there then importing it into a table. This part makes sense This meaning you have a database from where you can move it over to mySQL's table via ODBC connection or how you like moving it from DB to DB. This part I don't understand, can you mention more about how you get a MS Access file on a WIndoze box over to MySQL on a Linux box? Chris I hope this helps Johannes At 08:15 06/06/2001 -0500, you wrote: Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Rookie admin needs install help
At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote:
Unix rookie as well?
0 | 0
\__/
Off the top of my head, rpm -i file_name should do it. I usually use
redhat's gui. man rpm will give you more details.
evidently, there's something wrong with the rpm package for linux. the
binary at mysql.com installs fine. also, the binary at sourceforge doesn't
install properly either.
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Socket Problem
Hi, Can't connect my MySQL 3.23 via PHP, on console it works fine, but via PHP it says Can't connect via socket /var/lib/mysql/mysql.sock...file exists, its suid and 777. So where is the problem Thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql DBI install problem
I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get the MYSQL DBI module to install. It's dieing on this line. I'm very perplexed. Ruben umask -a Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\1.1835\ -DXS_VERSION=\1.1835\ -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL Mysql.xs: In function `XS_Mysql_listdbs': Mysql.xs:945: `sv_undef' undeclared (first use in this function) Mysql.xs:949: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listtables': Mysql.xs:970: `sv_undef' undeclared (first use in this function) Mysql.xs:974: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listfields': Mysql.xs:1005: `dowarn' undeclared (first use in this function) make[1]: *** [Mysql.o] Error 1 make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' make: *** [subdirs] Error 2 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
crash
Compiling MySQL with --with-bdb the mysql daemon crashes at runtime, the crash occures in /lib/libdb.so, I thought it was a linking problem, so i tried to rename the berkeleydb library (libbdb instead of libdb), but the problem is not that. I removed the source installation and installed the binary one (as the documentation says), but I need to use RAID (mysql one not disk RAID) and binary distributions have not that feature. Now I don't remember which function crashes, but I guess it's gethostbyname() or similar. I experienced the problem on Slackware 7.x and on Stampede 0.89/0.90, I have not a RedHat to try on that, the problem doesn't exist on Sun Solaris. If you can reproduce the problem on Slackware gdb is enough to find the crash point. Thanks in advance (you did a great work). Greetings P. - Patrizio Bruno DADA spa / Special Projects Viale Giovine Italia 50122 Firenze Italy tel +39 055200211 fax +39 0552478143 PGP PublicKey available at: http://www.keyserver.net/en/ - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please can you help me find the right file to download
I am after a version of MySQL with a graphical interface. I don't know which files to download or what to do with them once downloaded. I am keen to try out mysql but I am having difficulty understanding what to do with the downloas I have. Is there any chance you can email me the links to the files along with a brief overview of installing and configuring the software for use on my PC. I am running Winnt 4.0 Server. I would appriciate any help you can give. Best Regards Stephen _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access Database into mysql
Hi there I am succesfully using DB Tools, you can find it on the MYSQL web site. It works perfectly, you just need to change your date columns, as when it imports, it imports as a DateTime (because that is how access works), and I wanted Date only columns. Otherwise works like a dream Cheerio ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Ute Hoffmann Sent: 07 June 2001 12:22 To: [EMAIL PROTECTED] Subject: Access Database into mysql Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which exceed the data size allowed in a table cell by Microsoft Excel I can't export it via Excel and convert it from Excel into a Text Tabs document (As I did with other tables). I tried all possible export options with Access, but when I try to do a text document it just removes all data, which is not visible on the monitor, when the export takes place. (It is a table with many columns). I can have either a html file or a richtext file with all the data in. Both seem to me not that useful for my purpose. Is it possible to export the data directly from Access to Mysql via the ODBC Adaptor? If so, how? Is there another way to get the data from Access to Mysql without the need of either pasting them in per hand or by putting the tabs and breaks in by hand into the rich text file to end up with a text which is tabs separated and can be imported? I work on a NT machine. The data will be exported to mysql and will then be moved to a MacOsX Server 1.2. Thank you for any suggestions, as doing it by hand will be very inconvenient. sincerely Ute __ ___ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making SQL request from a Mac
I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? If you run windows, have a look at MySQL-front 1.18: http://www.mysqlfront.de on a mac I would prefer the browser-based phpMyAdmin: www.phpwizard.net Ansgar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql AB question
Just reading that MySQL AB has a new CEO http://www.mysql.com/news/article-67.html. I was wondering if anyone has any info. regarding the future direction of Mysql with respect to the open source community. The news release mentions stuff like value-add services and the pursuit of sound business... Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation problem
i've tried to install mysql version 3.23.3 for linux, but I get always the error message if I try to connect to bd: for example /mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' michela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need help on mysql/php
At 2:13 PM +0530 6/7/01, Adrian D'Costa wrote: On Wed, 6 Jun 2001, Ian Ford wrote: Name your config file config.inc and if any of the below situations happen your password and username will not show up in plain text for the casual browser. (EXAMPLE: CONFIG.INC ? $DBname = 'test'; $DBuser = 'imatest'; $DBpass = 'Whatever'; $DBhost = 'localhost'; ? INDEX.PHP ? require(config.inc); $conn = mysql_connect($DBhost,$DBuser,$DBpass); mysql_select_db($DBname); ? END EXAMPLE) You can place the config.inc any where you want. My preference is in a includes folder... Actually I tried this out sometime ago and found that it appears as a plain text file. This I believe is because the webserver know that .php or .php3 should be treated as a php file and other in which ever way it can display. That only applies to the extension of the top-level file. Included files can have any extension. You do, however, have to surround the text of the included file with ?php ? or ? ? or whatever tags you use. That might have been your problem. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access Database into mysql
If you are familiar with perl, try using DBD::ODBC module to pull the data out of Access and use the DBD mysql modules to write the data to mysql. You will have to set up the table structure in mysql to match your Access. -Original Message- From: Ute Hoffmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 12:22 PM To: [EMAIL PROTECTED] Subject: Access Database into mysql Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which exceed the data size allowed in a table cell by Microsoft Excel I can't export it via Excel and convert it from Excel into a Text Tabs document (As I did with other tables). I tried all possible export options with Access, but when I try to do a text document it just removes all data, which is not visible on the monitor, when the export takes place. (It is a table with many columns). I can have either a html file or a richtext file with all the data in. Both seem to me not that useful for my purpose. Is it possible to export the data directly from Access to Mysql via the ODBC Adaptor? If so, how? Is there another way to get the data from Access to Mysql without the need of either pasting them in per hand or by putting the tabs and breaks in by hand into the rich text file to end up with a text which is tabs separated and can be imported? I work on a NT machine. The data will be exported to mysql and will then be moved to a MacOsX Server 1.2. Thank you for any suggestions, as doing it by hand will be very inconvenient. sincerely Ute _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help required for OLEDB on win32 for MySQL(linux)
Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in VB MySQL server is on 192.168.100.101 and database is Test . This is allowed to be connected from any IP and any user Private Sub Form_Load() Dim dcncentral As ADODB.Connection Set dcncentral = New ADODB.Connection Dim str1$ str1 = Provider=MySQLProv;Data Source=192.168.100.101;DB=Test dcncentral.Open str1- Giving Catastrophic Error End Sub This function is not opening the database and giving Catastrophic Error. What should be the connection string for database ? Please help. Kindly note that I want to connect to MYSQL database without a DSN Thanks in Advance Asit Saha
Re: MySQL with perl
I overcame this by adding to my php script, something that goves the
user the results, summerised, of what they added to the database, thus
when hitting refresh, it just refreshes the results of what the php
script returned, not what they submitted.
My php script is below.
Pete
html
body
?php
require(fedb.inc);
mysql_connect(localhost,$user,$password);
@mysql_select_db($db) or die( Unable to select database);
/*Insert into database */
mysql_query (INSERT INTO asset (site_id, hostname, device, model,
serial, ip,
dept, mhz, ram, hd_size, os_ver, status, data_port,
pp_port, hub_port,
digi_port, csmim_port, tprmim_port, xyplex_port,
comments, fe)
VALUES ('$site_id', '$hostname', '$device',
'$model', '$serial', '$ip',
'$dept', '$mhz', '$ram', '$hd_size',
'$os_ver', '$status',
'$data_port', '$pp_port', '$hub_port',
'$digi_port',
'$csmim_port', '$tprmim_port',
'$xyplex_port',
'$comments', '$fe')
);
print ($site_id);
print ( );
print ($hostname);
print ( );
print ($device);
print ( );
print ($model);
print ( );
print ($serial);
print ( );
print ($ip);
print ( );
print ($dept);
print ( );
print ($mhz);
print ( );
print ($ram);
print ( );
print ($hd_size);
print ( );
print ($os_ver);
print ( );
print ($status);
print ( );
print ($data_port);
print ( );
print ($pp_port);
print ( );
print ($hub_port);
print ( );
print ($digi_port);
print ( );
print ($csmim_port);
print ( );
print ($tprmim_port);
print ( );
print ($xyplex_port);
print ( );
print ($comments);
print ( );
print ($fe);
print ( );
print (p);
print (p);
print (Thanks for submitting your device.);
?
a href='index.html'bHome/b/a |
a href='searchform.html'bSearch Item/b/a |
a href='searchform_all.html'bSearch Site/b/a |
a href='updateform.html'bUpdate/b/a |
a href='deleteform.html'bDelete/b/a
/body
/html
Cindy wrote:
Dawn H writes:
I've written a couple of scripts and have a thing that I haven't quite
figured out. If anyone can shed light on this, I'd appreciate it.
When a person submits a form that inserts a record into the database, if
they then refresh the page that comes up after the submit, the record will
be submitted a second time. I suppose this is due to the fact that the
subroutine that is called with the submit contains both the write to
database bit and the view bit. So refreshing causes a repeat of both items.
How can I do this without that problem?
I was finally forced to add a check that there wasn't already an
identical record (using a minimum comparison set of fields) before
inserting the record. There really isn't any way to prevent dingbats
from refreshing, so... I CYA by emailing a copy of the record/element
values to myself when I refuse to add it in, but I havne't had any
spurious refusals so far.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
encrypt wierdness
Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
without specifying a salt yields random results:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1732533 to server version: 3.23.37-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql select encrypt('qwerty');
+---+
| encrypt('qwerty') |
+---+
| V/3Wzqmp93fts |
+---+
1 row in set (0.00 sec)
mysql select encrypt('qwerty');
+---+
| encrypt('qwerty') |
+---+
| W/55RyU1LdYN6 |
+---+
1 row in set (0.00 sec)
How is this useful? Looking at the C crypt manpage, you MUST specify a salt:
char *crypt(const char *key, const char *salt);
So where does mysql get its salt from? Is it a random salt? This confused the hell our
of me for around an hour!
--
Richard Ellerbrock
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql daemon aborting abnormally (rh linux 6.2)
At 02:44 PM 6/7/2001 +0800, Rolf Hopkins wrote:
Sure it hasn't already started? Do ps -ef | grep mysqld to find out.
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 12:57
Subject: mysql daemon aborting abnormally (rh linux 6.2)
hi gang!
after much hassle, i seem to have successfully installed mysql 3.23.38. i
now have another problem. the mysql daemon is aborting abnormally upon
startup. i typed in the following from bash:
cd /usr/local/mysql
./bin/safe_mysqld
i got the following output:
Starting mysqld daemon with databases from
/usr/local/mysql-3.23.38-pc-linux-gnu-i686/data
010606 22:51:27 mysqld ended
sorry. i forgot to mention that i did a *ps* before i attempted to start
the mysql daemon. the daemon wasn't already running when i attempted to
start it.
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Too many connections!
Ciao guys, I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run it, and had a 'too many connections' warning. So, I just set the max_connections variable to 200. And since then, no problem. Here is the /etc/my.cnf file under the [mysqld] group: set-variable=key_buffer=16777216 set-variable=max_connections=200 set-variable=table_cache=2048 I want to ask you if there's a way to keep this under control. I mean. What should I do to do this? I use to give a look at the status and extended-status with mysqladmin, but are there any attributes I should keep an eye on? And, why does max_used_connections always says: 100? Kinda weird, isn't it? Ciao and thanks! -Gabriele Ciao, Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL working on a cluster
I have a question: On a cluster, is it possible to have several MySQL instances (one per node) each having several mysqld processes, working concurrently on NAS (network storage) device, that is mounted on every node, and accessed through a shared filesystem ?? How does mysql controlles the access to database files? Through file system calls ? Does anyone used mysql on a cluster ? Suggestions ? Anyone ? (I'm thinking on use Mosix and Global File System (GFS) ) Thanks in advance Nelson Gomes - Dep. Internet a|cj Grupo Abril/Controljornal/Edipresse *: 21 415 21 60 *: [EMAIL PROTECTED]
problems getting asp to talk to mysql
my isp olm.net are not helping. what needs to be installed on a unix server to enable an asp page to talk to mysql please.
Re: Socket Problem
Sebastian Koschinski wrote: Hi, Can't connect my MySQL 3.23 via PHP, on console it works fine, but via PHP it says Can't connect via socket /var/lib/mysql/mysql.sock...file exists, its suid and 777. So where is the problem Thanx And the permissions on /var/lib/mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Borland C++Builder compile error
I am attempting to add SQL client-server functionality to a Window's (2000) app I am developing in Borland's C++Builder v5. After installing the mysql C API, including the mysql.h header and setting my include and library paths appropriately, I was unable to compile the API code. The compiling error occurs in mysql_com.h at line 115 which reads my_socket fd; the compiling error is type name expected, followed by a second error Declaration missing ';'. I've looked at the code which I can see, and there doesn't seem to be any syntax errors. Has anyone seen something like this occur before?? I may need to change some settings or macros to get this to compile, but I don't know where to start. Any suggestions for getting around this problem? Thanks in advance, Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql SQL behaviour with a plus sign
It looks like mySQL is funny about a + next to a - in a string. If I do select count(*) from Table where Column like '%+---%' I get 0 records. If I do select count(*) from Table where Column like '%---%' I get 70652 records. How can I make it insensitive to a +- Thanks in advance. Piyush.
errcode 13
hi there, i've got a problem which someone might be able to help me with. i'm importing text files into a database in mysql using mysqlimport : /users/mysql/bin/mysqlimport -u * databasename *.txt however i'm getting the following error all the time: Can't get stat of '/datenbank/ensembl/ensembl/Xref.txt.table' (Errcode: 13), when using table: Xref can anyone throw some light on the problem? thanks, Sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
configure error on Cobalt OS
i am unable to execute the configure command as part of the mysql installation. if i execute this statement using 'configure found in /usr/doc/libtool-1.3.5/demo/: [root /mysql-3.21.33c-pc-linux-gnu-i686]# /usr/doc/libtool-1.3.5/demo/configure --prefix=/usr/local/mysql here is the message from this execution: creating cache ./config.cache configure: error: can not find install-sh or install.sh in /usr/doc/libtool-1.3. 5/demo /usr/doc/libtool-1.3.5/demo/.. /usr/doc/libtool-1.3.5/demo/../.. if i use this other configure program found in /usr/share/libtool/libltdl/: [root /mysql-3.21.33c-pc-linux-gnu-i686]# /usr/share/libtool/libltdl/configure - -prefix=/usr/local/mysql then i get this message upon execution: loading cache ./config.cache configure: warning: *** The top-level configure must select either configure: warning: *** AC_LIBLTDL_INSTALLABLE or AC_LIBLTDL_CONVENIENCE. configure: error: *** Maybe you want to --enable-ltdl-install? all steps were completed successfully up until this statement. apparently it cannot find the the configuration file. this appears to be a path problem. the cobalt OS is a derivation of linux with some minor changes. thanks in advance ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
This is a bit off topic but...
How can I AUTOMATICALLY export an MS ACCESS table and its data using a proggie language such as VB or VC. I NEED TO DO THIS IN A PROGRAM: CLICK ON FILE - EXPORT IS NO HELP!! I don't want to use a module in the db because the user is going to be given a choice of any tables from any db. Are their any API calls that are relevant? Has anyone done anything like this before, and if so are their any links you could send me? I want a procedure that will work with ANY database, i.e. NO MODULES because the module is not guaranteed to exist in the database Is there an easy way to do this or are recordsets in VB the favorite? Eventually I want to add the data to a MySQL database of the users choice; but one step at a time. ALL input appreciated. Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What am I missing?
rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL too slow
On Thu, Jun 07, 2001 at 12:56:24PM +0500, Muhammad Asif wrote: i have MSAccess table with 1 records without any index i import same table in MySQL without any index When i access data from this table through ODBC in ColdFusion: Data from Access took 14 Sec and Data from MySQL took 24 Sec MySQL seems to be halfway back?? Does this the case realy?? Comments?? Index the data. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 80,941,079 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with perl
I've encountered this several times. When on the web I just use redirect
pages.
I'll submit the data to a page that puts the information into the database,
and then puts a header() call to redirect them to the real finishing page,
passing any minor variables I may need.
This way also has the unique ability that you can go back and forth in the
browser all you want (no back button woes).
- Original Message -
From: Pete Kuczynski [EMAIL PROTECTED]
To: MySQL Email List [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 8:32 AM
Subject: Re: MySQL with perl
I overcame this by adding to my php script, something that goves the
user the results, summerised, of what they added to the database, thus
when hitting refresh, it just refreshes the results of what the php
script returned, not what they submitted.
My php script is below.
Pete
html
body
?php
require(fedb.inc);
mysql_connect(localhost,$user,$password);
@mysql_select_db($db) or die( Unable to select database);
/*Insert into database */
mysql_query (INSERT INTO asset (site_id, hostname, device, model,
serial, ip,
dept, mhz, ram, hd_size, os_ver, status, data_port,
pp_port, hub_port,
digi_port, csmim_port, tprmim_port, xyplex_port,
comments, fe)
VALUES ('$site_id', '$hostname', '$device',
'$model', '$serial', '$ip',
'$dept', '$mhz', '$ram', '$hd_size',
'$os_ver', '$status',
'$data_port', '$pp_port', '$hub_port',
'$digi_port',
'$csmim_port', '$tprmim_port',
'$xyplex_port',
'$comments', '$fe')
);
print ($site_id);
print ( );
print ($hostname);
print ( );
print ($device);
print ( );
print ($model);
print ( );
print ($serial);
print ( );
print ($ip);
print ( );
print ($dept);
print ( );
print ($mhz);
print ( );
print ($ram);
print ( );
print ($hd_size);
print ( );
print ($os_ver);
print ( );
print ($status);
print ( );
print ($data_port);
print ( );
print ($pp_port);
print ( );
print ($hub_port);
print ( );
print ($digi_port);
print ( );
print ($csmim_port);
print ( );
print ($tprmim_port);
print ( );
print ($xyplex_port);
print ( );
print ($comments);
print ( );
print ($fe);
print ( );
print (p);
print (p);
print (Thanks for submitting your device.);
?
a href='index.html'bHome/b/a |
a href='searchform.html'bSearch Item/b/a |
a href='searchform_all.html'bSearch Site/b/a |
a href='updateform.html'bUpdate/b/a |
a href='deleteform.html'bDelete/b/a
/body
/html
Cindy wrote:
Dawn H writes:
I've written a couple of scripts and have a thing that I haven't quite
figured out. If anyone can shed light on this, I'd appreciate it.
When a person submits a form that inserts a record into the database,
if
they then refresh the page that comes up after the submit, the record
will
be submitted a second time. I suppose this is due to the fact that
the
subroutine that is called with the submit contains both the write to
database bit and the view bit. So refreshing causes a repeat of both
items.
How can I do this without that problem?
I was finally forced to add a check that there wasn't already an
identical record (using a minimum comparison set of fields) before
inserting the record. There really isn't any way to prevent dingbats
from refreshing, so... I CYA by emailing a copy of the record/element
values to myself when I refuse to add it in, but I havne't had any
spurious refusals so far.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try:
DuBois's book's scripts - where to get them?
I have the book, are the little scripts in the book available online? I went to the book's site at http://newriders.com/books/title.cfm?isbn=0735709211 which sent me to the author site at http://www.mysql.com/Contrib/Examples/ but gets the no permission error You don't have permission to access /pub/mirrors/mysql/Downloads/Contrib/Examples/ on this server. Any other place to get them from? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New To mySQL
I agree. The online manual is wonderful: http://www.mysql.com/ ...and the book by Paul Dubois is fabulous: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=991937746/sr=2-1/ref=aps_sr_b_1_1/107-9361976-5006147 These two resources will have you up in no time. A little reading will get you a long way. Rob Hasan Niyaz wrote: Start with the manual - Original Message - From: Geoffrey Van Nuffelen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 5:34 PM Subject: New To mySQL Hi all, I am a new user of mysql DB. I am working with WN NT 4. I already downloaded the mysql binary package for window. I installed it. But, now I don't know where to begin. How to start the DB. Please, I would like to have some ways to begin. Thanks, Geoffrey... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql daemon aborting abnormally (rh linux 6.2)
At 11:43 AM 6/7/2001 -0400, Duane Douglas wrote:
At 02:44 PM 6/7/2001 +0800, Rolf Hopkins wrote:
Sure it hasn't already started? Do ps -ef | grep mysqld to find out.
i resolved this issue. please disregard.
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dealing with datetime
Hi, Just working here on a php-mysql project and came to a weird problem, See this: mysql_query(UPDATE trackvisits SET hitcount=hitcount+1,refreshtime=now(),lastlength=now()-arrivetime WHERE username='$visitor'); Especially notice the lastlength=now()-arrivetime . Both lastlength and arrivetime are datetime fields, so at least in theory this query should update the lastlength field and set it to the right value (=now()-arrivetime), but it actually just sets the lastlength value to -00-00 00:00:00 . The arrivetime does have just a bit smaller value than now(), at least some minutes. Any idea why this might not work? Thanks Siim EInfeldt Itpunk music Web www.itmusicweb.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[OT] Javascript Manual
Hi, I know this is off topic but does anyone here know of a good manual website which shows Javascript from A-Z (like the PHP-manual and MySQL-manual). I know of a lot of java-code sites but none of them show the basic thought, syntaxes etc. - so can anyone pin-point me? Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage:www.sed.is -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problems installing on Solaris 2.6
hi. rtfm. http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#So laris -ravi. -Original Message- From: Aaron Williamson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 3:06 PM To: [EMAIL PROTECTED] Subject: Problems installing on Solaris 2.6 I'm sure this has been beat into the ground here, but I've nowhere else to turn. When running ./configure --prefix=/usr/local/mysql I get the following error: configure: error: can not run test program while cross compiling Can anyone explain to me how to get around this? Thanks, Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow Query... Good indexes...
Dear Sirs, We have a very large database (badge_history has 4,000,000 rows) and the explain for our query looks like this: By using indexes for a query, the product of the row estimates from an explain statement are less than 200,000. The problem is that this query times out. There is only one table being scanned, the primary keys are being used on the rest of the tables. This is running on a machine with 2 8XX processors and almost a gigibyte of ram. Can anyone explain why this query is not working? The Query: SELECT DISTINCT badge_history.xact_date AS xact_date, badge_history.xact_time AS xact_time, badge_history.last_name AS last_name, badge_history.bid AS bid, badgests.cond_desc AS status, department.description AS department, badge_history.reader_desc AS reader_desc, area.description AS area, badge.expired_date AS expired, badge_history.xact_type AS xact_type, badge_history.tzcorr AS tzcorr FROM badge_history, badge, badgests, department, area LEFT JOIN smccm_user_vs_permitted_department ON badge_history.dept = smccm_user_vs_permitted_department.permitted_department WHERE smccm_user_vs_permitted_department.smccm_user = '1' AND badge_history.dept = department.id AND badge_history.area = area.id AND badge_history.status = badgests.id AND badge_history.source_host = area.source_host AND badge_history.bid = badge.bid This should not take 20 minutes to run, any ideas on how to speed it up? The indexes are about optimal (I think) Mysql version: 3.23.36 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select query
What do I do wrong? The query result is not supposed to be an empty set (please cc your response to [EMAIL PROTECTED]) mysql select sequence_id, mol_wt from sequence_protein limit 1; +-+--+ | sequence_id | mol_wt | +-+--+ | 100368 | 53211.62 | +-+--+ 1 row in set (0.02 sec) mysql select distinct sequence_id from sequence_protein - where mol_wt=53211.62; Empty set (0.12 sec) mysql describe sequence_protein; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | sequence_id | int(10) unsigned | | PRI | 0 | | | length | int(10) unsigned | | | 0 | | | mol_wt | float(10,2) | YES | | 0.00| | +-+--+--+-+-+---+ Thank you Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: encrypt wierdness
On Thu, 7 Jun 2001, Richard Ellerbrock wrote:
Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
without specifying a salt yields random results:
mysql select encrypt('qwerty');
+---+
| encrypt('qwerty') |
+---+
| V/3Wzqmp93fts |
+---+
1 row in set (0.00 sec)
mysql select encrypt('qwerty');
+---+
| encrypt('qwerty') |
+---+
| W/55RyU1LdYN6 |
+---+
1 row in set (0.00 sec)
How is this useful? Looking at the C crypt manpage, you MUST specify a salt:
char *crypt(const char *key, const char *salt);
So where does mysql get its salt from? Is it a random salt? This confused the hell
our of me for around an hour!
You should look MySQL manual not C crypt manpage ;). And yes, thisis
random salt and makes life little bit more secure.
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
/_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New To mySQL
Hello Geoffrey, Thursday, June 07, 2001, 3:34:32 PM, you wrote: GVN Hi all, GVN I am a new user of mysql DB. GVN I am working with WN NT 4. GVN I already downloaded the mysql binary package for window. GVN I installed it. GVN But, now I don\'t know where to begin. How to start the DB. GVN Please, I would like to have some ways to begin. GVN Thanks, GVN Geoffrey... First of all read the manual (...\\mysql\\Docs\\manual_toc.html). The manual contains all the information you need. I began to use mysql not long ago. I spent an hour on reading manual and it was worth it. Run mysqld-nt.exe and mysql.exe with --help pparameter. It\'s very simple to start mysqld-nt (mysql server) in console or as a service. Run mysql.exe. To create a database use CREATE db_name; The open the database: USE db_name; To create a table in the database see chapter about CREATE TABLE. And so on. If you\'re familiar with SQL it\'s gonna be easy for you to use mysql. To run any SQL query just type it and press Enter. In any case look through the manual then try it yourself. And if there is a problem write a message to this mailing list. If you want to use mysql databases with some other clients (for example PHP), read manual for that client (for PHP http://www.php.net/manual/en/ref.mysql.php). -- Best regards, Olexandrmailto:[EMAIL PROTECTED] = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = ôÙ ÔÏÖÅ ÍÏÖÅÛØ ÚÁ×ÅÓÔÉ ÓÅÂÅ ÐÏÞÔÏ×ÙÊ ÑÝÉË ÎÁ http://www.mail-in.net/ mail-in.net - ÎÁÉÂÏÌÅÅ ÐÏÌÎÏÆÕÎËÃÉÏÎÁÌØÎÁÑ ÐÏÞÔÏ×ÁÑ ÓÌÕÖÂÁ × óÅÔÉ = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: parse error in config.inc.php3 on line 1 in phpMyAdmin
Barry C. Hawkins wrote: Esteemed colleagues, The php list is down, and I am sure someone knows what to do about this in this list. The issue is that I receive the error Parse error: parse error in config.inc.php3 on line 1 upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on the same Linux box running Apache 1.36. Line 1 reads as follows: $cfgServers[1]['host'] = 'localhost'; // MySQL hostname I have tried 'localhost', '127.0.0.1', and 'hostname.com' (name provided by ISP who seems fairly clueless). What painfully obvious thing am I overlooking? The name of the server is not the issue. Chances are good that there is a syntax error in a line above the spot where config.inc.php3 is included. Try including a different file and seeing if you get the same error. --zak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems installing on Solaris 2.6
I'm sure this has been beat into the ground here, but I've nowhere else to turn. When running ./configure --prefix=/usr/local/mysql I get the following error: configure: error: can not run test program while cross compiling Can anyone explain to me how to get around this? Thanks, Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql: java vs. php
Here's a left-field question: Does there happen to be a compelling reason for me to look into php when using a MySQL database rather than my current Java usage. I know the easy answer would be that if I know java, then stay with javait's a more versatile language, and so on. But, are there things that can be done with php+MySQL that I can't do (maybe as easily) with Java+MySQL? I ask only because I see on the internet, in magazineseverywhere the combo of php and MySQL being discussed. For example, when coding to an Oracle database, it is a huge benefit to me to use Java (rather than say VB) due to the intergration of Java and Oracle. Is there anything like that going on with php+MySQL? Thanks, Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems getting asp to talk to mysql
At 05:46 PM 6/7/2001 +0100, michael.mansfield wrote: my isp olm.net are not helping. what needs to be installed on a unix server to enable an asp page to talk to mysql please. OK: is the ASP running on Unix as well? Who's flavor ASP is it? ChiliSoft? -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services:Sun/Solaris, Linux, Perl, Perl/CGI, mod_perl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update log
Hi, I'm using version 3.22.32 on RH6.2. When I run show variables it indicates that log_update is ON, which is what I want. The datadir is /var/lib/mysql. I have not done anything to change the name of the file, and according to the documentation, it should be in the datadir. For the life of me, I cannot find the update log! I've even run a find on the entire machine. Any ideas as to where it may be or why it did not get generated? The error log shows nothing unusual. Thanks! Paul * Paul H. BernThe only thing worse than Data and Statistical Services not getting what you wanted Princeton Universityis getting what you asked for (609) 258-6053 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored procedures (really sorry for bringing this up)
Hi John and Sinisa,
I don't know if this helps but we are using php scripts in place of
stored procedures. Our client/server apps open up an https or http
connection to a php server and pass in the script name and variables
in the URL (like cgi). It's not stored procedures, but is pretty
fast if apache/php is on the same server or a fast ethernet cable away
and using https can be very secure as well. We currently use it to
get around things like multiple sql commands in one request and table
to table updates as it allows the client to execute an SQL procedure
remotely.
Hope this helps someone!
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 7:54 AM
Subject: Re: Stored procedures (really sorry for bringing this up)
John N S Gill writes:
The company I work for has been considering moving a key database
from
MS Access to a proper database.
We use linux for a lot of the number crunching we do and I was
keen for
us to choose MySQL. I happen to think it would be ideal for our
applications.
Unfortunately, those with the task of converting the application
consider stored procedures to be essential. I'm not at all
convinced
they are necessary (at least in the short term). I fear the
arguement
is already lost.. but...
I saw from the survey that is currently being done that stored
procedures are one feature that appears to be in active
consideration,
but I see from the TODO list that they are only in the to be done
sometime category.
So the questions are:
any idea how long it will be before something is in place? would
funding change this?
can also offer some help with the coding (have solid C/C++ but
no experience with MySQL itself)
John Gill.
Hi!
We have plans of implementing stored procedures until the end of
this
year, but if it is too far away for you , you can try doing it
yourself.
If you have problems, post your mails to [EMAIL PROTECTED]
Regards,
Sinisa
For technical support contracts, goto http://order.mysql.com
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can i keep a connection to the database open
At 07:05 PM 6/7/2001 +0530, Harsh wrote: i want to write a web-based chat application in Perl which runs on Unix server with mySQL as backend. The application needs to continouly interact with database hence instead of opening a DBI connection in each perl page, I wish to keep a live open connection with database. Is it possible ? If yes, how ? What web server are you using? -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Schooner Technology ConsultingCELL: (732) 539-7920 Unix Professional Services:Sun/Solaris, Linux, Perl, Perl/CGI, mod_perl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please can you help me find the right file to download
There is no full blown graphical version of the database itself. You still need to download the normal version itself and then download a graphical front end for administration. The main software you need can be found at http://www.mysql.com/downloads/mysql-3.23.html and the graphical interface at http://www.mysql.com/downloads/gui-clients.html And sorry, no, I can't tell you how to install it. Well... I can but not as good as what the manual can. - Original Message - From: Stephen Calvert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 22:41 Subject: Please can you help me find the right file to download I am after a version of MySQL with a graphical interface. I don't know which files to download or what to do with them once downloaded. I am keen to try out mysql but I am having difficulty understanding what to do with the downloas I have. Is there any chance you can email me the links to the files along with a brief overview of installing and configuring the software for use on my PC. I am running Winnt 4.0 Server. I would appriciate any help you can give. Best Regards Stephen _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOIN to the same table multiple times
### Creating a Telephone / Information Directory with MySQL / PHP3 People belong to a department a site. Need to be able to: List all people List all people within a Department List all people within a site List all people within a Department Site Have set up Department table with site1, site2 site3 as the same department exists in multiple sites. When listing a site, I need to JOIN the site table multiple times to get the site name. SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey - Works no worries SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey LEFT JOIN Site ON Site2=Sitekey - Error 1066: Not unique table/alias 'Site' SELECT * FROM Department LEFT JOIN Site ON Site1=Sitekey LEFT JOIN Site AS Sitetable ON Site2=Sitekey - Error 1052: Column 'Sitekey' in on clause is ambiguos ### rpm -qa | grep SQL MySQL-3.23.33-1 MySQL-client-3.23.33-1 MySQL-devel-3.23.33-1 rpm -qa | grep sql php-mysql-3.0.16-2bc perl-Msql-Mysql-modules-1.2210-2 ### People Table Surname Firstname Department site Department Table Name Site1 site2 site3 Site Table Sitekey Sitename ### - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installation problem
Is this a new installation? Then the -p option is not required. -p is only used once you have set the initial password. - Original Message - From: Michela Robustelli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 23:20 Subject: installation problem i've tried to install mysql version 3.23.3 for linux, but I get always the error message if I try to connect to bd: for example /mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' michela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update phone inner join tmpphone....
I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This does work in MSSqlServer 7. Is this syntax (or something like it) supported by MySQL?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Pound (£) Symbol and MySQL
Check for a call to htmlentities() in the PHP code. That is probably the cause of the behavior. --zak - Original Message - From: technical Support [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:52 PM Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cant connect
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92 I am sure that all information is correct as far DB name user name and password any ideals
Re: Chroot problems
On Thu, Jun 07, 2001 at 04:56:12PM -0700, Kyle Hayes wrote: One of the problems I had when running MySQL in a chroot jail was that the /etc/passwd, /etc/shadow etc. had to be correct in the jail. However, I don't think I am running it in the same configuration that you use. See below. That's one of the things the patch I'm sitting on should fix. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 13 days, processed 82,934,708 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What am I missing?
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help required for OLEDB on win32 for MySQL(linux)
At 20:56 07/06/2001 +0530, asit wrote: Hi, Please take a look on the help file, where you should find that your connection string is wrong. You find the instructions of the connection string just below of Overview item. server=192.168.100.101 ? Regards, Miguel Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in VB MySQL server is on 192.168.100.101 and database is Test . This is allowed to be connected from any IP and any user Private Sub Form_Load() Dim dcncentral As ADODB.Connection Set dcncentral = New ADODB.Connection Dim str1$ str1 = Provider=MySQLProv;Data Source=192.168.100.101;DB=Test dcncentral.Open str1- Giving Catastrophic Error End Sub This function is not opening the database and giving Catastrophic Error. What should be the connection string for database ? Please help. Kindly note that I want to connect to MYSQL database without a DSN Thanks in Advance Asit Saha -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing, following directions, discovering problems.
First off I want to thank anyone who helps. I know helping new people trying to install can be a pain but I'll try and cooperate. I installed Redhat 7.0 with the mySQL packages. I read that there were patches for the mySQL install on Redhat so I downloaded the RPM for the version I had mysqlclient9-3.23.22-3.i386.rpm and it installed fine. It still didn't solve the problem. I created the database with mysql_install_db and that went fine. When I try and start the server with safe_mysql I get.. Starting mysqld daemon with databases from /var/lib/mysql 010606 09:59:25 mysqld ended ... so it dies immediately. I check the /var/lib/mysql/mymachine.name.err file (real host name appears, not mymachine.name) and see 010606 09:59:25 mysqld started 010606 9:59:25 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010606 09:59:25 mysqld ended so I check the defaults of mysqld with --help and see, basedir: /usr/ datadir: /var/lib/mysql/ snip Unix socket: /var/lib/mysql/mysql.sock so it should be looking for /var/lib/mysql/./mysql/host.frm # ls /var/lib/mysql/./mysql/host.frm /var/lib/mysql/./mysql/host.frm so it seems to be looking in the right place AND the file exists. So I try this.. # /usr/libexec/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 010606 10:15:41 Aborting So I drop back to a regular user and get... $ /usr/libexec/mysqld /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 010606 10:15:52 Aborting is this a permissions problem on that directory? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
