MySQL Proxy - Select Proxy On Auth

Hi, I have a situation where I need clients to connect to a proxy server and to then determine which MySQL server to forward their connection to based on the username supplied. Does anyone know if this is possible using mysql-proxy with Lua? Or by any other means? Thanks. REW

best way to query this table

have indexed the column, but i am wondering if i should create a couple of int columns that would be day of week, week of year and month and query against these instead. would love you opinions thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

help trying to add an autoincrement col to an exisiting table

Hello, currently i have the following table structure CREATE TABLE users ( uname varchar(20) NOT NULL default '', passwd varchar(15) NOT NULL default '', fname varchar(25) NOT NULL default '', lname varchar(40) NOT NULL default '', dir varchar(28) NOT NULL default '', pict varchar(50) NOT

Re: table hangs on a large query

On 8/14/06, Dan Buettner [EMAIL PROTECTED] wrote: Randy, it's possible your indexes are sadly out of date, or corrupted somehow. Can you post the output of EXPLAIN select * from gallery_object where dir = 'dirname'; as well as of EXPLAIN select * from gallery_object where parent_id = 1 and dir

Re: table hangs on a large query

in the previous message returned immediately Thanks Randy Randy, Then it could have been index corruption. You could do a back up of the table and then run a Repair Table on it (or MyISAMChk) and then Optimize it. See http://dev.mysql.com/doc/refman/5.0/en/repair.html Mike Mike

table hangs on a large query

Hello, I have a table (see below) that has 111599 records in it. When i do a query like select * from gallery_object where dir = 'dirname' this query takes a very long time and while the query is going on it locks the entire table so no one else can query it yet a query like select * from

Help with this query. How to do a group by on a datetime just the month/day/year

Hello, Not sure if i can do this. I have a table with a datetime column I would like to do group by a day of the month. if i do something like select count(*) from MTracking where mallarea=1001 group by timeofclick every one is listed because time. So is this possible? Thanks Randy

please help, can not delete database

. Do you really want to drop the 'billmax' database [y/N] y Database billmax dropped But it does not do anything. I have tried restarting the DB and restarting the box as well Please help Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

mysqldump question

to the old way of separate inserts for each row? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: looking for direction on how to debug this message

to see ? In the mysql variables. In 5 days I have 11885 aborted_clients. I assume this is probably pretty high? Thanks for any more help Randy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 3:27 PM To: mysql@lists.mysql.com Subject

Log file full of Got an error reading communication packets

Hello, My log file is getting filled with these. Can someone tell me what these mean? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication

RE: Log file full of Got an error reading communication packets

directory I have a file called millhouse.unitnet.com.err My main db is unitnet It appears this is a good link that I received from GLEB http://dev.mysql.com/doc/mysql/en/communication-errors.html I am going down that path right now Thanks Randy -Original Message- From: [EMAIL PROTECTED

looking for direction on how to debug this message

Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication

RE: (FIXED...)moving DB from one box to another.

Thanks for all your help FYI, I had to add this to the my.cfg set-variable= max_allowed_packet=16M Randy -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Re: moving DB from one box

Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

That part that confuses me is in the script /etc/rc.d/init.d/mysqld (I put in some debug echos to see where it is exiting) When I run the startup it print 2 But I am not failure with /usr/bin/my_print_defaults Thanks for any help! Randy ==SNIP

RE: moving DB from one box to another.

Sorry, When I do the mysql dbname oldbox.sql I get the error message It creates mysqldump dbname -h oldbox oldbox.sql fine Thanks -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:25 PM To: Randy Paries; [EMAIL PROTECTED] Subject

moving DB from one box to another.

hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox oldbox.sql then

Re: Alias query problem in 4.1.7?

doesn't act any differently no matter which way you do it. Randy Clamons Systems Programming Astro-auction.com Original Message From: Rhino [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Tue, Nov-23-2004 10:25 AM Subject: Re

Building new db linux box, Hardware questions

Hello, I am building a new linux box , just to be an mysql server I have a couple of questions. 1) would it be better to go brandnew with a single processor or like a quad p4 that's a year or two old. 2) I am going to running raid 5, so I assume that I should run scsi drives? 3) my database

Replication Issue

provide you with any other information? Thanks! Randy Here is output from Show Slave Status \G mysql show slave status \G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: localhost

RE: Replication Issue

Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can

RE: Replication Issue

Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue Randy

RE: Replication Issue

Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql

Re: MySQL v ASP problem

