Shared library Compiling error

Hi, I'm trying to compile my own mysql client program under solaris 9 without luck. I have the mysql libraries under : /usr/local/mysql-standard-4.0.20-sun-solaris2.9-sparc/lib and has the following files: libdbug.a libmysqlclient.a libmysqld.a libmysys.a libmygcc.a libmysqlclient_r.a Don't I nee

compile c code with mysql calls?

I'm trying to compile c code with calls to mysql library (under win2000) and I get these linker errors. any idea why? I'm using nmake from the command line. Microsoft (R) Incremental Linker Version 6.00.8168 Copyright (C) Microsoft Corp 1992-1998. All rights reserved. codecin.obj : error LNK2001

mysql shared library.

Hi, I'm trying to access mysql shared library. mysql_init() function returns the address of MYSQL structure . I need to know what the structure looks like.? can all mysql structure parameters be configured in /etc/my.cfg ? Thanks --

replace

I have a table with two column; the first column contain unix timestamp(of type double ) which is the primary key. I would like to round the time. could I do : mysql> insert into mytbl(time) values(round(time)); should this work? Thanks Nissim -

sql command to examine blob data?

What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before posting

sql command to examine blob data?

What Mysql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before posting

delta between rows?

To Mysql Team how can I generate a list of deltas between columns in different rows for the entire table? what I need is an sql command that does something like this: for N =0 to i do : select "colA of current rowN" - "colA of pervious row(N-1)" from tab1; ColA = floating point number. Thanks

sql command to examine blob data?

What sql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before posting, p

deleting records?

Is there a way to delete records in a table by specifying row numbers. for example: delete from tbl1 where row > 900 and row <1000; Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

row count for multiple tables.

How do I retrieve the count for multiple tables with one sql command? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

multiple select with single command.

Are there plans for mysql to have the capabilities to execute single sql statement with nested SELECT . or Is there a way around this for the time being? Thanks - Before posting, please check: http://www.mysql.com/manual

Size of table's MYD file?

Why is it that when I delete records from a table in the database, the size of the table's MYD file does not get smaller. It's still the original size. Do I have to flush the table to get the accurate size? Thanks -------- Nissim Lugasy 216-433-2708 [EMAIL

sql command question

have an index field in my table and the table has no primary key for a good reason. Also, is this command possible? select count(*) from table1, table2; if it is, why can't I get the correct result: table1 has 337 records and table2 has 23860 records but the result is 8040820 instead. than

changing mysql prompt

MT:193/12:13:58] Mysql> is it possible? thanks ---- Nissim Lugasy 216-433-2708 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual