Symbol resolution failed for /usr/local/lib/libz.so.

Hi, Warm Greetings! I am using C & mysql for my program In AIX and while compiling I am getting the following error. “exec(): 0509-036 Cannot load program /az/smsbbs/bin/wittservw because of the following errors: 0509-130 Symbol resolution failed for /usr/local/lib/lib

How could write this sum string like SQL?

Mysql 4.1 also support this group_concat(). Thank you ! Shuming　Wang

View with Subselect for User ID

Hello MySQL experts, I am trying to create a view whose access is based on a User ID that need to be looked up in a different table. Here is an example of what I'm trying to do: CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `shared_v` AS select `Shared`.`ID` AS

RE: advice for blob tables?

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > I don't feel the implementation direction this article takes > is good. It uses single row binary storage, which anyone who > has had to deal with large files knows is a definate issue. > > Just wanted

Re: advice for blob tables?

I don't feel the implementation direction this article takes is good. It uses single row binary storage, which anyone who has had to deal with large files knows is a definate issue. On Sat, 21 Apr 2007, Kevin Waterson wrote: > This one time, at band camp, "Michael Higgins" <[EMAIL PROTECTED]>

Re: what kind of indices to set up

James, A lot depends on how many rows you are searching on. If you only have a couple thousand rows, then a table scan will still be fast. If you are searching more rows, say more than 10,000, then using the proper index will speed things up. Using a compound index is only useful if t

what kind of indices to set up

I have a table which will be searched via some of the fields in the column. An example of the list of searcheable columns: make model body_color tire_type hub_caps_type The thing is that people might do a search using one or many of the fields as criteria. For example someone might search

RE: Trouble connecting to server

Thanks for the idea, but I did get the right IP address on it. No DHCP. Drew Burchett United Systems & Software Ph:(270)527-3293 Fax: (270)527-3132 -Original Message- From: Barry Newton [mailto:[EMAIL PROTECTED] Sent: Monday, April 23, 2007 11:17 AM To: Drew Burchett Cc: mysql@lis

Re: Trouble connecting to server

At 11:36 AM 4/23/2007, Drew Burchett wrote: I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network,

Re: What is the equivalent of the minus function?

I would think that: SELECT email FROM participants WHERE email NOT IN (SELECT email FROM excluded) would do the trick andy > I am trying to do something like this > > select email from participants > minus > select email from excluded > > It seems there is no minus function in MySQL. I tried

Trouble connecting to server

I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network, but ever since then, I can only connect to mys

Query question

Guys, I have the following table that contains some information about a cars. I'm trying to write a query to determine: the number of make(name of car), number of models per make(name of car) and the average number of models/make(name of car) sold in a particular period. The two queries belo

Event Log Error

I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databases and tables. I am usi

How could write this sum string like SQL?

Hi, I want select item detials(date and qty) sum(qty) 'a01', '2007.01.01: 10/2007.02.03: 10',20 'a02', ' 2007.01.10: 20/2007.02.12: 30',50 'a03', ' 2007.01.18: 20', 20 from table2 date,item,qty 2007.0

Re: Mysql and disk space left

On 4/19/07, Manuel Vacelet <[EMAIL PROTECTED]> wrote: Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Hi everybody, Nobody can answer my question ? Or