recently, but it seems likely that if you add the ,3,3 to the second rs.Open statement your app will behave properly. Randy Clamons Systems Programming Astro-auction.com Original Message From: J.R. Bullington [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED

RE: Long Running Queries

or UPDATE a single row. You might get better results from this list if you include your table structure and your queries along with your question. Randy Clamons Systems Programming Astro-auction.com Original Message From: Danny Willis [EMAIL PROTECTED] To: [EMAIL

Trying fulltext search

back, but if I try to do SELECT * FROM community_files WHERE MATCH (description) AGAINST ('bird' ); I get nothing back I am running mysqld Ver 3.23.58 on rh9 Thanks for any help Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Query help

to get these rows a group at a time? There is also could be where clauses Thanks for any direction Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Best practice question

question. 1)there will never be more than two columns 2)the majority of articles will only be one column Does a majority of two empty text fields out way the penalty of a join with a Column table Do empty text columns take up much room? Thanks for any help randy smime.p7s Description: S/MIME

Stupid newbie question - adding comments for columns tables?

Apologies for what is a pitifully simple question from someone who has just started using MySQL 4.0. I've looked in the documentation and elsewhere, but can't find the exact syntax for adding comments to columns when creating a table. My attempts at guessing the syntax so far have failed.

Trying to upgrade

not install everything? This is a working db Thanks for any suggestions Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

very simple query question

Hello i have a simple query select u.*,p.* from users u, profiles p where u.uname = p.uname and u.level != 0 Is there any tricks to make this use an index. If i do level=0 is uses an index , but != does not. -- MySQL General Mailing List For list archives:

question about number of processes.

Hello I have a number of servers. I have one running RH7.3 with mysql-3.23.56-1.73 one running RH9 with mysql-3.23.58-1.9 My question is when i do a ps -ef on RH7.3 a get a number of /usr/libexec/mysqld on RH9 i only get one. can someone please explain why. does RH9 display thread

Re: Passwords and ODBC - what am I missing

the switch by searching the MySQL documentation at their site. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Passwords and ODBC - what am I missing

Oh, and one other thing, you have to create the passwords AFTER you use the switch! That was probably obvious to you but it took me a while to figure out. Randy Randy Chrismon wrote: Ken Brown wrote: Just installed 4.1.1 on windows 2000 with current odbc layer Connects fine with root

Question on 2 different tables

one and Table 2 if the value in table one is not in table 2 then display the number to the screen? Can somebody show me what the sql statement would look like? Thanks Randy

Re: Question on 2 different tables

SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo) ; On Wed, 2004-01-21 at 15:26, Randy Johnson wrote: This example is simplified. I hope you understand Each table has one field called ID which is an integer and is the primary key Table 1 List

Null Values Foreign Keys

string... not the null \N. In fact, I'm not sure I can even change this Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lock Wait Timeout

on the one. There is nothing particularly unique or unusual about the one record if failed on except that it was one of the newer documents. Thanks for the thoughts. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Lock Wait Timeout

transactions which, I believe, releases any locks up to that point. I've increased lock_wait_timeout to 75 (what is a reasonable higher end limit for this?) but still get the error. I'm using v.4.0.16 on a RH 9.0 box. Any thoughts on what might be happening here? Thanks. Randy -- MySQL General Mailing List

Re: Lock Wait Timeout

. In addition, I had already updated 26,000 records so I can't figure out what's wrong with this one particular record. Any thoughts appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multiple Outer Joins

question is, how can this be done? Any and all help appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Possible MyODBC Bug?

with LotusScript so as to verify that I'm doing this right; but I have a strong suspicion that this is an ODBC issue. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Field Count Mismatch Using Code

? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Locking one table blocks others

of the connection object, etc. etc. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Blocking One Table Blocks Others

Randy Chrismon wrote: Kim G. Pedersen wrote: BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? This raises an interesting question. I wrote earlier about troubles with mismatch field count and missing field errors. I

How to query

in one query and to order by the 10 or so products I'm interested in. MySQL is 4.0.12. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to query

. Any help would be appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

My Company DB Wars

on the AS400? Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Find non-unique values

, or web site devoted to SQL questions -- particularly the dialect of SQL spoken by MySQL? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Update Syntax

clause on the end of the update. Am I right that I can't do this?? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Failed Red Hat 9 Dependencies

. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What provides libmysqlclient.so?

I'm trying to upgrade my KDE setup but it fails on a dependency for libmysqlclient.so. I've looked at all the MySQL rpm files and none of them seem to provide this file. Does anyone know where this one comes from? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: What provides libmysqlclient.so?

Jeremy Zawodny wrote: On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote: I'm trying to upgrade my KDE setup but it fails on a dependency for libmysqlclient.so. I've looked at all the MySQL rpm files and none of them seem to provide this file. Does anyone know where this one

