|
 |
| Recent blog posts: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Sunday, 14 January 2007
|
| mysql odbc Ritchie DeComa 13:57:20 |
| | I have installed the mysql 3.51 odbc, tested the connection by pressing the
test button - and it gives me "success; connection was made". Unfortunately,
when I go to Access 2000 and link through the ODBC, it doesn't give me any
errors; instead, it just doesn't give me the list of tables[which is only
the two I have created] and returns to Access like nothing took place . What
am I missing? I did run the tracer, but I can't read all the jarble.
I've provided you with the "jarble" because you have more experience:
MSACCESS 75c-1f0ENTER SQLAllocEnv
HENV * 0012C77C
MSACCESS 75c-1f0EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x0012C77C ( 0x079f1540)
MSACCESS 75c-1f0ENTER SQLAllocConnect
HENV 079F1540
HDBC * 0012C88C
MSACCESS 75c-1f0EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 079F1540
HDBC * 0x0012C88C ( 0x079f15e8)
MSACCESS 75c-1f0ENTER SQLSetConnectOption
HDBC 079F15E8
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
MSACCESS 75c-1f0EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 079F15E8
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
MSACCESS 75c-1f0ENTER SQLSetConnectAttrW
SQLHDBC 079F15E8
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
MSACCESS 75c-1f0EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 079F15E8
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
MSACCESS 75c-1f0ENTER SQLDriverConnectW
HDBC 079F15E8
HWND 001A03BE
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
MSACCESS 75c-1f0EXIT SQLDriverConnectW with return code 0
(SQL_SUCCESS)
HDBC 079F15E8
HWND 001A03BE
WCHAR * 0x1F7A9D2C [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7A9D2C
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x0012C8B0
SWORD 2
SWORD * 0x0012C8A8
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 9 <SQL_ODBC_API_CONFORMANCE>
PTR 0x0012C8B0 (1)
SWORD 2
SWORD * 0x0012C8A8 (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012C7C0
SWORD 200
SWORD * 0x0012C8A8
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x0012C7C0 [ 26] "libmyodbc3.so"
SWORD 200
SWORD * 0x0012C8A8 (26)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C78A
SWORD 2
SWORD * 0x0012C35C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C78A (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0293D550
SWORD 2
SWORD * 0x0012C35C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0293D550 (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0293D552
SWORD 2
SWORD * 0x0012C35C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0293D552 (2)
SWORD 2
SWORD * 0x0012C35C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012C790
SWORD 2
SWORD * 0x0012C776
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 1 <SQL_ACTIVE_STATEMENTS>
PTR 0x0012C790 (0)
SWORD 2
SWORD * 0x0012C776 (2)
MSACCESS 75c-1f0ENTER SQLAllocStmt
HDBC 079F15E8
HSTMT * 0012C354
MSACCESS 75c-1f0EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
HSTMT * 0x0012C354 ( 0x079f18d8)
MSACCESS 75c-1f0ENTER SQLGetStmtOption
HSTMT 079F18D8
UWORD 0
PTR 0x0012C300
MSACCESS 75c-1f0EXIT SQLGetStmtOption with return code 0
(SQL_SUCCESS)
HSTMT 079F18D8
UWORD 0
PTR 0x0012C300
MSACCESS 75c-1f0ENTER SQLSetStmtOption
HSTMT 079F18D8
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C
MSACCESS 75c-1f0EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
HSTMT 079F18D8
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)
MSACCESS 75c-1f0ENTER SQLExecDirectW
HSTMT 079F18D8
WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM
MSysConf\ 0"
SDWORD -3
MSACCESS 75c-1f0EXIT SQLExecDirectW with return code -1
(SQL_ERROR)
HSTMT 079F18D8
WCHAR * 0x1B074AA0 [ -3] "SELECT Config, nValue FROM
MSysConf\ 0"
SDWORD -3
DIAG [S0002] [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Table
'database01.msysconf' doesn't exist (1146)
MSACCESS 75c-1f0ENTER SQLErrorW
HENV 079F1540
HDBC 079F15E8
HSTMT 079F18D8
WCHAR * 0x0012C294 (NYI)
SDWORD * 0x0012C2E0
WCHAR * 0x02941528
SWORD 4095
SWORD * 0x0012C2CC
MSACCESS 75c-1f0EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 079F1540
HDBC 079F15E8
HSTMT 079F18D8
WCHAR * 0x0012C294 (NYI)
SDWORD * 0x0012C2E0 (1146)
WCHAR * 0x02941528 [ 94] "[MySQL][ODBC 3.51
Driver][mysqld-5.0.27-community-nt]Table 'database01.msysconf' doesn't
exist"
SWORD 4095
SWORD * 0x0012C2CC (94)
MSACCESS 75c-1f0ENTER SQLErrorW
HENV 079F1540
HDBC 079F15E8
HSTMT 079F18D8
WCHAR * 0x0012C294 (NYI)
SDWORD * 0x0012C2E0
WCHAR * 0x029415FC
SWORD 3989
SWORD * 0x0012C2CC
MSACCESS 75c-1f0EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 079F1540
HDBC 079F15E8
HSTMT 079F18D8
WCHAR * 0x0012C294 (NYI)
SDWORD * 0x0012C2E0
WCHAR * 0x029415FC
SWORD 3989
SWORD * 0x0012C2CC
MSACCESS 75c-1f0ENTER SQLFreeStmt
HSTMT 079F18D8
UWORD 1 <SQL_DROP>
MSACCESS 75c-1f0EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 079F18D8
UWORD 1 <SQL_DROP>
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0012C790
SWORD 200
SWORD * 0x0012C85A
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0012C790 [ 10] "MySQL"
SWORD 200
SWORD * 0x0012C85A (10)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 0 <SQL_ACTIVE_CONNECTIONS>
PTR 0x0012C89E
SWORD 2
SWORD * 0x0012C8AC
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 0 <SQL_ACTIVE_CONNECTIONS>
PTR 0x0012C89E (0)
SWORD 2
SWORD * 0x0012C8AC (4)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>
PTR 0x0012C884 [ 2] "N"
SWORD 20
SWORD * 0x0012C8AC (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C89C
SWORD 2
SWORD * 0x0012C86C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 46 <SQL_TXN_CAPABLE>
PTR 0x0012C89C (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012C898
SWORD 2
SWORD * 0x0012C86C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
PTR 0x0012C898 (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012C89A
SWORD 2
SWORD * 0x0012C86C
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
PTR 0x0012C89A (2)
SWORD 2
SWORD * 0x0012C86C (2)
MSACCESS 75c-1f0ENTER SQLGetInfoW
HDBC 079F15E8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x0012C884
SWORD 20
SWORD * 0x0012C8AC
MSACCESS 75c-1f0EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 079F15E8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x0012C884 [ 2] "`"
SWORD 20
SWORD * 0x0012C8AC (2)
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| |  6 answers | Add comment |
Saturday, 13 January 2007
|
| Selecting records based on max and value David Ruggles 07:00:47 |
| | I'm new to this list, but have searched through the archives and haven't
found anything that addresses my question.
First a little background:
I'm creating a supply ordering system. Each supply order may be modified
many times before being approved and finally filled.
I created the following databases:
Supplyorder
uiddouble (auto) (pk)
sitedouble
datedate
Supplyorderhistory
uiddouble (auto) (pk)
supplyorderuiddouble
statusdouble
Supplyorderlineitems
uiddouble (auto) (pk)
supplyorderhistoryuiddouble
other fields ...
Each time an existing supply order is modified a new history record is
created so we have a paper trail of all the changes made to the order and
the specific line items ordered are associated with the history record.
I want to select for a given date all sites that have the last history
record with a certain status.
This will select the last history record for each site:
SELECT MA h.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' GROUP BY s.uid
But if I do this:
SELECT MAh.uid), site FROM supplyorder AS s, supplyorderhistory AS h
WHERE h.supplyorderuid = s.uid AND date = '2007-01-08' and status = '2'
GROUP BY s.uid
Max just becomes the last history record with a status of 2. I understand
why it is working this way and that it is working correctly, I just don't
know how to get what I want out of it.
Thanks in advance for any help.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200david@safedatausa.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 3 answer | Add comment |
|
| external updates/additions of database entries Lev Lvovsky 04:37:33 |
| | Hello, I'm looking for help in merging the contents of two database
tables with identical columns between them. A base set of data will
be stored in the "permanent" table, and incremental additions and/or
changes will be introduced in the "staging" table the ID's of the
data in the tables is the only thing which won't be in sync.
Initially looking through the documentation, a 'natural join' seemed
to be the best way to highlight changes. My ideal result would have
been all of the entries from the staging table not in the permanent
table, however I'm unclear on how to form a query without explicitly
naming each row name and using it with a comparison operation.
Any help on this subject would be appreciated!
thanks!
-lev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
Friday, 12 January 2007
|
| MySQL++ and Boost Pedro Lamar o 23:38:38 |
| | Warren Young escreveu:> You may know from reading the Wishlist that I am already toying with > making Boost a MySQL++ dependency (for portable mutexes), but it's > such a complex library that I keep putting it off. Lots of potential > benefits, but lots of potential pain, too.>
I can help with this, I have experience with Boost and its build system.
--
Pedro Lamar o
Desenvolvimento
Intersix Technologies S.A.
SP: (55 11 3803-9300)
RJ: (55 21 3852-3240)
www.intersix.com.br
Your Security is our Business
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 9 answers | Add comment |
|
| Row position in table when sorted? Nuno Oliveira 23:37:41 |
| | Hello,
I'm working on a web site which have a page for the admin
to browse the clients table in a database.
To facilitate the interaction, I'm ORDERing BY Name...
The pagination buttons in this page are something like:
href=".....?Page=7"
and when loaded, it will
"SELECT * FROM Clients ORDER BY Name LIMIT 7,1"
This is working perfectly but now I have a problem.
I've done a page to find a client and I display the
clients names in a table (Using CSS) but I don't know
where to link to??? I apply a query and retrieve let's
say 14 clients that match. What should the LIMIT value???
This is what I don't know how to do... Please help?
Is there a way to know the position of a certain row if
all the rows are selected and in a specific order?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 6 answers | Add comment |
|
| [OT} How to pronounce GIF (was: Re: How to pronounce MyISAM
and InnoDB) Tk 22:01:28 |
| | At 10:15 AM 1/7/2007 -0800, Brian Dunning wrote:>My friend says "my sam" and "in-NOD-b". I want to kill him every >time. He also says "jif" instead of "gif".
The GIF Pronunciation Page:
http://www.olsenhome.com/gif/
In short, the original inventors of the GIF format (CompuServe, 1987) have always defined the pronunciation to be like "JIF." So, that has always been the "correct" pronunciation.
- TK
On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote:>> "My, I, Sam" and "inno, d, b">> From: "js " <ebgssth@gmail.com>>> Sorry for this silly question but I've been always had trouble>>pronouncing "MyISAM" and InnoDB.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| bug in mysql++-2.1.1 configure.ac to use mysqlclient_r David McLaughlin 21:49:50 |
| | To whom it may concern:
There is a bug in mysql++-2.1.1's configure.ac file that was not in
mysql++-2.0x.
The thread has to do with not using the mysqlcient_r library even
thought --enable-thread-check is specified.
The problem is the block of code:
# Figure out whether/how to handle threading support, if available.
AC_ARG_ENABLE(thread-check,
[ --enable-thread-check Check for threads, and use if available. ],
[ thread_check=yes ])
if test "x$thread_check" = "xyes"
then
ACX_PTHREAD
LIBS="$PTHREAD_LIBS $LIBS"
CFLAGS="$CFLAGS $PTHREAD_CFLAGS"
CC="$PTHREAD_CC"
fi
should come somewhere before the line MYSL_API_LOCATION, as this line
includes the mysql_loc.m4 file that uses acx_pthread_ok.
As it currently stands, acx_pthread_ok will not be defined when it first
being used in mysql_loc.m4, because it gets defined as a result of the
block below it.
Please contact me if you have any questions.
Thanks so much,
David
davidm@thredx.com
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 1 answer | Add comment |
|
| Bug in mysqlpp::transaction Alex Burton 21:46:33 |
| | Hi all,
I have found a bug.
mysqlpp::transaction's destructor can throw exceptions.
destructors should never throw.
If I am using the transaction object and then mysql "goes away" resulting in one of my queries failing during the transaction, throwing an exception to indicate the failure.
The transaction is destroyed during stack unwind, and as intended rolls back the transaction.
The roll back fails for the same reason as the query failed that is causing the roll back.
So then we get a second exception whilst unwinding the stack for the first exception.
The necessary fix is to wrap the contents of ~transaction in a try {} catch (...) statement.
Alex
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 1 answer | Add comment |
|
| Return string directly from the class ROW Yingbo Miao 21:37:47 |
| | Hi,
I wonder whether it is a good way to return the "raw string" directly
from the class ROW. For example, one line line can be added to the
row.h
class ROW ...
{
public:
// The suggestion function. Return the "raw string"
const std::string & raw_string ( int i ) const { return data.at(i); }
}
I find it is handy to handle the result of a blob column in this way.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 4 answer | Add comment |
|
| UTF-8 sorting problem Joakim Lemstrц m 16:36:02 |
| | Hello
I've got a problem,, I've tried to search the archive for this list with no luck.
Maybe it's because Unicode problems isn't that rare...
Anyway ..
Here is my problem.
Sorting on a VARCHAR collate utf8_swedish_ci (table with default charset utf8)..
As many probably know, in Swedish we have the letters ц ц ц ц ц ц .
If I have a table which has default charset utf8 and collate utf8_swedish_ci and
I sort the result on a VARCHAR, the letters ц ц ц ц ц ц comes in between the 'normal' letters
A-Z .. They should be last, after Z in order: ц ц ц
eg.
mysql>CREATE TABLE utftest (c1 VARCHAR(30) COLLATE utf8_swedish_ci) default charset utf8;
mysql>insert into utftest (c1) VALUES ('A');
mysql>insert into utftest (c1) VALUES ('AAAA');
mysql>insert into utftest (c1) VALUES ('Z');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>select c1 from utftest order by c1;
c1
----
A
ц
ц
ц
AAAA
Z >total mess.. between A-Z and not the correct ц ц ц -order.
If I instead do this !and! change the encoding for my terminal to ISO-8859-1
mysql>CREATE TABLE utftest2 (c1 VARCHAR(30) CHARSET utf8) default charset latin1;
mysql>insert into utftest (c1) VALUES ('A');
mysql>insert into utftest (c1) VALUES ('AAAA');
mysql>insert into utftest (c1) VALUES ('Z');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>insert into utftest (c1) VALUES ('ц ');
mysql>select c1 from utftest order by c1;
c1
----
A
ц
ц
ц
AAAA
Z
- Gives the exact same answer as before, but
mysql>select c1 from utftest order by c1 collate utf8_swedish_ci;
c1
----
A
AAAA
Z
ц
ц
ц >CORRECT
I'm starting to get lost with every possible collate/charset configuration...
The sollution that gives the correct answer isn't really possible in my situation.
I have a 30k+ lines application and that one has been reconfigured to receive
the data in utf8-format, therefor also saving it in MySQL as utf8.
What can I do?
As it is now, the data is saved as utf8, the columns/tables in MySQL are created
as utf8 tables .. but MySQL can't seem to sort this correctly..
This is my current configuration
------------------------------------------
mysql>status
Server version: 5.0.24a-Debian_9-log
mysql>show variables like 'character_set%';
Variable_name | Value
character_set_client | latin1
character_set_connection | latin1
character_set_database | latin1
character_set_filesystem | binary
character_set_results | latin1
character_set_server | latin1
character_set_system | utf8
Running on Kubuntu 6.10 Edgy
$ export|grep LANG
declare -x LANG="en_US.UTF-8"
------------------------------------------
Regards
Joakim Lemstrц m, Bytewize AB, Sweden
|
| | Add comment |
|
| Dual Hardisk Guest 16:27:00 |
| | Hi,
I have a database named X on a hardisk, and the hardisk can not store new
record because it has no space anymore. Can I just add a new hardisk and ask
MySQL to store new record for database X to the new hardisk? Please share me
the knowledge to do it, many thanks for your helps.
Regards
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| Primary key GrГ©goire Dubois 16:03:42 |
| | Hi all,
In the following table, I declare ID as a PRIMARY KEY. Is it then
necessary to add the parameters NOT NULL AUTO_INCREMENT?
CREATE TABLE company (
ID INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30),
admin_ID INT,
PRIMARY KEY ID,
INDEX admin_ID,
);
Or can I just declare the table like that? Does creating a primary key
on an int immediatly involve this one to be not null, and to auto-incrГ©ment?
CREATE TABLE company (
ID INT,
name VARCHAR(30),
admin_ID INT,
PRIMARY KEY ID,
INDEX admin_ID,
);
Thank you very much.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 13 answers | Add comment |
|
| problem building from svn on os x (intel): libtool error Michael Johnston 15:17:43 |
| | I am trying to build from svn on an intel OS X box, and I get the
following error:
/Users/lasto/Downloads/mysqlpp/bk-deps g++ -c -o mysqlpp_vallist.o -
I. -dynamic -fPIC -DPIC -I/opt/local/include/mysql -fno-common ./lib/
vallist.cpp
g++ -dynamiclib -single_module -headerpad_max_install_names -o
libmysqlpp.dylib mysqlpp_coldata.o mysqlpp_connection.o
mysqlpp_datetime.o mysqlpp_field_names.o mysqlpp_fields.o
mysqlpp_field_types.o mysqlpp_manip.o mysqlpp_myset.o
mysqlpp_qparms.o mysqlpp_query.o mysqlpp_result.o mysqlpp_row.o
mysqlpp_sql_string.o mysqlpp_string_util.o mysqlpp_transaction.o
mysqlpp_type_info.o mysqlpp_vallist.o -L/opt/local/lib/mysql -
install_name /opt/local/lib/libmysqlpp.dylib -Wl,-soname -
Wl,libmysqlpp.so.2 -lmysqlclient -lz -lmysqlclient -lz
/usr/bin/libtool: unknown option character `o' in: -soname
Usage: /usr/bin/libtool -static [-] file [...] [-filelist listfile
[,dirname]] [-arch_only arch] [-sacLT]
Usage: /usr/bin/libtool -dynamic [-] file [...] [-filelist listfile
[,dirname]] [-arch_only arch] [-o output] [-install_name name] [-
compatibility_version #] [-current_version #] [-seg1addr 0x#] [-
segs_read_only_addr 0x#] [-segs_read_write_addr 0x#] [-seg_addr_table
<filename>] [-seg_addr_table_filename <file_system_path>] [-all_load]
[-noall_load]
make: *** [libmysqlpp.dylib] Error 1
To setup the build, I downloaded and built bakefile from source, then
ran
./bootstrap --with-mysql=/opt/local
in the mysqlpp source dir
Have I missed a step in setting up the build for OS X, or does anyone
have an idea why I am seeing this error? It seems to be related to
flavors of libtool and that therefore the bakefile process has gone
wrong somehow.
The reason I am trying to build from svn is that I need to interface
to mysql5 and I am seeing the issue described here: http://
lists.mysql.com/plusplus/6228
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 1 answer | Add comment |
|
| v2.2 release plan Warren Young 14:44:23 |
| | I'm closing in on a v2.2 release. Here's the current list of things
remaining, all of which are polishing matters, and (hopefully) small bug
fixes:
o We probably don't need both platform.h and defs.h. Fold them
together and rework the rest of the library to cope.
o Test that it still works under MinGW after the recent
DLL linkage fixes for VC++.
o RPM build shouldn't require Bakefile. This may mean building
examples even though they're not needed. One way around
this may be if we can say something like "make libmysqlpp.so"
in the build process instead of "make all".
o Move to a single Bakefile probably breaks tarball build
and more. Also requires changes to README type files.
o Can simplify Windows Bakefile coverage in HACKERS file
by just giving the "bakefile -f msvc6prj mysql++.bkl"
command. Then you don't need Cygwin or bakefilize.
o Add function to library to return its version number in a
structured form. Then, make resetdb query it to ensure that
it's linked to the same version. Prevents errors caused
by not using exrun script when running examples with a
different library version installed.
o resetdb is hanging in Query::execute() on RHEL 3 test system.
Find out why.
The most important thing that needs testing is the VC++ support. A few
days ago, I think I solved the build problem. VC++ building got broken
the last time we fixed MinGW. As a consequence, it'd also be nice to
get reports of MinGW testing, to see whether we've re-broken it.
Beware that the library and examples are no longer built separately in
the VC++ case. There is now just a single top-level .dsw file, as this
makes dependency checking easier, and prevents confusion about what to
build, when. This was done separately from the DLL linkage fix; it's
just been one of those things I wanted to get done, so I did it while I
was already working on the Windows side. I only bring it up because
it's changed since the last time I asked anyone to test the VC++
version, so if you check it out on top of an existing copy and don't
realize that this changed, your build may break for reasons I would find
uninteresting. 
Those of you who are watching development may notice that some features
were dropped from this release in the interest of getting the thing out
the door. The BLOB/binary data stuff is still top of my wishlist for
the next release; I've just decided that I need to release this thing
soon, if only because people need some of the bug fixes in it.
In unrelated news, I hereby announce that this release of MySQL++ is
codenamed Longhorn.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 9 answers | Add comment |
|
| Need any that can translate this TomАs Abad FernАndez 11:25:15 |
| | I dont know why thease don't work at MySql 3.21 , anyone can help me to make
this compatible with mysql3?
$query = "SELECT * FROM facturas WHERE pedido IN (SELECT orders_id FROM
orders WHERE user_id='".$user."') ORDER BY factura_id";
Thanks for all.
|
| | 5 answers | Add comment |
|
| Select Query Chris Kay 10:05:22 |
| |
Query ( that gets past the anti spam )
Question is......
I have a select where I want to get ID 15 && id 25
Can I do something like WHERE ID = 15,25
Or do I have to do WHERE ID = 15 && ID = 25
---------------------------------------------------------
Chris Kay
Techex Communications
Website: www.techex.com.au Email: chris.kay@techex.net.au
Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
---------------------------------------------------------
---------------------------------------------------------------------
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 <mysql-thread121209@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 10 answers | Add comment |
|
| installing mysql++ Premal Mishra 06:08:28 |
| |
I've downloaded mysql++-1.7.9.tar.gz
I'm using command line version of the digitalmars c++ compiler for windows.
How to set up Mysql++ for use.
Premal.
|
| | 9 answers | Add comment |
|
| Problems with Visual C++ Express Klaus Benner 06:08:05 |
| | Hello,
I seem to have troubles building the files in the /lib and /examples directories. I am using Visual C++ Express, and after I open and convert the .dsw file to .vcproj, I get the error appended to at the end of this message. Basically, it tries to include a "mysql.h" file, and can't seem to find it. I searched for such a file manually, and there is none in the mysql++-2.1.1.tar.gz archive. I even tried replacing the #include directive in all those files in order for them to point to a mysql++.h library, but that turns out not to solve the problem, as I get a host of other (100+) errors. What am I doing wrong?
------ Build started: Project: mysqlpp, Configuration: Debug Win32 ------
Compiling...
coldata.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
connection.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
datetime.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
field_names.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
field_types.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
fields.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
manip.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
myset.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
qparms.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
query.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
result.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
row.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
sql_string.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
string_util.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
transaction.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
type_info.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
vallist.cpp
d:\mysql++-2.1.1\lib\defs.h(34) : fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory
Generating Code...
Build log was saved at "file://d:\mysql++-2.1.1\lib\Debug\mysqlpp\BuildLog.htm"
mysqlpp - 17 error(s), 0 warning(s)
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========
____________________________________________________________________________________
Have a burning question?
Go to www.Answers.yahoo.com and get answers from real people who know. |
| | 2 answer | Add comment |
|
| multiple instances of mysql on a given server Bruce 00:36:37 |
| | hi...
i'm trying to determine if it's safe, or if there are pitfalls to running
simultaneous copies of mysql on a given server. assume that the instances
are completely separate, dirs/ports/etc...
can't really determine from the various information sources on the net.
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
Thursday, 11 January 2007
|
| max connections question Bruce 23:15:05 |
| | hi...
i can modify the max_connections param in the my.cnf file...
does mysql provide a way for me to essentially guarantee that a given
process/user can always access the db, so the process/user doesn't get the
'max connection' error...
i thought i had seen something regarding this awhile back, but i can't seem
to find any information on it now..
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
|
| how to take advantage of STR_TO_DATE Gilles MISSONNIER 23:06:15 |
| | Hello the list
I have a bunch of data that I load in the base through
the "load data infile" procedure.
These data contain date with the following date format :
%d/%m/%Y [ that is day/month/year_4digit ]
I could rewrite the date with a script (perl, shell,)
to convert "day/month/year_4digit" into the standard MySQL format
that is "year_4digit-month-day", then load data in the base.
but I think I could take advantage of the STR_TO_DATE feature :
mysql> SELECT STR_TO_DATE('15/10/1999', '%d/%m/%Y');
+---------------------------------------+
| STR_TO_DATE('15/10/1999', '%d/%m/%Y') |
+---------------------------------------+
| 1999-10-15 |
+---------------------------------------+
I don't know how to do it on the fly :
should I create an string colum, in which I put the date like
"15/10/1999"
then run a mysql procedure that use STR_TO_DATE to fill a date column ?
how to do this ?
regards,
_- -_- -_- -_- -_
Gilles Missonnier
IAP - gimi@iap.fr
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org |
| | 6 answers | Add comment |
|
| replication - master/slave, distributed db questions... Bruce 21:33:58 |
| | hi...
i have a project and i'm trying to figure out the best approach to architect
a solution to resolve the issues i'm facing. i'm open to whatever might be
the 'best' solution. keep in mind, this is a 'project' that's my own, kind
of a garage function!!
i'm creating a distributed web parsing/crawling app. it will consist of a
number of nodes in the network whose function is to crawl a site, extract
information from the site, and to return the information to the db/tbls for
the app.
in an effort to speed this whole process, i'm gearing up to being able to
have 100s of crawling apps running in a simultaneous manner. this would
obviously swamp out a single instance of mysql given the limit of the open
connections that you can have.
i've started to look at the idea of having a mysql instance on each crawling
node within the network. this would allow me to have a kind of round robin
approach, so that each crawling/parsing script could write to whatever
'local' mysql db that it finds. this kind of makes sense.
i can then import/pull the information from the local dbs to the master db.
however, i'm also running into a situation where i might need to
delete/flush data written to a local db/tbl by one of the crawling apps in
the even the app fails. in this case, i'd essentially have to search each of
the 'local' mysql dbs in order to do the flush/delete, as i wouldn't know
which db the crawling app that i've killed had been writing to...
which is a less than elegant solution. i've looked at docs that talk about
master/slave replication/etc...
so.. i'm open to a discussion on the potential solutions to this kind of
scenario. keep in mind, i'm not a mysql dba/guru., just trying to solve this
issue.
thanks
-bruce
bedouglas@earthlink.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
|
| RAID Marco Ratto 19:53:04 |
| | How can I use RAID's option in MySql?
Thanks.
Bye, Marco
|
| | 25 answers | Add comment |
|
|
