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 need to have the libmysqlclient.so.10 file here too? on my system the libmysqlclient.so.10 is found under directory :/usr/local/openv/lib \ Should I move it /usr/lib instread? Here is what I tried and the errors I get: When the makefile has: #L LD=gcc -lm -lmysqlclient the error is : symbol mysql_init: referenced symbol not found - When the makefile has: #L LD=gcc -lm -Wl,r/usr/local/openv/lib -lmysqlclient the error is : ld: fatal: file r/usr/local/openv/lib: open failed: No such file or directory When the makefile has: #L LD=gcc -lm -L/usr/local/mysql-standard-4.0.20-sun-solaris2.9-sparc/lib -lmysqlclient the error is : symbol mysql_init: referenced symbol not found - any ideas to what I'm missing ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: unresolved external symbol _mysql_errno@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_init@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_close@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_free_result@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_affected_rows@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_field_count@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_fetch_lengths@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_fetch_row@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_num_rows@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_num_fields@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_store_result@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_real_query@12 codecin.obj : error LNK2001: unresolved external symbol _mysql_error@4 codecin.obj : error LNK2001: unresolved external symbol _mysql_real_connect@32 codecin.dll : fatal error LNK1120: 14 unresolved externals NMAKE : fatal error U1077: 'link' : return code '0x460' Stop. - 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 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 - 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
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 - 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
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, 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
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, 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
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, 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
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 - 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
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) 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
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 this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.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
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 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
sql command question
currently, to list the last 100 records in a table I use this sql command: select * from test order by T desc limit 100; Note: T is the name of a field in my table test . can I instead use record number or use the count function to get the same result? I don't 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. thanks Nissim Lugasy 216-433-2708 [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
changing mysql prompt
Hi , is there a way to change the default mysql prompt to have the current GMT time embedded in the mysql command line prompt and look something like this (and also have the time increase every time the carriage return is pressed) [GMT:193/12:13:45] Mysql [GMT:193/12:13:46] Mysql : : [GMT: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) 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