Connection Time Out

. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connection Time Out

frequent server gone away errors. At the same time, using the console on my laptop but accessing the very same MySQL server over the network, I have no such problems. That seems precisely bass-ackwards to me! ;-) Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Disable/Enable Keys and Duplicate Records

I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table my_table disable keys. Import 200K records. Alter table my_table enable keys. But it turns out there are duplicate records. Does MySQL

Re: deleting rows which table1.row=table2.row

[EMAIL PROTECTED] wrote: how to delete rows which table1.field=table2.field thanks delete t1 from t1,t2 where t1.field=t2.field at least, that's how I read the manual. Works for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Adding space to /var/lib/mysql

/mysql to it then permanently mount it as /var/lib/mysql? Or is MySQL somehow going to know that the /var/lib/mysql it's looking at now isn't the one it was looking at an hour ago? Of course, I would have mysql shut down while I pull these shenanigans. Thanks. Randy -- MySQL General Mailing List

Error Cant get stat

Tried to do a load of data from a file in my home directory on Linux. Got this message: ERROR 13: Can't get stat of '/home/rchrismon/mysql/ArchiveEC02-Invoices.txt' (Errcode: 13) What does this mean and what can I do about it? Thanks Randy -- MySQL General Mailing List For list archives: http

MyIsam v. InnoDB and other questions

by copying the subdir and changing the path in my.cnf? (I forget what the my.cnf option is, but I'll find it.) Somehow, that sounds too easy... Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lotus Notes/Domino Access MySQL DB

I've been searching the Lotus site and have gotten kind of lost. Does anybody have any experience using Lotus Notes as a front end to a MySQL database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I barking up the wrong tree? Thanks. Randy -- MySQL General Mailing List For list

Unmet Dependency Hell

I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use --force (or is it --nodeps, I can never remember) because MySQL wants libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question (coming from that other world) why aren't these dependencies 0.9.6, or greater, instead of being

MyIsam or InnoDB? (WARNING -- LONG MSG)

, that is the question. Thanks and apologies again for the long post. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Good SQL Cookbook

that if I send it all to an outfile, I have a readable report? This is just an example of the kinds of things I'd like to be able to get a handle on through some sort of reference. Thanks, Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Select statement to get the difference

I need to know which id is not present in the other table. Stefan: A left join should do it: select t1.id from t1 left join t2 on t1.id=t2.id where t2.id is null I learned this from this mailing list about two weeks ago. HTH. Randy -- MySQL General Mailing List For list archives: http

I need to know which id is not present in the other table.

and to the remote 4.0.15 database WITHOUT using --protocol=TCP. I CANNOT connect the command line to the remote 4.1.0 database without using --protocol=TCP. Passwords are required for root and user IDs in all cases. Very strange. Randy -- MySQL General Mailing List For list archives: http

Re: Wrong Thread: (sorry) I need to know which id is not present in the other table.

Response should have been to problem connecting to 4.1.0 Sorry about that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't Access DB from MySQLCC

4.0.15 database. Trying to connect to the 4.1.0 database yields the same upgrade-your-client error message I get with the command line if I leave off the ---protocol=TCP option. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Composit Key - Is it possible, and if so, what is the syntax?

Try taking out the identifier name for the primary key (pk_foo). The way I read the documentation, MySQL does not support identifiers or names for primary keys although it does for other index types. HTH Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Can't Access DB from MySQLCC

This irritating rather than life-threatening: I can connect to the MySQL database on my Linux box, from my Win2K box, using the command line environment just fine: c:mysql --protocol=TCP -h host_name -u my_name -p mysql No matter what I try, however, I can't connect using MySQLCC. I always get

Re: Can't Access DB from MySQLCC

which also happens to be a 4.0.15 setup on a Win2K desktop. So, I guess it's one of those things where it's both fish and fowl. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow Deletes

-- although show index says it was. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Structuring a Load File

field? Do I include a first field with \N? If the MySQL table has 20 columns with the first being the autoincrement, can my load file be only 19 columns? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Connect to 4.1 using MyOBDC

, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connect to 4.1 using MyOBDC

. Is their an environment variable that would do this? This is starting to make me look bad... Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Load Takes Too Long?

I just loaded about 125,000 records, each containing about 30 columns into an empty, newly created, mysql table. It took 56 minutes. Isn't that a little long? The table design was driven, in part, by an existing reporting application. The data to populate the table is being exported from Lotus

Re: Can't Show Warnings

For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Can't Show Warnings

: 16374 Deleted: 0 Skipped: 0 Warnings: 69 mysql show warnings; Empty set (0.00 sec) What am I doing wrong that I can't find out what the 69 warnings are? I'm using 4.1.0 alpha. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: LOAD Fails on Lost Connection

of data to the list or directly to Egor? Thanks for the help. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Grant to Partially Specified Host

I have several machines and wander from office to office as part of the job. As I read the MySQL docs, I have two choices for granting privileges: grant ... to randy@'%' or grant ... to [EMAIL PROTECTED] The first form is too vulnerable for the folks around here. The second form is too

Re Does NULL == ?

contain as a value? Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD Fails on Lost Connection

-leading. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Does NULL == ?

a field with NULL in it and a field with a zero-length () string in it. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does Null == ?

NULL. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Lotus Notes/Script...

haven't had time to figure out how to get one system to talk to the other. HTH. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

LOAD Fails on Lost Connection

I'm having a hard time believing it's a connection time-out. Any thoughts? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Fwd: MySQL 4.1 Script Shut Down Issues]

