MySQL for Excel 1.2.1 has been released
The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1. This is a maintenance release for 1.2.x. MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as: · Importing MySQL Data into Excel · Exporting Excel data directly into MySQL to a new or existing table · Editing MySQL data directly within Excel MySQL for Excel is installed using the MySQL Installer for Windows. The MySQL installer comes in 2 versions · Full (150 MB) which includes a complete set of MySQL products with their binaries included in the download · Web (1.5 MB - a network install) which will just pull the MySQL for Excel over the web and install it when run. You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can be downloaded from http://dev.mysql.com/downloads/installer/. MySQL for Excel 1.2.1 introduces the following features: · When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services. o Bug #16238788 - CONNECTIONS FOR FOUND MYSQL SERVICES SHOULD BE AUTOMATICALLY CREATED Known limitation / requirement: · You must uninstall any current installation of MySQL for Excel before performing this upgrade, due to a bug that prevented upgrades from previous versions. This applies to both the standalone MSI and MySQL Installer installation methods, and the fix allows for simpler upgrades in the future. Also this release contains the following bug fixes: · With Microsoft Excel 2013, closing an Excel window containing an open MySQL for Excel plugin did not properly dispose of the link to the plugin, which caused a delay when opening the plugin inside additional Excel windows. o Bug #18392674 - SEVERAL CLICKS NEEDED ON THE MYSQL FOR EXCEL RIBBON BUTTON TO START/CLOSE ADD-IN · Attempts to upgrade MySQL for Excel would sometimes fail. The Installer would attempt to add Registry keys that were already present from a previous installation. A workaround was to uninstall and then reinstall the plugin o Bug #18354533 - MYSQL FOR EXCELL ADDIN 1.2.0 (STAND ALONE) IS NOT ABLE TO UPDATE AN OLD VERSION · Executing Export Data while the first data column was not numeric would cause an "AutoPK" column (Automatically create a Primary Key) to be created as the first column in the table. This column was also created if the user manually selected the Add a Primary Key column radio button. The generated CREATE TABLE statement did not contain the AutoPK column. o Bug #18269654 - EXPORT DATA - ERROR ON CHANGING PRIMARY KEY OPTIONS · The Export Data operation failed when checking the Exclude Column checkbox for any column. The generated CREATE TABLE query did not show the excluded columns, but the generated INSERT statements did (incorrectly) include them. o Bug #18269602 - EXPORT DATA - EXCLUDING COLUMNS CAUSE THE EXPORT DATA TO FAIL · The Remove columns that contain no data, otherwise just flag them as "Excluded" option was removed from the Export Data Advanced Options preference panel. Now, the default behavior is to always remove empty columns from the calculations. o Bug #18113057 - EXPORT DATA - UNHANDLED EXCEPTION WHEN SELECTING THE WHOLE SPREADSHEEET'S DATA · A MySQL database with unique keys would sometimes fail to import, when executing Import MySQL Data. o MySQL Bug #71004, Bug #17891357 - ONLY ONE TABLE FROM A DATABASE WON'T IMPORT · The creation of named tables did not function in all cases during an import, and could generate an exception. o MySQL Bug #70925, Bug #17806468 - IMPORTING TABLES WITH GUID TO EXCEL - EXCEPTION · After creating a new stored mapping in the Append Data dialog, the default selection for the Stored Mapping drop-down list was a blank value. The new default is the newly created stored mapping. o Bug #17665496 - APPEND DATA - NEW STORED MAPPING NOT APPLIED AFTER CREATION · Exporting large table (250,000+ rows) would not function, as MySQL for Excel would disconnect from the MySQL Server before completion. The MySQL for Excel plugin was optimized to help with these use cases, and these changes include: o Optimized the way SQL statements are sent to the server, compared to statements sent in version 1.2.0 a 30-35% time improvement was achieved. o Optimized the way SQ
Re: Issue With Subqueries
Hi, mysql> select count(distinct field1) from db2.table1 where field1 not in >> (select field1 from db1.table1); >> ++ >> | count(distinct field1) | >> ++ >> >> If the field db1.table1.field1 has the same name that the field db2.table1.field1, maybe you have to use an alias for each table: try: mysql> select count(distinct A.field1) from db2.table1 A where field1 not in (select B.field1 from db1.table1 B); -- Javier
Multiple-Column Indexes Question
Assuming we have the following table: CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), ); With last_name having 1,000 different values and first_name having 1000,000 different values... What is better (if any) at the time of querying the database: A) To define an index like: "INDEX name (last_name,first_name)" and perform a query like: "select * from test where last_name='aaa' and first_name='bbb'" B) To define an index like: "INDEX name (first_name,last_name)" and perform a query like: "select * from test where first_name='bbb' and last_name='aaa'" C) It is irrelevant the order of the index definition. Thanks in advanced Javier
mysql_stmt_bind_param error
I tried to execute the example code (see below) from the function
mysql_stmt_execute I found in mysql 4.1 documentation
(http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-execute.html). This
source code runs perfect under linux red hat with version 4.1.7 but it
prints out an error if I try to run it under windows XP SP2.
This is the output of this code
prepare, INSERT successful
total parameters in INSERT: 3
mysql_stmt_bind_param() failed
Using unsupported buffer type: 838860800 (parameter: 2)
It seems that the function mysql_stmt_bind_param is not working under
this environment.
I tried installing version 4.1.20 and linking my program with the new
library but the result is the same.
Is that a bug of windows version? Can anyone help?
Thanks in advanced
Javier Arias
/***
**/
#define STRING_SIZE 50
#define DROP_SAMPLE_TABLE "DROP TABLE IF EXISTS test_table"
#define CREATE_SAMPLE_TABLE "CREATE TABLE test_table(col1 INT,\
col2 VARCHAR(40),\
col3 SMALLINT,\
col4 TIMESTAMP)"
#define INSERT_SAMPLE "INSERT INTO test_table(col1,col2,col3)
VALUES(?,?,?)"
MYSQL_STMT*stmt;
MYSQL_BINDbind[3];
my_ulonglong affected_rows;
int param_count;
short small_data;
int int_data;
char str_data[STRING_SIZE];
unsigned long str_length;
my_bool is_null;
if (mysql_query(mysql, DROP_SAMPLE_TABLE))
{
fprintf(stderr, " DROP TABLE failed\n");
fprintf(stderr, " %s\n", mysql_error(mysql));
exit(0);
}
if (mysql_query(mysql, CREATE_SAMPLE_TABLE))
{
fprintf(stderr, " CREATE TABLE failed\n");
fprintf(stderr, " %s\n", mysql_error(mysql));
exit(0);
}
/* Prepare an INSERT query with 3 parameters */
/* (the TIMESTAMP column is not named; the server */
/* sets it to the current date and time) */
stmt = mysql_stmt_init(mysql);
if (!stmt)
{
fprintf(stderr, " mysql_stmt_init(), out of memory\n");
exit(0);
}
if (mysql_stmt_prepare(stmt, INSERT_SAMPLE, strlen(INSERT_SAMPLE)))
{
fprintf(stderr, " mysql_stmt_prepare(), INSERT failed\n");
fprintf(stderr, " %s\n", mysql_stmt_error(stmt));
exit(0);
}
fprintf(stdout, " prepare, INSERT successful\n");
/* Get the parameter count from the statement */
param_count= mysql_stmt_param_count(stmt);
fprintf(stdout, " total parameters in INSERT: %d\n", param_count);
if (param_count != 3) /* validate parameter count */
{
fprintf(stderr, " invalid parameter count returned by MySQL\n");
exit(0);
}
/* Bind the data for all 3 parameters */
memset(bind, 0, sizeof(bind));
/* INTEGER PARAM */
/* This is a number type, so there is no need to specify buffer_length
*/
bind[0].buffer_type= MYSQL_TYPE_LONG;
bind[0].buffer= (char *)&int_data;
bind[0].is_null= 0;
bind[0].length= 0;
/* STRING PARAM */
bind[1].buffer_type= MYSQL_TYPE_STRING;
bind[1].buffer= (char *)str_data;
bind[1].buffer_length= STRING_SIZE;
bind[1].is_null= 0;
bind[1].length= &str_length;
/* SMALLINT PARAM */
bind[2].buffer_type= MYSQL_TYPE_SHORT;
bind[2].buffer= (char *)&small_data;
bind[2].is_null= &is_null;
bind[2].length= 0;
/* Bind the buffers */
if (mysql_stmt_bind_param(stmt, bind))
{
/*TH
E ERROR IS HERE/
fprintf(stderr, " mysql_stmt_bind_param() failed\n");
fprintf(stderr, " %s\n", mysql_stmt_error(stmt));
exit(0);
}
¿mysql_stmt_bind_param under windows bug?
I tried to execute the example code (see below) from the function
mysql_stmt_execute I found in mysql 4.1 documentation
(http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-execute.html). This source
code runs perfect under linux red hat with version 4.1.7 but it prints out an
error if I try to run it under windows XP SP2.
This is the output of this code
prepare, INSERT successful
total parameters in INSERT: 3
mysql_stmt_bind_param() failed
Using unsupported buffer type: 838860800 (parameter: 2)
It seems that the function mysql_stmt_bind_param is not working under this
environment.
I tried installing version 4.1.20 and linking my program with the new library
but the result is the same.
Is that a bug of windows version? Can anyone help?
Thanks in advanced
Javier Arias
/*/
#define STRING_SIZE 50
#define DROP_SAMPLE_TABLE "DROP TABLE IF EXISTS test_table"
#define CREATE_SAMPLE_TABLE "CREATE TABLE test_table(col1 INT,\
col2 VARCHAR(40),\
col3 SMALLINT,\
col4 TIMESTAMP)"
#define INSERT_SAMPLE "INSERT INTO test_table(col1,col2,col3) VALUES(?,?,?)"
MYSQL_STMT*stmt;
MYSQL_BINDbind[3];
my_ulonglong affected_rows;
int param_count;
short small_data;
int int_data;
char str_data[STRING_SIZE];
unsigned long str_length;
my_bool is_null;
if (mysql_query(mysql, DROP_SAMPLE_TABLE))
{
fprintf(stderr, " DROP TABLE failed\n");
fprintf(stderr, " %s\n", mysql_error(mysql));
exit(0);
}
if (mysql_query(mysql, CREATE_SAMPLE_TABLE))
{
fprintf(stderr, " CREATE TABLE failed\n");
fprintf(stderr, " %s\n", mysql_error(mysql));
exit(0);
}
/* Prepare an INSERT query with 3 parameters */
/* (the TIMESTAMP column is not named; the server */
/* sets it to the current date and time) */
stmt = mysql_stmt_init(mysql);
if (!stmt)
{
fprintf(stderr, " mysql_stmt_init(), out of memory\n");
exit(0);
}
if (mysql_stmt_prepare(stmt, INSERT_SAMPLE, strlen(INSERT_SAMPLE)))
{
fprintf(stderr, " mysql_stmt_prepare(), INSERT failed\n");
fprintf(stderr, " %s\n", mysql_stmt_error(stmt));
exit(0);
}
fprintf(stdout, " prepare, INSERT successful\n");
/* Get the parameter count from the statement */
param_count= mysql_stmt_param_count(stmt);
fprintf(stdout, " total parameters in INSERT: %d\n", param_count);
if (param_count != 3) /* validate parameter count */
{
fprintf(stderr, " invalid parameter count returned by MySQL\n");
exit(0);
}
/* Bind the data for all 3 parameters */
memset(bind, 0, sizeof(bind));
/* INTEGER PARAM */
/* This is a number type, so there is no need to specify buffer_length */
bind[0].buffer_type= MYSQL_TYPE_LONG;
bind[0].buffer= (char *)&int_data;
bind[0].is_null= 0;
bind[0].length= 0;
/* STRING PARAM */
bind[1].buffer_type= MYSQL_TYPE_STRING;
bind[1].buffer= (char *)str_data;
bind[1].buffer_length= STRING_SIZE;
bind[1].is_null= 0;
bind[1].length= &str_length;
/* SMALLINT PARAM */
bind[2].buffer_type= MYSQL_TYPE_SHORT;
bind[2].buffer= (char *)&small_data;
bind[2].is_null= &is_null;
bind[2].length= 0;
/* Bind the buffers */
if (mysql_stmt_bind_param(stmt, bind))
{
/*THE ERROR
IS HERE/
fprintf(stderr, " mysql_stmt_bind_param() failed\n");
fprintf(stderr, " %s\n", mysql_stmt_error(stmt));
exit(0);
}
Re: localhost
--- Karl Larsen <[EMAIL PROTECTED]> escribió: > I'm trying to use mysql on Linux type Fedora > Core 4 and it works > part way but I have no guess how to fix this > problem. Here is what happens: > > [EMAIL PROTECTED] ~]$ mysql > Welcome to the MySQL monitor. Commands end with ; > or \g. > Your MySQL connection id is 3 to server version: > 4.1.20-log > > Type 'help;' or '\h' for help. Type '\c' to clear > the buffer. > > mysql> use mysql; > ERROR 1044 (42000): Access denied for user > ''@'localhost' to database > 'mysql' > mysql> > > I let you see the way I get mysql up and then I > ask to use a DB and > every time I get ERROR 1044 and so of course I can't > use mysql. > > Does anyone know what error I have made? I > loaded mysql from the > Linux version I'm using and had the problem. I then > deleted all and yum > got the latest version which is up now. > > Karl Larsen Hi, the problem is that you are not specifying any user to use mysql monitor you have to start it like this: mysql -ujohn -p or mysql -u john -p -u indicates the user you are logging as -p indicates that you have a password and you want to type it. Of course for you to log in as john you `ve got to set permission for user john to log in mysql trough localhost. Hope it helps. PS: If you have further questions read this: http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html ___ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9
Can you tell us about your config parameters? Probably you must set up your max_connections, max_user_connections http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html Ady Wicaksono escribió: I have MySQL 5 installed on My Machine, But it could handle only max about 350 concurrent mysql connection Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always got Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in Is it mysql bug, incorrect Linux setting or what? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with indexes on Date/DateTime fields
Hi Jigal Thanks a lot for your answer. Sorry for the confusion about DELETE and SELECT. What we are trying to optimize are some DELETE statements, it was just that while investigating we found this behaviour of Mysql not using some date indexes if we change from using "=" operator to use >= or <= Please find below all the details. Mysql version: 4.1.12 Operating System: Linux Table Type: InnoDB Number of records in table: More than 10 million process_times CREATE TABLE `process_times` ( `ID` bigint(20) unsigned NOT NULL default '0', `date` date NOT NULL default '-00-00', `time` time NOT NULL default '00:00:00', `subagent` char(3) NOT NULL default '', `client_id` varchar(128) NOT NULL default '', `status` int(11) NOT NULL default '0', `process_time` double NOT NULL default '0', `host` varchar(20) NOT NULL default '', `process` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `client_idx` (`client_id`), KEY `status_idx` (`status`), KEY `subag_idx` (`subagent`), KEY `mias_idx2` (`host`), KEY `date_idx` (`date`), KEY `process` (`process`), KEY `date_proc_idx` (`date`,`process`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DELETE queries we want to optimize: DELETE FROM process_times WHERE (date <= date_sub(now(), INTERVAL VariableX VariableY)) AND (process=VariableZ) While investigating we tried different SELECT statement to check is Mysql was using the Index: date_proc_idx See below what we found 1- Select using "<=" operator. As you will see in the explain response not index is being used EXPLAIN SELECT * FROM process_times WHERE date <= date_sub(now(), INTERVAL 2 day) Explain results: 1 SIMPLE process_times ALL date_idx,date_proc_idx (NULL) (NULL) (NULL) 10778561 Using where 2- Select using "=" operator. date_proc_idx index is used EXPLAIN SELECT * FROM process_times WHERE date = date_sub(now(), INTERVAL 2 day) Explain results: 1 SIMPLE process_times ref date_idx,date_proc_idx date_idx 3 const 1863456 Using where 3- Adding condition for "process" field. EXPLAIN SELECT * FROM process_times WHERE date = date_sub(now(), INTERVAL 2 day) and process=1 Explain results: - - 1 SIMPLE process_times ref date_idx,process,date_proc_idx date_proc_idx 7 const,const 550726 Using where 4 - Again with condition for "process" field and changing operator from "=" to "<=". This cause Mysql to use a diffent index, in this case the index for process EXPLAIN SELECT * FROM process_times WHERE date <= date_sub(now(), INTERVAL 2 day) and process=1 Explain results: - - 1 SIMPLE process_times ref date_idx,process,date_proc_idx process 4 const 1830334 Using where After seeing this we are now worry about the fact maybe many queries we have based on date fields are not using the indexes in the way we were expecting. I would like also ask if is valid to expect that the results of the Explain statement for a query like this SELECT * FROM TABLE-X WHERE [CONDITIONS] Are valid for the equivalent DELETE FROM TABLE-X WHERE [CONDITIONS] Thanks a lot for your help Javier -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 14:39 To: Javier Diaz Cc: Aftab Khan; mysql@lists.mysql.com Subject: Re: Problems with indexes on Date/DateTime fields Javier Diaz wrote: > I would like to know if there is any problem which cause Mysql to not > use date indexes at least you use the "=" operator, because if that is > the case we will need to re-visit a few queries If you do a select instead of a delete, will the index be used? (You can check this by using EXPLAIN SELECT) If the index is used in that case MySQL must have a reason for not using the index for deleting a range. With MyISAM tables deleting a single date involves a single leave in the index tree, deleting multiple dates requires MySQL to merge index leaves during the delete. You could use DELETE QUICK to suppress the merging of index blocks, but you need to do an OPTIMIZE later on to reclaim the unused index space. The query optimizer might decide that using the index in this ca
RE: Problems with indexes on Date/DateTime fields
Thanks Aftab We already think of that option as possible solution but I was just wondering why is Mysql changing the logic when the operator changes. I would like to know if there is any problem which cause Mysql to not use date indexes at least you use the "=" operator, because if that is the case we will need to re-visit a few queries Thx Javier -Original Message- From: Aftab Khan [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 11:25 To: Javier Diaz Subject: RE: Problems with indexes on Date/DateTime fields I agree. Some time full table scan is faster than using the index and going row by row. Any way, try using a subquery and get the result on to a temp table or just del usnig it . Some thing like this: Del from table where Key field in (Sel Key from tabl1 where stored date>some date); --- Javier Diaz <[EMAIL PROTECTED]> wrote: > Hi Aftab > > Thanks for your prompt answer. > > Yes, second query is doing full scan. I don't > understand why a change in > the operator can make the parser think a full scan > will be better than > use the index. > > Nevertheless we know the best option is to use the > index, unfortunately > we can not use FORCE INDEX as what we really need to > do are DELETE > operations, and it seems FORCE INDEX is valid only > for SELECT > statements. > > Basically we have a huge database where we track > different operations > and every day we need to do some maintenance and > delete records which > are older than specific date. > > Thx > Javier > > -Original Message- > From: Aftab Khan [mailto:[EMAIL PROTECTED] > Sent: 05 January 2006 11:03 > To: Javier Diaz > Subject: Re: Problems with indexes on Date/DateTime > fields > > Is not the second quary doing a full table scan? The > parser may find this better than using the Index. > > --- Javier Diaz <[EMAIL PROTECTED]> wrote: > > > Hi all > > > > We are having a weird problem with some queries > > which are not using some > > indexes in date fields. > > > > Query-1 > > SELECT [field list] FROM tableX > > WHERE dateField = [any date expression or constant > > value] > > > > Query-2 > > SELECT [field list] FROM tableX > > WHERE dateField <= [any date expression or > constant > > value] > > > > > > We have an index for dateField in tableX. However > > Query-1 is using the > > index but Query-2 is not. We have tested a lot of > > different combinations > > and every time we use any of these operators <=, > <, > > >, >= > > > > Mysql stop using the index. We are using Mysql > > 4.1.12 binary > > distribution running on linux. > > > > Any help will be really appreciated. > > > > Thanks > > Javier > > > > > > > ** > > This email and any files transmitted with it are > > confidential and > > intended solely for the use of the individual or > > entity to whom they > > are addressed. If you have received this email in > > error please notify > > the system manager. > > > > This footnote also confirms that this email > message > > has been swept by > > MIMEsweeper for the presence of computer viruses. > > > > www.mimesweeper.com > > > ** > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > __ > Yahoo! DSL - Something to write home about. > Just $16.99/mo. or less. > dsl.yahoo.com > > __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problems with indexes on Date/DateTime fields
Hi Aftab Thanks for your prompt answer. Yes, second query is doing full scan. I don't understand why a change in the operator can make the parser think a full scan will be better than use the index. Nevertheless we know the best option is to use the index, unfortunately we can not use FORCE INDEX as what we really need to do are DELETE operations, and it seems FORCE INDEX is valid only for SELECT statements. Basically we have a huge database where we track different operations and every day we need to do some maintenance and delete records which are older than specific date. Thx Javier -Original Message- From: Aftab Khan [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 11:03 To: Javier Diaz Subject: Re: Problems with indexes on Date/DateTime fields Is not the second quary doing a full table scan? The parser may find this better than using the Index. --- Javier Diaz <[EMAIL PROTECTED]> wrote: > Hi all > > We are having a weird problem with some queries > which are not using some > indexes in date fields. > > Query-1 > SELECT [field list] FROM tableX > WHERE dateField = [any date expression or constant > value] > > Query-2 > SELECT [field list] FROM tableX > WHERE dateField <= [any date expression or constant > value] > > > We have an index for dateField in tableX. However > Query-1 is using the > index but Query-2 is not. We have tested a lot of > different combinations > and every time we use any of these operators <=, <, > >, >= > > Mysql stop using the index. We are using Mysql > 4.1.12 binary > distribution running on linux. > > Any help will be really appreciated. > > Thanks > Javier > > > ** > This email and any files transmitted with it are > confidential and > intended solely for the use of the individual or > entity to whom they > are addressed. If you have received this email in > error please notify > the system manager. > > This footnote also confirms that this email message > has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ** > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with indexes on Date/DateTime fields
Hi all We are having a weird problem with some queries which are not using some indexes in date fields. Query-1 SELECT [field list] FROM tableX WHERE dateField = [any date expression or constant value] Query-2 SELECT [field list] FROM tableX WHERE dateField <= [any date expression or constant value] We have an index for dateField in tableX. However Query-1 is using the index but Query-2 is not. We have tested a lot of different combinations and every time we use any of these operators <=, <, >, >= Mysql stop using the index. We are using Mysql 4.1.12 binary distribution running on linux. Any help will be really appreciated. Thanks Javier ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A question about stored procedures
Hi all, I am wondering if I can construct a query string inside a stored procedure and then execute it. I mean, what I want to do is given a set of IN parameters, be able to construct a huge where statement out of them an then complete the query string to execute. Is that possible? because if that is possible I could be able to abstract all the data logic from the program itself. I've been googling and reading books and references without success so far, but I think the functionality should be there, what I dont know is how to use it. Thanks in advance. sql - query - mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need to install MySQL extensions for php...
Hi, im kind of new using mysql, i used to have it installed on my Mandrake 9 using rpm, but i m testing the source installation, the thing is that i´ve succesfully compiled mysqld and it works, but now im trying to use a php page, and im asked to install : PHP needs a set of MySQL functions called "MySQL extension" How can i install those? Do i missed some configuration options?? Thanks for any help provided. Javier __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Visual Basic .NET Oledb Provider
Hi all, I would need an oledb provider for MySQL. Do you know where I can found a good one. Thanks in advance. Leonardo J. Belén. A-AR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: inserting special characters
Hi, Mr. Paharenko,
Here are the results:
character_set_client | latin1
character_set_connection | latin1
character_set_database | latin1
character_set_results| latin1
character_set_server | latin1
character_set_system | utf8
character_sets_dir | C:\Archivos de
programa\MySQL\MySQL Server 4.1\share\charsets/
collation_connection | latin1_swedish_ci
collation_database | latin1_swedish_ci
collation_server | latin1_swedish_ci
Create Table: CREATE TABLE `datos` (
`id_user` tinyint(3) unsigned NOT NULL auto_increment,
`nombre` varchar(55) NOT NULL,
`dni` varchar(10) NOT NULL,
`nacimiento` date NOT NULL,
`direccion` varchar(255) NOT NULL,
`telefono` varchar(9) NOT NULL,
`desde` date NOT NULL,
`hasta` date NOT NULL,
`subcontrata` enum('No','Correos','Vanyera'),
PRIMARY KEY (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
I have tried with the latin1_spanish_ci collation, but
the problem remains.
__
Renovamos el Correo Yahoo!: ¡250 MB GRATIS!
Nuevos servicios, más seguridad
http://correo.yahoo.es
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
inserting special characters
Hi, everybody! I have a problem working with MySQL and C++ Builder 6. I can´t find the solution and I hope that maybe somebody can help me. I use the ZEOS components (6.1.5) to connect the MySQL database (version 4.1.11) with C++ Builder. The fact is that everything goes rigth except when I try to write into the database. When I write special spanish characters (accents, ñ,...), this characters are changed in the database, so they´re wrong. I think that it occurs because the default character set of C++ Builder is not supported by the MySQL database (but I´m not sure about it). If anyone can explain me the reason, I´ll be exceedingly grateful. Thank you very much for your attention. Regards, __ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: C API : Problem using multi-statements
Hi
Instead of use two INSERT statements, try something like this:
INSERT INTO Table table1 VALUES (list of values1), (list of values2)
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: 06 May 2005 17:19
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: C API : Problem using multi-statements
Answer is simple. Can't do that.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, May 06, 2005 5:40 AM
Subject: C API : Problem using multi-statements
Hello,
I have some problems using multiple queries in a databased driven project,
therefore I wrote a little testprogram which
causes the same problems.
I am using the C-API of MySQL 4.1.11 on a Gentoo Linux 3.3.2-r5,
propolice-3.3-7 with 2.4.27 kernel.
I connect to the server (on localhost) with mysql_real_connect and the flag
CLIENT_MULTI_STATEMENTS,
I submit multiple queries (two INSERTS seperated by ";") on the existing
connection.
Executing the multistatement with mysql_query in a loop (i.e. 10 times),
I get a lot of "lost connection during query" errors, but sending a single
INSERT query in a loop causes no errors !!!
Thanks in advance for help
regards Tinosch Ganjineh
The following program operates on a simple table structure created with the
following statement :
CREATE TABLE BIGTABLE (myoid char(40), mykey char(40), myval char(40), myint
bigint) TYPE = InnoDB;
/** mysqltest.cpp
*/
#include
#include
#include
#include
using namespace std;
string itos(long long i) {
ostringstream sstream;
sstream << i;
return sstream.str();
}
int main(int argc, char** argv) {
MYSQL* conn;
if(conn = mysql_init(NULL)) {
if(mysql_real_connect(conn, "localhost", "root", "x", "test", 0, NULL,
CLIENT_MULTI_STATEMENTS )) {
int loop=100;
for(int i=0; ihttp://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with a full backup
Hi! I'm learning mysql and I have a problem when i make a full backup with mysqldump. I have a lot of table rows written in spanish. In the backup file (.sql) I have problems with certain spanish characters like: á --> Ãi é --> é í --> Ã- ú --> ú and so many others like that. However, when I make an incremental backup with the *.bin-* files I don't have this problem. I use MySQL 4.1.X with the default character set(latin1) and the default collation (latin1_swedish_ci). I´ve tried with the latin1_spanish_ci and with another character set (utf8 with the utf8_spanish_ci collation). But the problem doesn´t disappear. Can anybody help me? Thank you very much. __ Renovamos el Correo Yahoo!: ¡250 MB GRATIS! Nuevos servicios, más seguridad http://correo.yahoo.es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
calculated field
Hi All I've an Excel document that have some data but there are a column that has a formula related to other cells of the same row. Now I need to put data in a db but the problem is with this calculated data. A friend of mine that use Oracle told me that I could define a field like field1 = field2 + field3, but I can't discover this option in Mysql. It's possible to make it ? Any other idea about it ? Thanks in advance Javier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Logging Data: Should I use MyIsam or InnoDB?
Martijn Tonies wrote: Hello Jeremy, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to store this data, and the structure on the backend. There are 50 million inserts into table LOG a day. The primary index on the table is seconds from 1971. Sorry, as I understand, there are not 5000 seconds in a day, so it can not be primary key. OK, how about this: Use MyISAM and MERGE tables. Keep one table per day. E.g.: log_2005_01_15 log_2005_01_16 log_2005_01_17 log_2005_01_18 etc. Use MERGE tables to give you the 60 day (and perhaps e.g. 14 day, 30 day, 7 day, etc.) read views that you need, like so: CREATE TABLE log_view_7day ( ... ) TYPE=MERGE UNION=( log_2005_01_12, You can then do all of your inserts from the log writer into the "today" table, and do your reads against the various MERGEs. Every day at exactly midnight, you would use ALTER TABLE (which is atomic) to redefine the UNION of the MERGE definition of the various tables. Modifying metadata because you need a different view at your data. Am I the only one to which this sound ugly? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- Cuando todo esta bajo control, es que no vamos suficientemente deprisa ======== Javier Armendáriz [EMAIL PROTECTED]
Problem importing data
Hi all, I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze version), when importing data from a file with semicolon-separated data, I get random default values for the datetime fields. This turns the data obviosly unusable. The same import on the same machine but with the 4.0.12 version of the server is totally bug free. Does anyone have experience on this sort of problems? Leonardo J. Belén. mysql - query - sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A possible bug
thanks, but some of the tables have to be in MyIsam format, and i cannot see a workaround for them. (actually I discovered that the integrity of the data exported is just fine, but it seems that the server hangs trying to close the file handle. - Original Message - From: "Nickolai Nielsen" <[EMAIL PROTECTED]> To: "Leonardo Javier Belén" <[EMAIL PROTECTED]> Sent: Wednesday, July 28, 2004 9:34 AM Subject: SV: A possible bug Hi Leonardo i had a similar problem, it was with InnoDB tables, so i changed these values: # Set buffer pool size to 50-80% of your computer's memory set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=100M in the my.ini Nickolai -Oprindelig meddelelse- Fra: Leonardo Javier Belén Sendt: 27. juli 2004 22:04 Til: [EMAIL PROTECTED] Emne: A possible bug Hi all, I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that, whenever i try to export data using the "into outfile" clause of the select command the server hangs and i need to restart the service. Has anyone faced the same problem, and if it is, how have you resolve it? I think it is wrong because the same select string on MySQL ver. 4.0.20 works fine. Leonardo J. Belén. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A possible bug
Hi all, I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that, whenever i try to export data using the "into outfile" clause of the select command the server hangs and i need to restart the service. Has anyone faced the same problem, and if it is, how have you resolve it? I think it is wrong because the same select string on MySQL ver. 4.0.20 works fine. Leonardo J. Belén. query mysql select query mysql select query mysql select query mysql select query mysql select query mysql select query mysql select query mysql select query mysql select query mysql select -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ODBC Connector for Windows - how to handle large resultsets?
Hi all, I have a problem with the ODBC Connector since I need to handle very large resultsets. when I try a simple search on a 5Millon table, it tries to send all the info to the client hanging it before i can see a simple row. So is there a way to force the driver to use use_resultset instead of store_resultset? Thanks in advance Leonardo J. Belen. AFIP-AR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Concurrency Question
Hi I really don't like the idea to set innodb_flush_log_at_trx_commit to 2, the information in these tables is important. On the other hand there is nothing I can do from the point of view of the number of transactions. Each process run its own set of INSERTs and UPDATEs statements, so I can not reduce the number of transactions being executed. Looking to the MySQL documentation: >> Since the rotation speed of a disk is typically at most 167 revolutions/second, that constrains the number of commits to the same 167th/second >> if the disk does not fool the operating system And that we are doing a LOT MORE INSERTs by second, I'm afraid maybe the only solution is go back to MyISAM :-( By the way this figure of 167 revolutions/second is based on what kind of hard disk? thanks Javier -Original Message- From: Marc Slemko [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 17:58 To: Javier Diaz Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Concurrency Question On Mon, 5 Jul 2004 16:07:58 +0100 , Javier Diaz <[EMAIL PROTECTED]> wrote: > > We have changed all our tables to InnoDB and now the server is not able to > handle the load, even when we are not running the SELECTs statements against > these tables yet. > > As I mentioned in my email we make a lots of INSERTS and UPDATES in these > tables (more than 3000 per second). So far using MyISAM everything was OK, > but now when we moved the tables to InnoDB (to be able to make Read/Write > operations in these tables) the performance was down completely and the > server can not handle it. > > Does anyone have a rough idea when you change from MyISAM to InnoDB how the > performance is affected? That all depends on how you are using transactions. If you are trying to do each of these operations in a separate transaction, then definitely that will be a problem since transactions inherently have a certain cost to them since they need to commit changes to durable storage. If this is the case, then a horribly ugly "now you don't have durability any more in your transactions" hack you could try is setting innodb_flush_log_at_trx_commit to 2, see the docs for details. Be warned that doing so means you can loose committed transactions if the machine crashes. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Concurrency Question
Hi We have changed all our tables to InnoDB and now the server is not able to handle the load, even when we are not running the SELECTs statements against these tables yet. As I mentioned in my email we make a lots of INSERTS and UPDATES in these tables (more than 3000 per second). So far using MyISAM everything was OK, but now when we moved the tables to InnoDB (to be able to make Read/Write operations in these tables) the performance was down completely and the server can not handle it. Does anyone have a rough idea when you change from MyISAM to InnoDB how the performance is affected? I would appreciate any ideas you can have, we really need this ASAP. Thanks Javier` -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 July 2004 10:42 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Concurrency Question Javier Diaz <[EMAIL PROTECTED]> wrote on 02/07/2004 10:28:32: > We have some tables to record different data of the activity in our website. > The number of INSERT, DELETE and UPDATE operations in these tables is huge > (it could be more than 3000 a second). So far we don't have any speed > problems, all these tables are optimised using the right indexes and > everything is working ok. But now we are writing a Report Tool to get some > stats and figures from these tables. We have been doing a few tests and any > SELECT query taking more than one second or a few simultaneous SELECT, and > we have a real mess, lots of LOCKS. We definitely can not afford to slow > down the web site, and we have been thinking in a few possible solutions > > 1- Create a duplicate once a day of each of the tables we need to connect > from the Report Tool. We can do this in the period of less activity in the > site. > This a safest solution because we will be running all the SELECT's > against the duplicates and there are no risks to cause problems in the site > but we will > have the inconvenience that we can not get latest figures only the > previous days. Sounds like a nasty kludge to me. I really wouldn't be keen on it at all. > > 2- Use InnoDB instead of MyISAM, but we are not sure is this will be good > enough It strikes me that this is what InnoDB is designed for. In your situation, this is the first thing I would try. > 3- Replication of these tables to another server ?? This would also work: it just uses more resources (another computer of nearly equal power) and more development time (scripts to stop and start replication. If you can borrow the replicated machine, you could test the InnoDB solution on that: change the tables on the replicated server to InnoDB and try running your report generator on that. If the replications doesn't fall behind, the main server will probably handle it. Alec This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Concurrency Question
Hi everyone We have some tables to record different data of the activity in our website. The number of INSERT, DELETE and UPDATE operations in these tables is huge (it could be more than 3000 a second). So far we don't have any speed problems, all these tables are optimised using the right indexes and everything is working ok. But now we are writing a Report Tool to get some stats and figures from these tables. We have been doing a few tests and any SELECT query taking more than one second or a few simultaneous SELECT, and we have a real mess, lots of LOCKS. We definitely can not afford to slow down the web site, and we have been thinking in a few possible solutions 1- Create a duplicate once a day of each of the tables we need to connect from the Report Tool. We can do this in the period of less activity in the site. This a safest solution because we will be running all the SELECT's against the duplicates and there are no risks to cause problems in the site but we will have the inconvenience that we can not get latest figures only the previous days. 2- Use InnoDB instead of MyISAM, but we are not sure is this will be good enough 3- Replication of these tables to another server ?? We would appreciate a lot any ideas Thanks a lot Javier This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rows Counter
Hi everyone I need have a row counter in a query but I'm not sure if there is any way to do this. In essence all I need is get a result like this: Counter column-A column-B 1 A-1 B-1 2 A-2 B-2 : : : : : : where A, B are real columns and Counter in just a consecutive for each row in the query result. Thanks Javier This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a way to make mysql sgml aware?
Hi folks, Is there a way to make mysql sgml aware or any plan to do it in the near time? Leonardo J. Belen mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql mysql query sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Arguments to fight against Ms SQL Server and Oracle
Hi folks! I am sorry to bother but I need your help. At work I need to upgrade the data management the place is using (very old FOXPRO DOS) with something more modern. The use is only to store data and run multiple querys in a post mortem fashion. The data source is a Ms SQL server so management is thinking on upgrading directly to redmond's soft. The staff on the other hand, is thinking in using ORACLE, and I need very solid arguments to beet them. Any ideas I can borrow? Thanks Leo. MYSQL - QUERY - SQL - MYSQL - QUERY - SQL - MYSQL - QUERY - SQL - MYSQL - QUERY - SQL - MYSQL - QUERY - SQL - MYSQL - QUERY - SQL - MYSQL - QUERY - SQL
[ot] connection process is very slow under WIN NT 4.0
Hi I realize that this is may be off topic, but the remote connection times to MySQL under Windows NT 4.0 is really slow, while under Unix is quite responsible. Does anyone faced this problem and found a proper solution? because the project needs to reside on Windows and otherwise management will switch to ORACLE. Thanks in advance, Leonardo J. Belén. mysql query row select mysql query row select - Original Message - From: "Newsletter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 16, 2004 10:04 AM Subject: Administrator After install the MySQL Administrator version 1.0.2b alpha there is an error about a msvcr70.dll not found. This problem was found in Windows 98SE and Windows 2000 server systems. Thanks for your attention Reinaldo Melo Filho from Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: unauthenticated user
Well, this has been fixed, for your info, it was a problem from our DNS's with the reverse name process. Greets. Javier Tacon -Mensaje original- De: Javier Tacón [mailto:[EMAIL PROTECTED] Enviado el: martes, 20 de enero de 2004 11:23 Para: [EMAIL PROTECTED] Asunto: unauthenticated user Hi all, Today I have a strange problem, all the connections to mysql takes like 15-30 minuts to finally connect. When keeping an eye on the proccesslist I notice that I have a lot of these: | 4650 | unauthenticated user | 172.26.0.118:1037 | NULL | Connect | NULL | login | NULL | | 4651 | unauthenticated user | 172.26.0.118:1038 | NULL | Connect | NULL | login | NULL | | 4662 | unauthenticated user | 172.26.0.85:47976 | NULL | Connect | NULL | login | NULL | | 4701 | unauthenticated user | 172.26.0.85:47977 | NULL | Connect | NULL | login | NULL | | 4776 | unauthenticated user | 172.26.0.118:1039 | NULL | Connect | NULL | login | NULL | | 4785 | unauthenticated user | 172.26.0.118:1040 | NULL | Connect | NULL | login | NULL | | 4888 | unauthenticated user | 172.26.0.118:1041 | NULL | Connect | NULL | login | NULL | | 4896 | unauthenticated user | 172.26.0.118:1042 | NULL | Connect | NULL | login | NULL | I updated the mysql version to 4.1.1 a few days ago and all went correctly, but I downgraded to 4.0.x again, my old version, and the problem still exists event when I restart the mysql server. Anyone knows any possible reason for this trouble? May be something related with DNS servers (attacks) ? Can I debug to know more about this threads ? Thanks in advance. Javier Tacón ([EMAIL PROTECTED]) - Developer AZ Interactive, SL - (+34) 93 507 http://www.azinteractive.com <http://www.azinteractive.com/> :: http://www.justlamp.com <http://www.justlamp.com/> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unauthenticated user
Hi all, Today I have a strange problem, all the connections to mysql takes like 15-30 minuts to finally connect. When keeping an eye on the proccesslist I notice that I have a lot of these: | 4650 | unauthenticated user | 172.26.0.118:1037 | NULL | Connect | NULL | login | NULL | | 4651 | unauthenticated user | 172.26.0.118:1038 | NULL | Connect | NULL | login | NULL | | 4662 | unauthenticated user | 172.26.0.85:47976 | NULL | Connect | NULL | login | NULL | | 4701 | unauthenticated user | 172.26.0.85:47977 | NULL | Connect | NULL | login | NULL | | 4776 | unauthenticated user | 172.26.0.118:1039 | NULL | Connect | NULL | login | NULL | | 4785 | unauthenticated user | 172.26.0.118:1040 | NULL | Connect | NULL | login | NULL | | 4888 | unauthenticated user | 172.26.0.118:1041 | NULL | Connect | NULL | login | NULL | | 4896 | unauthenticated user | 172.26.0.118:1042 | NULL | Connect | NULL | login | NULL | I updated the mysql version to 4.1.1 a few days ago and all went correctly, but I downgraded to 4.0.x again, my old version, and the problem still exists event when I restart the mysql server. Anyone knows any possible reason for this trouble? May be something related with DNS servers (attacks) ? Can I debug to know more about this threads ? Thanks in advance. Javier Tacón ([EMAIL PROTECTED]) - Developer AZ Interactive, SL - (+34) 93 507 http://www.azinteractive.com <http://www.azinteractive.com/> :: http://www.justlamp.com <http://www.justlamp.com/>
Re: MySQL as document storage?
May be there is an option on the Commercial Market, BasisPlus from OpenText. I worked quite a lot with it but, sincerely, I prefer a MySQL table with references to files on the File System. A lot faster, and cheaper Now there is true that I use to work with sgml files and I still prefer them. I this case, you can even use TEXT columns and - if you use MyISAM tables - you can index them to use full text retrieval. On the other hand, BasisPlus has the ability to import all sort of data and index them, but you have to pay a high price for that... In conclusion, I still think that MySQL is your best choice here. Leo. AFIP-AR. - Original Message - From: "Ian O'Rourke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 6:06 PM Subject: Re: MySQL as document storage? > Original Message - > From: "Steve Folly" <[EMAIL PROTECTED]> > > > > At work we are currently investigating ways of filing all our > > electronic documents. > > I don't know the answer, but it's an interesting question. We are currently > looking at using more and more SQL (we use MySQL now in places), and we face > looking the issue of storing PDF files and such in a back-end. We also have > Lotus Domino - which is very good at this sort of thing - but I'd still be > interested in the discussion. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with query
Hi ALL!
I have a problem with this query, because it keeps failing and I dont
know why (it says that the concat statement is wrong but there is nothing on
the online docs...)
select st.id, concat(st.required), st.name from states st, agenda ag left
outer join ag.id=concat("AGE",st.required) where st.type='AGE' and st.id>0;
in this st.required is an int(7) and ag.id is a varchar(40).
Thanks
Leo.
Mysql sql query select,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: deleting mysql users
Thanks !! Do you happen to know why mysql decided not to erase those users?? On Fri, 10 Oct 2003 17:07:12 +0300 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Alejandro Javier Pomeraniec <[EMAIL PROTECTED]> wrote: > > > > Whenever i create a database user using GRANT command, mysql add a register inside > > the user table in mysql database. I've noticed that if i use REVOKE to revoke all > > privileges from that user, mysql does not delete the register from user table, but > > denies every permission for that user. What if i want to delete a user from user > > table? Should i delete it manually? is that safe? > > > > Yes, you should delete user manually. Don't forget about FLUSH PRIVILEGES. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
deleting mysql users
Hi !! Whenever i create a database user using GRANT command, mysql add a register inside the user table in mysql database. I've noticed that if i use REVOKE to revoke all privileges from that user, mysql does not delete the register from user table, but denies every permission for that user. What if i want to delete a user from user table? Should i delete it manually? is that safe? Thanks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb and fulltext
Actually I think it can be done, but I need some help on the hooks on MySQL and the approval of Heikki... The matter is that I can be an interesting mental exercise and I think that it is missing to be a real 'de facto' world wide product. Any help? Leo. - Original Message - From: "electroteque" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 9:09 AM Subject: innodb and fulltext > Hi i was wondering if there was ever going to be a time when Innodb can also > be fulltext indexable ? Being that i just started to work with Innodb and > cant believe how proper it feels of a relationional database over Myisam. > Like with Myisiam you cant set relationships up or is that going to change ? > As there has been a few projects which needs fulltext but would be good > setting up innodb aswell. > > Also when setting up relationships if i setup on delete to use cascade it > will delete all records from the other table joined to that row, this is a > wicked feature although, how can i still stop it from being deleted > accidently then ? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: Dump FK
On 01/09/2003 at 1:01 Chris Nolan wrote: >Hi! > >If you have a look at the documentation at www.innobase.com, you'll find >somewhere it mentions a few directives that you can use to turn off FK >checking for a temporary period. The solution to your problem is there. > Thanks for your reply. I only found a "DISABLE KEYS" command in ALTER TABLE nut it's a per table setting. When you dump a DB with --opt (disabling keys, etc) it [put a disable keys before insert data dumped but not before a "create table" statement. Then it doesn't work. I could not believe there are no clear command/setting for this simple and typicall procedure. :( Any idea ??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dump FK
Hi I've a DB using InnoDB tables and FK. If dump DB and try to import the resulting text file I receive many errors because at import time mysql try to import tables that have FK on tables not yet imported. How could I dump/import telling MySQL to order dump tables having in mine FK to avoid errors at import time ??? Thanks in advance.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can MySQL 4.0.14 store HTML? Among other things....
I think that the thing that really matters here is if we can do an sgml index (fulltext) on a MYISAM table, and if not how to achieve that goal (a really big one). - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Machiste' N. Quintana" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 5:31 PM Subject: RE: Can MySQL 4.0.14 store HTML? Among other things > [snip] > Hey. I'm New (as you probably can tell), and I was wondering if MySQL > 4.0.14 > can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it > would > be stored as a string, and if outputted by PHP, would it output as HTML? > (Or > JavaScript, PHP, or Flash) > [/snip] > > Yes, you can store anything in a MySQL database. It is just a matter of > getting it out later. I recommend a little soul searching with manuals > in hand. > > Have a pleasant day. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Edit my database in Server
Hi. In novice in this, can you tell me how application uses to edit your databases in your server (not in local). Did someone uses MySQL Control Center I cant configure it to works in remote. PS My english sucks
Connect with MySQL Control Center
Hi !! I just installed MySQL CC, in localhost it works fine. But I cant connect it with my remote MySQL database (server). The mistake may be that im not sure in the HOST field, please someone helpme. Thanks Javier (from Buenos Aires) P.S. Sorry for my terrible english.
Re: help with query
Thats good but what about a way query up and down only modifying a var, something like and hierichal search?. Leo. - Original Message - From: "CH Tsang" <[EMAIL PROTECTED]> To: "Leonardo Javier Belén" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 11:30 AM Subject: Re: help with query Hi Leo, how about this: select * from planttable where id like "01%" or id like "%02" CH Leonardo Javier Belén wrote: >Thanks but actually I'm looking for a way to return all the relations >upwards and downwards of a term. no matter the position (so I need general >query to do that. Any ideas? > >Thanks in advance. Leo. > > >- Original Message - >From: "Anthony Richardson" < >To: "Leonardo Javier BelÈn" <[EMAIL PROTECTED]> >Sent: Monday, January 13, 2003 9:52 PM >Subject: Re: help with query > > >Hi, > >I do not clearly understand your question, but if it's looking for >query, please try the following: > >select * from planttable >where substring(id, 1, 2)="01" and substring(id, 3,2)="02"; > > > >>Hi all! >>I would like to build a query that I can use to search hierichally >> >> >from > > >>an char(4) id composed as followed >>2positions for the class of plant (for example) >>and 2 positions for the type of flower (for example) >> >>if someone give me the id that means red rose tree, and I know there is >>another clasifications of tree and another colors for the rose, does anyone >>knows how to retrieve them. >> >>0100 - Rose tree >>0101 - pink rose tree >>0102 - red rose tree >>0103 - rococo rose tree >>0200 - generic tree >> >>Thanks in advance >>Leonardo J. BelÈn. >> >> >> >>query mysql sql blah! >> >> >> >>- >>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 >> >> > > >-- > >tony > >... but I was occupied all the more constantly on my silent route, >with trying to fix, at least in its more comprehensible and >characteristic details, that sense of the sublime and vast, which, as >time advances, usually grows contracted in our minds. >Goethe > > > > >- >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 > > > - 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
Re: help with query
Thanks but actually I'm looking for a way to return all the relations upwards and downwards of a term. no matter the position (so I need general query to do that. Any ideas? Thanks in advance. Leo. - Original Message - From: "Anthony Richardson" < To: "Leonardo Javier BelÈn" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 9:52 PM Subject: Re: help with query Hi, I do not clearly understand your question, but if it's looking for query, please try the following: select * from planttable where substring(id, 1, 2)="01" and substring(id, 3,2)="02"; >Hi all! > I would like to build a query that I can use to search hierichally from >an char(4) id composed as followed >2positions for the class of plant (for example) >and 2 positions for the type of flower (for example) > >if someone give me the id that means red rose tree, and I know there is >another clasifications of tree and another colors for the rose, does anyone >knows how to retrieve them. > >0100 - Rose tree >0101 - pink rose tree >0102 - red rose tree >0103 - rococo rose tree >0200 - generic tree > >Thanks in advance >Leonardo J. BelÈn. > > > >query mysql sql blah! > > > >- >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 -- tony ... but I was occupied all the more constantly on my silent route, with trying to fix, at least in its more comprehensible and characteristic details, that sense of the sublime and vast, which, as time advances, usually grows contracted in our minds. Goethe - 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
help with query
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is another clasifications of tree and another colors for the rose, does anyone knows how to retrieve them. 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 - generic tree Thanks in advance Leonardo J. Bel&alefmaks;n. query mysql sql blah! - 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
help with query
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is another clasifications of tree and another colors for the rose, does anyone knows how to retrieve them. 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 - generic tree Thanks in advance Leonardo J. Bel&alefmaks;n. query mysql sql blah! - 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
help with query
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is another clasifications of tree and another colors for the rose, does anyone knows how to retrieve them. 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 - generic tree Thanks in advance Leonardo J. Bel&alefmaks;n. query mysql sql blah! - 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
help with query
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
another clasifications of tree and another colors for the rose, does anyone
knows how to retrieve them.
0100 - Rose tree
0101 - pink rose tree
0102 - red rose tree
0103 - rococo rose tree
0200 - generic tree
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Rodney Broom" <[EMAIL PROTECTED]>
Cc: <>
Sent: Thursday, January 09, 2003 2:41 AM
Subject: Re: converting text to hypertext
> Rodney Broom wrote:
>
> >If so, then the answer is that there isn't such a data type. If you
> want a link, then you'll have to make it yourself. I suggest making your
> column a varchar(). Then, you ~might~ get the data with a query like
> this:
> >
> > SELECT CONCAT(CONCAT(''), link, '') FROM
> stuff;
> >
> >
>
> But please remember, as was said earlier, to use the appropriate
> escaping functions for your language to make sure link contains no
> special HTML characters in the second instance and no URL characters in
> the first.
>
> --
> Michael T. Babcock
> C.T.O., FibreSpeed Ltd.
> http://www.fibrespeed.net/~mbabcock
>
>
>
>
> -
> 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
-
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
Re: MySQL AB has reached a settlement with NuSphere Corporation
Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: "Christopher Hicks" <[EMAIL PROTECTED]> To: "Michael Widenius" <[EMAIL PROTECTED]> Cc: "Mysql List" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation > On Thu, 7 Nov 2002, Michael Widenius wrote: > > MySQL AB is pleased to announce that it has settled its lawsuit with > > Progress Software Corporation and NuSphere Corporation. For more > > information, see the joint press release at > > > > http://www.mysql.com/press/release_2002_14.html > > The press release sounds like typical PR puffery. Is any meat going to > come out beyond "it's settled"? > > -- > > > Programming is a Dark Art, and it will always be. The programmer is > fighting against the two most destructive forces in the universe: > entropy and human stupidity. They're not things you can always > overcome with a "methodology" or on a schedule. > -Damian Conway, Perl God > > > - > 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 - 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
A way to get into the code to add functionality to FullText Searches
Hi Just I wondering the posibility of adding some functionality to MySQL MyISAM fulltext functionality, but I am quite confused. I read the ft_* files under $(MYSQL)/myisam, and there is nothing I can do. I'm wondering to add SGML support to FullText searches, so I need to exclude every thing between "<" and ">" for a start point. This way at least we can assume that HTML, XML and all the flavors of them can be correctly indexed for retrieval. This leads to an interesting matter: we may need to develop a dinamically update structure to hold the stopwords instead of the compiled in one. For now, I need the answer to a few things. a) am I in the right list? b) has anyone try to add it? c) where the hell registered a environmental variable? d) which is the function that actually build the index? Cheers, Leonardo Javier Belén. AFIP-AR - SQL, SQL, QUERY, MYSQL, SQL, SQL -- - Original Message - From: "Lenz Grimmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 7:44 AM Subject: Re: mysql 4.x for debian? > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wednesday 06 November 2002 11:20, andy thomas wrote: > > > > Does MySQL AB plan to release deb paketes or will > > > MySQL AB support or encourage the debian pakete maintainers? > > > > I think MySQL policy is to support generic packaging formats > applicable to > > all platforms. Proprietary packaging formats such as those used by > Debian, > > Red Hat, etc are not directly supported but contributed by others. > > Actually, this is not a case - it's more a question of manpower and > knowledge :) > > Yes, we plan to add more package formats apart from tarballs in the > future, > it's on my TODO. Debian packages are quite high on the priority list > there, > but I don't know, when I will be able to start with it - I have a lot of > RPM background, but I need to read up on how to build DEBs. Do I need to > have Debian installed? Or is it sufficient to install the required tools > on another distribution? > > Bye, > LenZ > - -- > For technical support contracts, visit https://order.mysql.com/?ref=mlgr >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer > /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ><___/ www.mysql.com > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.0 (GNU/Linux) > > iD8DBQE9yPJzSVDhKrJykfIRAkXQAJkBqudCfsQAymAZ1+JFY+QGIh54rwCeIvHW > LM5S9IQwqVfnxLMsS7BaHl0= > =2Hwz > -END PGP SIGNATURE- > > - > 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 - 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
RE: query help
It seems that you have two entries in the products table for the same fg_number, one with the values: 'SPKR,CM8HD', 'FG00914', '8",HIGH DEFINITION,CEILING MNT LOUDSPEAKER' And a second one with the same fg_number but in this case with a lowercase F. '', 'fg00914', '' Is this rigth? Please, if you find a good resource for complex queries advise me. I also have the DuBois book, and I need more advanced for advanced queries with mySql. Regards Javier > -Mensaje original- > De: Michael Knauf/Niles [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 08 de octubre de 2002 14:48 > Para: [EMAIL PROTECTED] > Asunto: query help > > > Here's a query for ya: > > SELECT products.product_name, products.fg_number, > products.product_description, specs.spec_name, > specs.spec_value FROM products LEFT JOIN specs ON > products.fg_number = specs.fg_number WHERE > products.fg_number='fg00914'; > > and here's the result: > +--+---+-- > --+--+ > -- > -+ > | product_name | fg_number | product_description > | > spec_name| spec_value > | > +--+---+-- > --+--+ > -- > -+ > | | fg00914 | > | > Woofer | "8 injection-molded TCC (talc) test > | > | | fg00914 | > | > Tweeter | 1 fluid-cooled ultra-wide dispersion > tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | > | | fg00914 | > | > Recommended amplifier power | 10 to 150 watts > | > | | fg00914 | > | > Frequency | 40Hz-21kHz +/- 3dB > | > | | fg00914 | > | > Sensitivity | 90dB For 2.83V pink noise > | > | | fg00914 | > | > Impedance | 4 or 8 ohm selectable > | > | | fg00914 | > | > Dimensions | 10-5/8 diameter > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Woofer | "8 injection-molded TCC (talc) test > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Tweeter | 1 fluid-cooled ultra-wide dispersion > tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Recommended amplifier power | 10 to 150 watts > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Frequency | 40Hz-21kHz +/- 3dB > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Sensitivity | 90dB For 2.83V pink noise > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Impedance | 4 or 8 ohm selectable > | > | SPKR,CM8HD | FG00914 | 8",HIGH DEFINITION,CEILING MNT > LOUDSPEAKER | > Dimensions | 10-5/8 diameter > | > +--+---+-- > --+--+ > -- > -+ > 14 rows in set (0.00 sec) > > I get 7 rows of data I don't want, then the 7 rows of data I > do want... and after scratching my head for awhile, I've come > to the conclusion that I do not understand the query > structure. (the query came from multiple suggestions in > response to my last posting on this list, so clearly it makes > sense to some of you...) > > Can somebody point me to a resource on complicated > multi-table select statements? I have the Paul DuBois "MySQL" > book, which got me from 0 to where I am now, but isn't > getting me past this particular query. Or maybe just explain > how to get the last 7 rows without the first? --it's > duplicating
Select IN and NOT IN
Hello everybody, I have a next problem to get a query working. I have some tables. A User has Phone numbers and Calls associated with each phone. # Example: All the calls of the user number 1 SELECT Call.* FROM User, Phone, Call WHERE Phone.User=1 AND Call.Phone=Phone.PhoneNumber A User has also an agenda with ContactGroups an Contacts, where the contact has also a phone number. #Al the contacts for the user 1 SELECT Contact.* FROM User, ContactGroup, Contact WHERE ContactGroup.User=1 AND Contact.ContactGroup=ContactGroup.ContactGroupId What I want to retrieve is a list with all the calls, but with the contact associated to the called number (if that contact exists) or a text showing that the call is no assigned to a contact. I have tried something like this: SELECT IFNULL(Contact.Name, 'Not Assigned'), Call.* FROM User, Phone, Call LEFT JOIN ContactGroup ON ContactGroup.User=1 LEFT JOIN Contact ON Contact.ContactGroup=ContactGroup.ContactGroupId WHERE (Contact.PhoneNumber=Call.CalledNumber OR Contact.PhoneNumber IS NULL) AND Phone.User=1 AND Call.Phone=Phone.PhoneNumber It works with calls that have the called number in the user contact list, but the query repeat the calls for each group that don't have received calls (the effect of the "OR Contact.PhoneNumber IS NULL"). I don't know if I'm missing something or this cannot be done with MySql. I think that this could be done with a Temp table, but I need to do it in only a query. Any idea about how to do it? Regards Javier *Note: The tables are simplified because they were named in Spanish and there were more tables used to filter the calls, but they are not related with my problem - 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
Re: Set Path Environment
Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in "\windows". A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this helps. Leonardo Javier Belen. AFIP-AR Spam: sql, query, mysql - Original Message - From: "William Martell" <[EMAIL PROTECTED]> To: "MySQL Main List" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 11:38 PM Subject: Fw: Set Path Environment > This is more information regarding the Path for my machine. It shows the > default PATH information and the PATH information after I perform the SET > PATH command. It also shows how MySQL responds after I type MySQL at the > command prompt. > > Thanks in Advance, > William > > > > C:\>path > PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem > > C:\>SET > PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W > bem > > C:\>path > PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W > bem > > C:\>mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 6 to server version: 3.23.52-nt > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > > - Original Message - > From: "William Martell" <[EMAIL PROTECTED]> > To: "MySQL Main List" <[EMAIL PROTECTED]> > Sent: Tuesday, September 24, 2002 9:33 PM > Subject: Set Path Environment > > > > Hello All, > > > > I am having trouble with MySQL in dos. When I type in mysql from the c:\> > > prompt, I get the following error: > > > > C:\>mysql > > 'mysql' is not recognized as an internal or external command, operable > > program or batch file. > > > > I tried the SET PATH command and this works fine when I have dos open. > But > > when I start another session of dos later the settings are gone. > > > > Does anyone know how to set this as the default path?? > > > > Thank you very much for your assistance and have a nice day. > > > > William > > > > > - > 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 - 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
Fw: A new Idea for FULLTEXT searchs
mysql, query speed up, sql _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is not the object and isnt mine either. May be we can add a NEW FEATURE ON INDEXING AND FULLTEXT that consists on avoiding the indexing of tags (as groups of words embrassed by "<" and ">"), and support to add new rules to this one. In this case, we may use direct HTML code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - 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
Re: Server shutdown
I tell you that there is a simple script under whatever/mysql/share/ that is called "mysql.sever" and it manages the mysql server in a very fashionable way: simply type "mysql.server start" or "mysql.server stop". I use the script to launch the server when my linux box starts. Another posibility is to use the kill command: just type > ps -aux | grep mysqld and then > kill -TERM << and the last of the processes ID >> I hope this can help you to get into the fascinating world of MySQL. Leonardo Javier Belen. AFIP-AR - Original Message - From: "Shravan Durvasula" <[EMAIL PROTECTED]> To: "MySQL HELP" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 4:17 PM Subject: Server shutdown > Hi all, > > I am completely new to MySQL. I installed the source > version of MySQL on Solaris 2.8. I did > "mysql_install_db". > > I started the server by saying > "bin/safe_mysqld --user=mysql &". The server started > my creating "mysql.sock" file in the /tmp directory. > Now i > want to stop the server. How should i do it? > > I did "bin/mysqladmin -u mysql shutdown" > The error message that came up was: > ** > /home/shravan/extra/mysql/bin/mysqladmin: shutdown > failed; error: 'Access denied for user: '@localhost' > (Using password: NO)' > ** > > I also tried "bin/mysqladmin -u root shutdown" and > also > "bin/mysqladmin -u shravan shutdown". But i could not > get the server down. > > Could anyone please help? > > Best Regards and thanks in advance, > skd > > __ > Do you Yahoo!? > Yahoo! News - Today's headlines > http://news.yahoo.com > > - > 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 - 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
A new Idea for FULLTEXT searchs
mysql, query speed up _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is not the object and isnt mine either. May be we can add a NEW FEATURE ON INDEXING AND FULLTEXT that consists on avoiding the indexing of tags (as groups of words embrassed by "<" and ">"), and support to add new rules to this one. In this case, we may use direct HTML code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - 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
Problem compiling mysql-3.23.52
Hello I'm having a problem compiling the version of the subject, the problem is with the gethotsbyname function and the message is the next: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/opt/src/apache/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Thanks Javier Suarez - 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
Problem compiling mysql-3.23.52
Hello Im having a problem compiling the version of the subject, the problem is with the gethotsbyname function and the message is the next: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/opt/src/apache/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/src/apache/mysql-3.23.52' make: *** [all-recursive-am] Error 2 The system is Suse 8.0 and the Glibc is the glibc-2.2.5-38 Any solution or should I install the RPM from Suse? :-( Thanks Javier Suarez - 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
Cannot create tables with ODBC
Well, just that thing. I'm able to search, retrieve and update Mysql tables (server located on a Linux Box) but I cannot create tables, nor modify its structures. Does anyone knows why. Leonardo Belen. Afip AR PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM. - 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
RE: Insert date format
Hello,
> > I am developing an aplication where I need format the date for
> > inserting into mySQL.
>
> =what language is your application written in?
> =dn
The application is written in Java, but the problem is that the module
where the dates for the DB are managed is an open source framework and I
wouldn't like to touch that code.
The framework provides a way to modify the dates from/to the database
defining native database functions in a config file.
Anyway, the problem is alredy solved, but I still have the dude if I
there is a better solution.
Regards
Javier
>
>
> > With DATE_FORMAT I can format the mySQL date to "my date", but I
> > haven't found a good way to format "my date" to the mySQL date.
> >
> > My format is 'dd-mm-' and to convert it to '-mm-dd'
> I'm using
> > the next sequence:
> >
> > SELECT DATE_FORMAT(
> > CONCAT(
> > SUBSTRING_INDEX('03-05-2002', '-', -1),
> > '-',
> > SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2),
> > '-', -1),
> > '-',
> > SUBSTRING_INDEX('03-05-2002', '-', 1)),
> > '%Y-%m-%d' );
> >
> > I have searched in the manual, the list and in the DuBois'
> book, but I
> > haven't found a single function to parse my date to the
> mySQL date. Is
> > that rigth? Is there no function to parse from any date to
> the mySQL
> > date?
> >
> > Regards
> >
> > Javier
> >
> >
> >
> >
> -
> > 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
> >
> >
>
-
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
Insert date format
Hello,
I am developing an aplication where I need format the date for inserting
into mySQL.
With DATE_FORMAT I can format the mySQL date to "my date", but I haven't
found a good way to format "my date" to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the next sequence:
SELECT DATE_FORMAT(
CONCAT(
SUBSTRING_INDEX('03-05-2002', '-', -1),
'-',
SUBSTRING_INDEX(SUBSTRING_INDEX('03-05-2002', '-', 2),
'-', -1),
'-',
SUBSTRING_INDEX('03-05-2002', '-', 1)),
'%Y-%m-%d' );
I have searched in the manual, the list and in the DuBois' book, but I
haven't found a single function to parse my date to the mySQL date. Is
that rigth? Is there no function to parse from any date to the mySQL
date?
Regards
Javier
-
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
RE: Inno DB Question
Heikki,
Thanks for your answer. I was yesterday making other tests using dbExpress
components and the only way that I found so far to get the dbExpress
components working on transactions on MySQL is using the method ExcuteDirect
of the TSQLConnection. This is the code :
TSQLConnection *Conn;
Conn = SQLConnection1->CloneConnection();
Conn->Connected=true;
Conn->ExecuteDirect("BEGIN");
Conn->ExecuteDirect("INSERT INTO regn_info VALUES('t3','test1')");
Conn->ExecuteDirect("INSERT INTO regn_info VALUES('t4','test2')");
Conn->ExecuteDirect("COMMIT");
But I don't know why is impossible to do the same using the normal
TSQLQuery. I already sent the message to the borland newsgroups.
Thanks
Javier
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: 02 September 2002 20:06
To: [EMAIL PROTECTED]
Subject: Re: Inno DB Question
Javier,
it may be that the dbExpress interface is still lagging behind MySQL
development.
If I recall right, people have complained loudly in Borland newsgroups that
dbExpress created a new connection for each SQL query it issues to MySQL.
That makes the use of transactions impossible with it.
If this has not been fixed in the latest version of dbExpress, it would be
good if you would write to Borland people about this, or to the Borland
newsgroups.
Regards,
Heikki
Innobase Oy
- Original Message -
From: "Javier Diaz" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 3:06 PM
Subject: Inno DB Question
> Hi all,
>
> I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
> connect to MySQL. I'm trying to use the new dbExpress component for
Borland
> to connect to MySQL using the libmysql.dll
>
> I have been making some tests with transactions using the dbExpress
> components and the normal ODBC but I can't get the ROLLBACK function to
> work.
> Here are some examples:
>
> using dbExpress
>
> TSQLConnection Q;
> Q= new TSQLQuery(Application);
> Q->SQLConnection=SQLConnection1;
>
> /* I test with and without BEGIN
> Q->SQL->Clear();
> Q->SQL->Add("BEGIN");
> Q->ExecSQL();
> */
>
> Q->SQL->Clear();
> Q->SQL->Add("SET AUTOCOMMIT=0");
> Q->ExecSQL();
>
> Q->SQL->Clear();
> Q->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
> Q->ExecSQL();
>
>
> Q->SQL->Clear();
> Q->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
> Q->ExecSQL();
>
> Q->SQL->Clear();
> Q->SQL->Add("ROLLBACK");
> Q->ExecSQL();
>
> //--
> Using ODBC
>
>
> TQuery *Q_ODBC;
> Q_ODBC= new TQuery(Application);
> Q_ODBC->DatabaseName="salsadb";
>
> /*
> Q->SQL->Clear();
> Q->SQL->Add("BEGIN");
> Q->ExecSQL();
> */
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("SET AUTOCOMMIT=0");
> Q_ODBC->ExecSQL();
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
>
> Q_ODBC->ExecSQL();
>
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
> Q_ODBC->ExecSQL();
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("ROLLBACK");
> Q_ODBC->ExecSQL();
>
> In both cases the ROLLBACK dosen't work and I get the inserted values in
the
> table.
>
> Any idea what can be happening?
>
> Thanks a lot
>
> Javier Diaz
>
>
>
> --
>
> This e-mail is intended for the named addressee only. It may contain
confidential and/or privileged information. If you have received this
message in error, please let us know and then delete this message from your
system. You should not copy the message, use it for any purpose or disclose
its contents to anyone.
>
>
>
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/
RE: Inno DB Question
Hi Tod, thanks for your answer.
I changed the code to this
Q->SQL->Clear();
Q->SQL->Add("SET AUTOCOMMIT=0");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("BEGIN");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("ROLLBACK");
Q->ExecSQL();
And now for the ODBC connection is working fine, but the same code using
TSQLQuery (dbExpress Component) dosen't work. Do you have any idea what can
be the reason?
Thanks
Javier
-Original Message-
From: Tod Harter [mailto:[EMAIL PROTECTED]]
Sent: 02 September 2002 15:58
To: Javier Diaz
Subject: Re: Inno DB Question
On Monday 02 September 2002 07:37 am, you wrote:
I would think you would want to set autocommit BEFORE you call "BEGIN" since
that starts your transaction. My guess would be that setting autocommit
clears any existing transaction. In the case without the begin and
autocommit set to 0 I don't really know what is going to happen...
Essentially you're telling the database "I'll tell you when to create a
transaction" and then you don't create one. I can only assume the behaviour
is that mysql goes back to the 'autocommit 1' state at that point since
otherwise whatever you're doing makes no sense.
> Hi all,
>
> I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
> connect to MySQL. I'm trying to use the new dbExpress component for
Borland
> to connect to MySQL using the libmysql.dll
>
> I have been making some tests with transactions using the dbExpress
> components and the normal ODBC but I can't get the ROLLBACK function to
> work.
> Here are some examples:
>
> using dbExpress
>
> TSQLConnection Q;
> Q= new TSQLQuery(Application);
> Q->SQLConnection=SQLConnection1;
>
> /* I test with and without BEGIN
> Q->SQL->Clear();
> Q->SQL->Add("BEGIN");
> Q->ExecSQL();
> */
>
> Q->SQL->Clear();
> Q->SQL->Add("SET AUTOCOMMIT=0");
> Q->ExecSQL();
>
> Q->SQL->Clear();
> Q->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
> Q->ExecSQL();
>
>
> Q->SQL->Clear();
> Q->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
> Q->ExecSQL();
>
> Q->SQL->Clear();
> Q->SQL->Add("ROLLBACK");
> Q->ExecSQL();
>
> //--
> Using ODBC
>
>
> TQuery *Q_ODBC;
> Q_ODBC= new TQuery(Application);
> Q_ODBC->DatabaseName="salsadb";
>
> /*
> Q->SQL->Clear();
> Q->SQL->Add("BEGIN");
> Q->ExecSQL();
> */
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("SET AUTOCOMMIT=0");
> Q_ODBC->ExecSQL();
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
>
> Q_ODBC->ExecSQL();
>
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
> Q_ODBC->ExecSQL();
>
> Q_ODBC->SQL->Clear();
> Q_ODBC->SQL->Add("ROLLBACK");
> Q_ODBC->ExecSQL();
>
> In both cases the ROLLBACK dosen't work and I get the inserted values in
> the table.
>
> Any idea what can be happening?
>
> Thanks a lot
>
> Javier Diaz
>
>
>
> --
>
> This e-mail is intended for the named addressee only. It may contain
> confidential and/or privileged information. If you have received this
> message in error, please let us know and then delete this message from
your
> system. You should not copy the message, use it for any purpose or
> disclose its contents to anyone.
>
>
>
> This e-mail has been scanned for all viruses by Star Internet. The
> service is powered by MessageLabs. For more information on a proactive
> anti-virus service working around the clock, around the globe, visit:
> http://www.star.net.uk
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
&
Inno DB Question
Hi all,
I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to
connect to MySQL. I'm trying to use the new dbExpress component for Borland
to connect to MySQL using the libmysql.dll
I have been making some tests with transactions using the dbExpress
components and the normal ODBC but I can't get the ROLLBACK function to
work.
Here are some examples:
using dbExpress
TSQLConnection Q;
Q= new TSQLQuery(Application);
Q->SQLConnection=SQLConnection1;
/* I test with and without BEGIN
Q->SQL->Clear();
Q->SQL->Add("BEGIN");
Q->ExecSQL();
*/
Q->SQL->Clear();
Q->SQL->Add("SET AUTOCOMMIT=0");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
Q->ExecSQL();
Q->SQL->Clear();
Q->SQL->Add("ROLLBACK");
Q->ExecSQL();
//--
Using ODBC
TQuery *Q_ODBC;
Q_ODBC= new TQuery(Application);
Q_ODBC->DatabaseName="salsadb";
/*
Q->SQL->Clear();
Q->SQL->Add("BEGIN");
Q->ExecSQL();
*/
Q_ODBC->SQL->Clear();
Q_ODBC->SQL->Add("SET AUTOCOMMIT=0");
Q_ODBC->ExecSQL();
Q_ODBC->SQL->Clear();
Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t1','test1')");
Q_ODBC->ExecSQL();
Q_ODBC->SQL->Clear();
Q_ODBC->SQL->Add("INSERT INTO regn_info VALUES('t2','test2')");
Q_ODBC->ExecSQL();
Q_ODBC->SQL->Clear();
Q_ODBC->SQL->Add("ROLLBACK");
Q_ODBC->ExecSQL();
In both cases the ROLLBACK dosen't work and I get the inserted values in the
table.
Any idea what can be happening?
Thanks a lot
Javier Diaz
--
This e-mail is intended for the named addressee only. It may contain confidential
and/or privileged information. If you have received this message in error, please let
us know and then delete this message from your system. You should not copy the
message, use it for any purpose or disclose its contents to anyone.
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
-
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
Re: mysql password ( )
I dont know if it helps, but I dont decrypt, instead, I compare the crypted value on the DB against the output of the function PASSWORD() filled with the pwd I get from the user... It works for me (and I'm using APACHE and MySQL all in plain "ANSI C"). Leonardo Javier Belén. AFIP-AR - Original Message - From: "Mark Stringham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 1:47 PM Subject: mysql password ( ) > I have used the mysql password(\"$pass \") function in the past to > encrypt > passwords into the db. but can not decrypt them if needed. I know this > is > not something new. > > Is there a better way to protect passwords in the db and then decrypt > them > if needed ? > > Thanks > > Mark > > > - > 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 - 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
Fw: MySQL Table size
AIX if you didnt set the Large File System on, and some Linux Kernels. However, they dont limit anything but any file in the system to that size. For instance, the same see the OS if you have a 2,5 GB (not allowed - too big) or a 2,5 db file (the same reason) thats why there are out there some work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Bel&alefmaks;n. AFIP-AR. - Original Message - > From: "Scott Pippin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 27, 2002 12:17 PM > Subject: MySQL Table size > > > > Which Operating Systems limit MySQL to a 2GB table size? > > > > - > > 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 > - 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
Re: MySQL Table size
AIX if you didnt set the Large File System on, and some Linux Kernels. However, they dont limit anything but any file in the system to that size. For instance, the same see the OS if you have a 2,5 GB (not allowed - too big) or a 2,5 db file (the same reason) thats why there are out there some work arounds, like the Innodb. I hope this will make you an idea. Leonardo Javier Bel&alefmaks;n. AFIP-AR. - Original Message - From: "Scott Pippin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 27, 2002 12:17 PM Subject: MySQL Table size > Which Operating Systems limit MySQL to a 2GB table size? > > - > 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 - 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
change name of one column
MySQL > Hi, I would like to change the name of one column of > a > table. > > I did: > ALTER TABLE name_table ALTER COLUMN old_column > RENAME > new_column > > but it did not work due to don't understand a RENAME > after ALTER COLUMN. > > > Could someone help me? > > Thanks a lot. > > > ___ > Yahoo! Messenger > Nueva versión: Webcam, voz, y mucho más ¡Gratis! > Descárgalo ya desde http://messenger.yahoo.es > ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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
About insatallation on Linux
> Hi everybody: > Well i have all redy work with mysql instalation on > win xp = (, and for some reasons i migriate to > linux. > > i follow the typical instalation of : > > making the user and group for mysql. ok > configurate the ./config stuff with the > --prefix=/usr/local/mysql > then when i run the make and the make install a > message appers in my shell, which say i this is a > compiled distribution ready for run. so ... : > > i make the mysql dir at /usr/local/ and create de > link > and all the chown and chgrp comands and then run the > mysqladmin -u root and -h host command to stablish a > password and FINALLY the questions are: > > - Who in earth i can run the daemon? > - is the installation correct? > - is there any other config that mysql need to use > PHP? > - Some advices please... = ) __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
About insatallation on Linux
Hi everybody: How would like to answer some newbie questions ? Well i have all redy work with mysql instalation on win xp = (, and for some reasons i migriate to linux. i follow the typical instalation of : making the user and group for mysql. ok configurate the ./config stuff with the --prefix=/usr/local/mysql then when i run the make and the make install a message appers in my shell, which say i this is a compiled distribution ready for run. so ... : i make the mysql dir at /usr/local/ and create de link and all the chown and chgrp comands and then run the mysqladmin -u root and -h host command to stablish a password and FINALLY the questions are: - Who in earth i can run the daemon? - is the installation correct? - is there any other config that mysql need to use PHP? - Some advices please... = ) __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - 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
Incorrect replication user time
Hi. I recently update my servers from 3.23.29 to 3.23.51 version. Replication alwais works fine. Now, when I send show processlist command to slave, this is the response: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) The system user time used by replication always starts at 664 seconds (0 must be correct). The intervals are correct. Two seconds more without replication updates and Show processlist says: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) Correct! And in new update, Show processlist says: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) Incorrect again. All the servers are updated to 3.23.51 and replication works fine excepts this. Any sugestion?. Sorry for my limited English. Javier. - 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
RE: Left join?
Hi, I have a similar problem (with phones & calls) but I would like to select only those elements that have less than a number. Using the previous example, is like selecting only those interest elements that have less that 5 members associated. Something like this (obviously this doesn't work) SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, i.name FROM member_interests AS mi left join outer interests AS i on mi.interest_id = i.id AND count < 5 GROUP BY mi.interest_id ORDER BY i.name Does anyone have an idea to solve this kind of problem? Does anyone know where can I find a web site with complex queries? Thank you Javier > -Mensaje original- > De: Cal Evans [mailto:[EMAIL PROTECTED]] > Enviado el: martes 4 de junio de 2002 22:48 > Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Asunto: RE: Left join? > > > SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, >i.name > FROM member_interests AS mi left join outer interests AS i on > mi.interest_id = i.id > GROUP BY mi.interest_id > ORDER BY i.name > > You are correct, a left outer join is what you need. > > > * > * Cal Evans > * Journeyman Programmer > * Techno-Mage > * http://www.calevans.com > * > > > -Original Message- > From: Daren Cotter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 04, 2002 2:07 PM > To: [EMAIL PROTECTED] > Subject: Left join? > > > I have the following tables: > > Member_interests: > Member_id > Interest_id > > Interests: > Name > Interest_id > > I need a query that selects each interest name, and the # of members who > have selected it...sample output: > Boating 25 > Hiking10 > .. > Swimming 0 > Jumping 0 > Talking 0 > > The following query works great, but does not display the Interest names > with 0 members: > SELECT DISTINCT(mi.interest_id), COUNT(*) AS count, i.name FROM > member_interests AS mi, interests AS i WHERE mi.interest_id = i.id GROUP > BY mi.interest_id ORDER BY i.name > > Is there a way to have the "0"'s displayed as well? I'm thinking a left > join would probably be involved? > > > - > 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 > > > > - > 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 - 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
Server speed working with databases and apache
Hi everybody: I´m looking for some information about server speed. The problem: I need a server for about 40 concurren users, it will be in an internal net, the server will manage a mysql database with a master table of about 4000 records and some chil tables from 2 to 4 records, it will be accesed trougth apache with php. I need a response time about 0.1-0.2 seconds. Is there some information or good article about this issue What kind of machine would be better? Can anybody give me some information or reference??? Thanks a lot Sorry about my english Javier Armendáriz [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
Re: Cross querying databases (again)
If your default is '0', I think, the new query should work. Thanks Javier - Original Message - From: Donna Robinson <[EMAIL PROTECTED]> To: Javier <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 7:14 PM Subject: Re: Cross querying databases (again) > Hi, > > u r my hero. I never, never would have thought of that! And it's so bloody > obvious - i guess this is where experience comes in (sigh) > > well, i havent checked if this is the solution yet (have to rush off to go > dancing), but the declaration is: > ddref smallint(5) unsigned NOT NULL default '0', > > so if i said: > SELECT dancedata.dances.* FROM dancedata.dances > LEFT JOIN dancedetails.dances > ON dancedata.dances.dkey=dancedetails.dances.ddref > WHERE dancedetails.dances.ddref=0; > might that be the (a?) solution? > > Donna > > - Scanned for all known viruses by Messagelabs -- - Scanned for all known viruses by Messagelabs -- - 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
What is the best way to do this
Hi everybody, I need do the following: I have two MySQL tables, Table1 . . field-n . . Table2 . . field-m . . and are both varchar(100) containing words separated by space. I need to find out if any of the words in also are in . Is it possible to do that? What is the best way for it? Thanks Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - 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 forum
Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for one. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
adding users to mysql
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
adding users to mysql
hi: i have the next question. how can i add a user to mysql with the console or shell ? how can i do the same posses from a php script or application from the Internet? thanks _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
What is wrong in this query???
Can someone tellme the problem in this query?? Is there any problem updating two tables in the same query??? update alumno, alumnocurso set alumno.nombre='Blas', alumno.apellidos='Martinez Maertinez', alumno.nacimiento='1990-09-12', alumno.telefono = '6', alumnocurso.incorporacion = '2002-3-16', alumnocurso.finalizacion='-0-0', alumnocurso.observaciones = 'Observaciones id 4' where alumno.id = '4' and alumnocurso.id = '4' and alumno.id = alumnocurso.id_alumno ; - 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
C API Question
Hi, I have a text file , with several MySQL instructions (CREATE TABLE, INSERT, SET @var, etc.). I want to execute all these instructions from a C program , using the API. It is possible to use the function mysql_query(), to execute all the instructions contained in the file in a single call to this function? , Can I execute several MySQL instructions in one only call to mysql_query() function? If it is possible, which is the best way to do this? Thanks in advance Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - 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
insert and select
Hi: how i can insert and select information at the same time. first i want to insert the information relative to the client and after that i need to select the same information on the same query. that is possible _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
Order By and Use Index
Hi all, I have a table like that table1: field1 field2 . . . where : field1,field2 is the primary key. When I make this query: SELECT * FROM table1 USE INDEX(PRIMARY) I get a different result, if I make this: SELECT * FROM table1 ORDER BY field1,field2 Why? Is not the same? What is the default order, that MySQL use if for this table, I make : SELECT * FROM table1 thanks in advance Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - 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
xml
hi everybody: i was talking with a developer and he told the next thing: "if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration" then he says. "the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar". Well, now I´m cofused. Some one can help me with this "is that true", is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - 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
Sum function question
Hi, I have a table like this Key Field-1 A string1 A string2 A string3 B string1 B string 2 I want to create a query to get the following result (only one line by key field): A - string1,string2,string3 B - string1,string2 I try to use the Sum function but it only works on numbers, ( the number of occurrences of key field, is unknown) Thanks in advance for any advice that you might have. Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- - 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
Problem
I have a problem, when I try to connect to the Data Base [root@hvserver_tja bin]# mysql bash: mysql:command not found [root@hvserver_tja bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock' (2) [root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p Enter password:ricardo ERROR 2003:Can't connect to MySQL server on 'hvserver_tja' (111) please if somebody can help me, I hope your e-mail _ MSN Photos es la manera más sencilla de compartir, editar e imprimir sus fotos favoritas. http://photos.latam.msn.com/Support/WorldWide.aspx - 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
Sum function question
- Original Message - From: Javier <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 2:47 PM Subject: Sum function question > Hi, i have a table like this > > Key Field-1 > A string1 > A string2 > A string3 > B string1 > B string 2 > > I want to create a query to get the following result (only one line by key > field): > > A - string1,string2,string3 > B - string1,string2 > > I try to use the Sum function but it only works on numbers, ( the number of > occurrences of key field, is unknown) > > Thanks in advance for any advice that you might have. > > Javier > - Scanned for all known viruses by Messagelabs -- - 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
Sum function question
Hi, i have a table like this Key Field-1 A string1 A string2 A string3 B string1 B string 2 I want to create a query to get the following result (only one line by key field): A - string1,string2,string3 B - string1,string2 I try to use the Sum function but it only works on numbers, ( the number of occurrences of key field, is unknown) Thanks in advance for any advice that you might have. Javier - Scanned for all known viruses by Messagelabs -- - 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
problems with the daemon
hi i=B4m starting with linux and i want to install the daemon of mysql...= =20 please help. i all ready read the documentation and the man pages but i dont understand= ... help _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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 - 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
problems with the daemon
hi i´m starting with linux and i want to install the daemon of mysql... please help. i all ready read the documentation and the man pages but i dont understand ... help _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
Problem with latest solaris 8 binary distribution?
The tarball seems to be missing libmysqlclient.so, I can get the database server started fine, and can connect to it using client applications. However, any attempt at using the dynamic client libs fails for obvious reasons. Am I missing something? Maybe downloading the wrong tarball? Or do I need to install from source? Thanks, Javier - 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
RE: MySQL can't tell the difference between two databases???
I really don´t undarstand My Linux is working fine in a situation like yours. I´ve simulated your situation mysql> use db2; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from tab1; +++ | id | name | +++ | 1 | javier | +++ 1 row in set (0.00 sec) mysql> use db1; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from tab1; Empty set (0.00 sec) My database and table description: ysql> use db1; Database changed mysql> show tables; +---+ | Tables_in_db1 | +---+ | tab1 | +---+ 1 row in set (0.01 sec) mysql> describe tab1; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | varchar(10) | YES | | NULL|| +---+-+--+-+-++ 2 rows in set (0.00 sec) mysql> select * from tab1; Empty set (0.01 sec) mysql> use db2 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +---+ | Tables_in_db2 | +---+ | tab1 | +---+ 1 row in set (0.00 sec) mysql> describe tab1; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | varchar(10) | YES | | NULL|| +---+-+--+-+-++ 2 rows in set (0.00 sec) mysql> select * from tab1; +++ | id | name | +++ | 1 | javier | +++ 1 row in set (0.01 sec) And finally my server and sistem data: mysql> status; -- mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) Connection id: 6 Current database: db1 Current user: [EMAIL PROTECTED] Current pager: stdout Using outfile: '' Server version: 3.23.44 Protocol version: 10 Connection: linux2 via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: 3306 Uptime: 7 hours 27 min 52 sec Red Hat Linux release 7.0 (Guinness) Kernel 2.2.16-22 on an i586 > -Mensaje original- > De: Gerald Clark [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 15 de enero de 2002 15:35 > Para: Nuno Gonçalves > CC: Mailing list MySql > Asunto: Re: MySQL can't tell the difference between two databases??? > > > Is db2 a symlink to db1? > If it was deleting one database or table must delete de another one. Javier Armendáriz [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
RE: MySQL can't tell the difference between two databases???
What happens if you try select * from db1.products and select * from db2.products;??? Doing that does the same? > -Mensaje original- > De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 15 de enero de 2002 13:24 > Para: Mailing list MySql > Asunto: Re: MySQL can't tell the difference between two databases??? > > > > It's something like this: > > mysql> use db1 > mysql> select * from products; > ++-+-+--+--+ > | Id | Ref | Version | Type | Name | > ++-+-+--+--+ > | 1 | XXX | 1 |1 | XXX | > ++-+-+--+--+ > 1 row in set (0.27 sec) > > mysql> use db2 > mysql> select * from products; > ++-+-+--+--+ > | Id | Ref | Version | Type | Name | > ++-+-+--+--+ > | 1 | XXX | 1 |1 | XXX | > ++-+-+--+--+ > 1 row in set (0.16 sec) > > I'm sure the table products on database db2 is empty, because of > the results > I get when I remove db1 from the system. > The same select returns empty. > > Hope that helps. Thanks. > > Nuno A. S. Gonçalves > [EMAIL PROTECTED] > > > - Original Message - > From: "Duncan Hill" <[EMAIL PROTECTED]> > To: "Nuno Gonçalves" <[EMAIL PROTECTED]> > Cc: "Mailing list MySql" <[EMAIL PROTECTED]> > Sent: Tuesday, January 15, 2002 12:13 PM > Subject: Re: MySQL can't tell the difference between two databases??? > > > > On Tue, 15 Jan 2002, Nuno Gonçalves wrote: > > > > > The only way I seem to be able to access the data on database B is to > > > remove the other database from MySQL. >From my tests it seems > that MySQL > > > only uses the table name to access the data (not using also > the database > > > name). > > > > The sql queries you are using on your database would help. We are not > > mind-readers (well, I'm not!). > > > > > > > > - > 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 > - 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
relational tables
Hi people : How I crate this relational tables with mysql. Table users | id | user name| e-mail | password | carrier| semester | table assignments | id | assignments | where the two tables must be related by id ok thanks for the help... _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
RE: query
Hi Nathan : Thanks for the help look, I read the php.net manual and use the mysql_num_rows(); function, and I write down this script, did you think is good enough. Thank. Untitled Document " target=new_window>..:: Edit _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
query
Hi: I have the next question when i program in asp a query to a database and the query doesn´t returns info you use the while not eof, and then you can control what will appear en the html page ok. There is something or a code that do the same in php4 Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - 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
PHP + MySQL problem (strange behavior)
Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration (int) now, i have a row that has a starttime of 60, when i attempt to do the following update with PHP, it sets it to 0: "UPDATE mytable SET starttime=starttime-30 WHERE name = 'myname'" but when I run it from the MySQL command line, copy/pasted from the code, it sets the value of starttime to 30 as expected. Any thoughts on where this problem originates from? PHP or MySQL? They're pretty commonly used in unison so I'd imagine something like this should work fairly smoothly. I've also posted this to the PHP list in case there's someone there that's encountered this before. Javier Muniz Chief Technology Officer Granicus, LTD. Tel: (415) 522-5216 Fax: (415) 522-5215 - 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
Getting id asignet to an insert
Hi everybody: Can anybody tellme how can y get the id asigned to a record in the moment i insert data in the database? I need to storage transaction requests, the mysql database assigns an unique id (auto increment) to that record, and i need it to continue saving data in another table. Is there a method for doing this whitou problems of concurrent users in the database??? Tahnk a lot - 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 + MOSIX
> I need to know how if the same structure of a data base can be > placed mysql in different nodes from mosix, soon to make a > question and that can respond to me as if outside a single one. > > Example: > > NODE1 NODE2 NODE3 > DBTABLE DBTABLE DBTABLE > DATAID:5 DATAID:5 DATAID:4 > DATAID:4 DATAID:3 DATAID:7 > DATAID:6 DATAID:9 DATAID:8 > DATAID:10 DATAID:7 DATAID:6 > > To migrate the processes between nodes > SQL: select DATAID From DBTABLE Where DATAID>=6 > And Respond > > DATAID > 6 #from node1 > 10#from node1 > 9 #from node2 > 7 #from node2 > 7 #from node3 > 8 #from node3 > 6 #from node3 > > It is possible to make this experiment. > Somebody has proven it. > JAVIER OLIVA > PUNTA ARENAS - CHILE = Javier Oliva F. [EMAIL PROTECTED] http:\\www.patagoniatuerca.cl __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - 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
Re: foxpro conversion
On Wed, 14 Nov 2001 [EMAIL PROTECTED] wrote:
> Anybody have any tools/tips for converting a foxpro database to mysql
Hi;
Take a look at mysql's page (contrib zone) or freshmeat... There's
a "dbf2mysql" app somewhere (but I don't remember the URL) that works
quite
nice...
Saludos
Javier
/* -- */
"He that will not reason is a bigot, He that cannot reason is a fool,
"He that dares not reason is a slave."
(William Drummond)
-
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