---BeginMessage--- After installing MySQL 4.1 on a Win2K machine, I tried to run the mysql_fix_privilege_tables.sql script. I got the duplicate column name errors which the documentation says I can safely ignore. However, I also got this error: ERROR 1064 at line 67: You have an error in your SQL

MySQL 4.1 Script Shut Down Issues

After installing MySQL 4.1 on a Win2K machine, I tried to run the mysql_fix_privilege_tables.sql script. I got the duplicate column name errors which the documentation says I can safely ignore. However, I also got this error: ERROR 1064 at line 67: You have an error in your SQL syntax. Check the

Re: insert hang problem on Solaris 8

It looks like my MYI file was seriously corrupted, beyond myisamchk being able to do a thing with it. Has anyone seen this before on Solaris 8? Fortunately the data was trashable but when this hits production it wont always be. Thanks.. Randy On Wed, 2003-06-18 at 21:46, Nils Valentin wrote

insert hang problem on Solaris 8

software was built with gcc 3.2.2, again, on solaris 8. If anyone's got any suggestions let me know! Thanks! Unfortunately I'm gonna have to restart this sooner than later. :/ -Randy Swiss American Securities Inc. MMS sasiny.com made the following annotations on 06/18/03 10:04:42

ODBC performance vs....

' ODBC performance? It's possible that I might get better performance by turning off logging, which I'll try Monday, but I doubt it. I assume that the preferred C++ interface to MySQL is not built on top of ODBC, and thus has much better performance. Is this correct? Many thanks! Randy T. Merkel

Re: i almost hate queires, please help!!!

is the first example project name | primary name | alternate name .all on the same row. Is this achieved by an outer join? If so, can somone give me a syntax example or point me to some good reading online? - Original Message - From: David Gilmour [EMAIL PROTECTED] To: Randy

i almost hate queires, please help!!!

here's my table syntax: create table Projects ( PjID int unsigned auto_increment not null primary key, PjNumber varchar(40) not null, PjName tinytext not null, PjDesc tinytext, PJEcd varchar(30), PJCost varchar(30), LastUpdate char(30) ); create table Managers ( MgrID int

mysql access via php function, hlp with syntax

Can someone please tell me what is wrong with this function? I can't for the life of me see an error. But, for some reason I keep getting the following error: PARSE ERROR: parse error, unexpected $ in d:\web.root\xx_db\inc\functions1.inc on line 28 function is: function dtb_qry_tbl_dsp($qry,

help displaying results from a mysql query with php

Can someone please tell me what's wrong with the following code? This info is inside a function that I defined. One of the arguments that I pass the function is the actual query. Based on the info that I know is loaded in the database (it's a development database...there are only 2 rows of

RE: how do you define a relationship?

Unfortunately this goes well beyond the scope of my original question. Although the inputs that you all have provided thus far have been a very good read, I still don't grasp the concept of defining a relationship. Is it simply referring to a primary key in a field other than the one where the

how do you define a relationship?

I think I've firmed my theoritical understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director

Re: mysql_install_db script: can't find it

Thanks to those who replied. It wasn't clear to me that that was the case, based on the docs. I'll submit a doc change request to make sure that's more clear to the next person. Gracias, Randy - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

content design / database design help

I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My office currently keeps track of our projects via an excel spreadsheet. We keep such info as project costing, status, points oif contact, name, description, number, last updated, etc... What I want to do is merge all that

RE: Connecting to MySQL on Linux from a Windows machine.

Will, Do you have a user/host pair for the client in the user table within the mysql database?? It's not good enough just to have a user, the host has to be setup too. I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different

  1   2   >