MySQL Forums

Isn't localhost included in '%'? (no replies)

Jerry Fiddler — Sat, 04 Jul 2009 00:51:43 +0000

When I make a user named whoever@localhost, I can connect just fine. When I make a user named whoever@%, and try to connect it doesn't work. For instance, "mysql -uwhoever -pwhatever" gets the response "ERROR 1045 (28000): Access denied for user 'whoever'@'localhost' (using password: YES)".

Shouldn't this work?

Thanks in advance for any help with this.

Declare cursor -> error 1064(42000) (no replies)

J R — Sat, 04 Jul 2009 00:42:56 +0000

Ok, I'm converting a procedure I wrote for oracle into MySql. I can't even declare the cursor though. I've even looked at many MySql syntax pages and dont see what I'm doing wrong.

DECLARE cur_1 CURSOR FOR SELECT * FROM transaction;

and they I get the error code...

what am I doing wrong?

Thank you

Relacionamento (no replies)

Ricardo Groiso — Sat, 04 Jul 2009 00:05:27 +0000

ALguem saberia informar se a forma de elaborar um relacionamento entre tabelas no MySQL é a mesma maneira que se faz no MS Access?

Obrigado
Ricardo

NEED HELP: cannot mysql table 1 to php form to table 2 (no replies)

Jay Singh — Sat, 04 Jul 2009 00:01:14 +0000

I am new to this forum and am hoping to find some help about a problem i can't figure out at all "I hope this is the right forum for my problem".. Thanks a bunch in advance..

here's my problem i am a sort of a beginner in php...

i have a table in database on my local machine which i am using to develop an app...

i want to take the names of employees from (TABLE1) and bring into a new (PHP/HTML FORM 'DROP DOWN LIST') I've got that working Sortof, Now i need to use the (NAMES) from the DROP DOWN LIST and submit them via form and have the names show up in new table... here the code snippet i am using...

I am seeing the name in the drop down list but when i submit it my database table shows BLANK for the "first" NAME...PLEASE HELP

THANKS IN ADVANCE

MySQL Connector C++ Example - Windows cl.exe (Microsoft Visual Studio C++ 2008 ) (no replies)

Edwin DeSouza — Fri, 03 Jul 2009 23:12:58 +0000

MySQL Connector C++ Example - Windows cl.exe (Microsoft Visual Studio C++ 2008)
http://codediaries.blogspot.com/2009/07/mysql-connector-c-example-windows-clexe.html

Installation hangs (no replies)

Bill Thompson — Fri, 03 Jul 2009 22:50:13 +0000

I have a problem with the final step of the MySQL Server Instance Configuration Wizard. It never seems to get to the check off part of Apply Security Settings.

Installation hangs (-1 replies)

Bill Thompson — Fri, 03 Jul 2009 22:50:13 +0000

-- moved topic --

fast and slow restore (no replies)

benoit seize — Fri, 03 Jul 2009 21:54:09 +0000

Hello everybody,

First, sorry my poor english, and i hope you can understand what i said.

I use mysql on a lot of OS but i dont understand something.
I am sure that somebody can explain me.

I usually use putty to connect to sun solaris 9, on good mainframe computer E6900 ( sun )

I dump 5 databases, using mysqladministrator or mysqldump.

Databases are very differents, one take 50 MO and other take 400-500 MO.

i used mysql < /my_database.sql after a dump to restore data.

My problem is that :
If i dump all databases in one file, i take 2 GO file and when i import it, it take a long time to restore data.

If i dump all databases in multiple files ( one databases per file ), and when i connect multiple putty to solaris, when i import it ( one database by session ) it take less time than the first import.

When i look with mysqladministrator, a "show processlist", the first solution import one insert per one insert.
The second solution, the show processlist list me 5 insert by 5 insert.

So, i hope that it is possible to insert like the second time but using only one putty connection. I don t know how to do that... any one got an idea ?

But i have another question. If it is possible to do multiple insert with multiple putty connection for multi databases, Is it possible to "cut" one database in multiple insert, something like tables by tables ?

My only request is too be faster to restore data in databases with innodb.

Thank u very much for helping me.

If u don t understand what i mean, tell me and i will try to write better english.

slow and fast insert... from newbie (no replies)

benoit seize — Fri, 03 Jul 2009 21:49:02 +0000

MySQL Server 5.4/include/mysql_com.h:243: error: `SOCKET' does not name a type (no replies)

Min Son — Fri, 03 Jul 2009 20:43:04 +0000

Hello All,

My very simple code tries to integrate C++ code (win32 plataform) with MySQL libraries (version 5.4, and also v5.1 tested with the same error/behave).

THE CODE: -------------------------

#include
#include
using namespace std;
MYSQL *connection, mysql;
MYSQL_RES *result;
MYSQL_ROW row;
int query_state;
int main() {
return 0;
}

------------------------------------

Here are the search directories path set for the compiler (Code::Blocks v 8.02).

C:\Arquivos de programas\MySQL\MySQL Server 5.4\include
C:\Arquivos de programas\MySQL\MySQL Server 5.4\lib\opt

------------------------------------

Upon trying to BUILD the very simple C++ code above... I got error as shown below:

Compiling: C:\app-cpp\aa1\002.cpp
In file included from C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql.h:71,
from C:\app-cpp\aa1\002.cpp:2:
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:243: error: `SOCKET' does not name a type
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:417: error: `SOCKET' was not declared in this scope
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:417: error: expected primary-expression before "const"
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:417: error: expected primary-expression before "unsigned"
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:418: error: expected primary-expression before "unsigned"
C:/Arquivos de programas/MySQL/MySQL Server 5.4/include/mysql_com.h:418: error: initializer expression list treated as compound expression
Process terminated with status 1 (0 minutes, 1 seconds)
6 errors, 0 warnings

======================================

Does anybody may help me to over this error?

Thanks in advance,

mson77

Error 1005: Can't create table (errno 168) (no replies)

Jon Zang — Fri, 03 Jul 2009 20:00:29 +0000

Hello,

I am trying to convert MyIsam tables into Innodb using following query:

ALTER TABLE `myDb`.`myTable` ENGINE=InnoDB

And I get "Error 1005: Can't create table (errno 168)" and could not find out why is doing this.

In my.ini I uncommented "innodb_file_per_table" because I want to have the data stored in same location as the tables (.frm) (which are not in the default /data/ directory)

Can someone give me a hand on this?

Thanks

items disappear with LEFT JOIN (1 reply)

michael nieuwenhuizen — Fri, 03 Jul 2009 23:07:56 +0000

I've done a query

SELECT * FROM table1

which turns out some results. Now I have added a LEFT JOIN to the query:

SELECT * FROM table1 LEFT JOIN table2 ON table1.someVar = table2.somVar

but suddenly all the elements that don't appear in the table 2 disappear. What's going wrong? Shouldn't the second query always turn out at least as many items as the first query?

Time out after 30 Second (no replies)

hoor swelim — Fri, 03 Jul 2009 18:55:45 +0000

i develop program using C#.net and mysql server
my program give error message " Fatal Error " , i update mysql server to increate time out but no use , also i update my connection string but still the connection timeout after 30 second

Query not using index in ORDER BY (no replies)

Sebastian Ilari — Fri, 03 Jul 2009 18:54:58 +0000

Hi, I'm having trouble with this query, it's taking aprox 13 seconds which is too long for a pager in a list, the application that builds this query is a SugarCRM, so if the solution is to add an index it would be great for me, I don't have so much freedom to modify the structure of the query. The biggest tables here are contacts and contacts_cstm with 40000 records.

Here is the tables schema and the problematic query:

TABLES SCHEMA:

CREATE TABLE `contacts` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`salutation` varchar(5) DEFAULT NULL,
`first_name` varchar(100) DEFAULT NULL,
`last_name` varchar(100) DEFAULT NULL,
`title` varchar(100) DEFAULT NULL,
`department` varchar(255) DEFAULT NULL,
`do_not_call` tinyint(1) DEFAULT '0',
`phone_home` varchar(25) DEFAULT NULL,
`phone_mobile` varchar(25) DEFAULT NULL,
`phone_work` varchar(25) DEFAULT NULL,
`phone_other` varchar(25) DEFAULT NULL,
`phone_fax` varchar(25) DEFAULT NULL,
`primary_address_street` varchar(150) DEFAULT NULL,
`primary_address_city` varchar(100) DEFAULT NULL,
`primary_address_state` varchar(100) DEFAULT NULL,
`primary_address_postalcode` varchar(20) DEFAULT NULL,
`primary_address_country` varchar(255) DEFAULT NULL,
`alt_address_street` varchar(150) DEFAULT NULL,
`alt_address_city` varchar(100) DEFAULT NULL,
`alt_address_state` varchar(100) DEFAULT NULL,
`alt_address_postalcode` varchar(20) DEFAULT NULL,
`alt_address_country` varchar(255) DEFAULT NULL,
`assistant` varchar(75) DEFAULT NULL,
`assistant_phone` varchar(25) DEFAULT NULL,
`lead_source` varchar(100) DEFAULT NULL,
`reports_to_id` char(36) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`portal_name` varchar(255) DEFAULT NULL,
`portal_active` tinyint(1) NOT NULL DEFAULT '0',
`portal_app` varchar(255) DEFAULT NULL,
`campaign_id` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_cont_last_first` (`last_name`,`first_name`,`deleted`),
KEY `idx_contacts_del_last` (`deleted`,`last_name`),
KEY `idx_cont_del_reports` (`deleted`,`reports_to_id`,`last_name`),
KEY `idx_reports_to_id` (`reports_to_id`),
KEY `idx_del_id_user` (`deleted`,`id`,`assigned_user_id`),
KEY `idx_cont_assigned` (`assigned_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `contacts_cstm` (
`id_c` char(36) NOT NULL,
`nombre_c` varchar(25) DEFAULT NULL,
`apellido_c` varchar(25) DEFAULT NULL,
`tipo_c` varchar(255) DEFAULT 'DNI',
`numero_c` varchar(12) DEFAULT NULL,
`categoria_c` varchar(255) DEFAULT 'Contacto Simple',
`activado_c` varchar(255) DEFAULT NULL,
`motivo_c` varchar(255) DEFAULT 'empty',
`genero_c` varchar(100) DEFAULT '',
`fechanacimiento_c` date DEFAULT NULL,
`edad_c` int(2) DEFAULT NULL,
`direccion_c` varchar(70) DEFAULT NULL,
`codigopostal_c` varchar(255) DEFAULT NULL,
`localidad_c` varchar(255) DEFAULT NULL,
`distrito_c` varchar(255) DEFAULT NULL,
`seccion_c` varchar(255) DEFAULT '',
`provincia_c` varchar(255) DEFAULT 'Buenos Aires',
`telefono_c` varchar(20) DEFAULT NULL,
`telefonocelular_c` varchar(20) DEFAULT '',
`noenviarmails_c` tinyint(1) DEFAULT '0',
`estadocivil_c` varchar(255) DEFAULT '***Seleccione una opción***',
`hijos_c` varchar(255) DEFAULT NULL,
`cantidad_c` varchar(255) DEFAULT '***Seleccione una opción***',
`situacionlaboral_c` varchar(255) DEFAULT '-empty-',
`ocupacion_c` varchar(100) DEFAULT NULL,
`sector_c` varchar(255) DEFAULT NULL,
`nivelestudios_c` varchar(255) DEFAULT '-empty-',
`ingreso_c` varchar(255) DEFAULT '***Seleccione una opción***',
`vivienda_c` varchar(255) DEFAULT NULL,
`cantidaddeambientes_c` varchar(255) DEFAULT '***Seleccione una opción***',
`poseeinternet_c` tinyint(1) DEFAULT '0',
`temasactualidad_c` text,
`llega_c` varchar(255) DEFAULT NULL,
`comentarios_c` text,
`edaddesde_c` int(11) DEFAULT NULL,
`edadhasta_c` int(11) DEFAULT NULL,
`numeropersona_c` int(11) NOT NULL,
`caracteristica_c` int(5) DEFAULT NULL,
`caracteristica_celular_c` int(5) DEFAULT NULL,
`cod_area_c` int(5) DEFAULT NULL,
`cod_area_celular_c` int(5) DEFAULT NULL,
`fechacontacto_c` date DEFAULT NULL,
`horariocontacto_c` varchar(30) DEFAULT NULL,
`subcategoria_c` varchar(255) DEFAULT NULL,
`comocolaborar_c` text,
`country_c` varchar(255) DEFAULT 'ARGENTINA',
`experienciavoluntario_c` text,
`interesvoluntario_c` text,
`estadovoluntario_c` varchar(100) DEFAULT 'Registrado',
`sitioweb_c` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id_c`),
KEY `idx_numeropersona_c` (`numeropersona_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

QUERY:

SELECT
contacts.id,CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name, contacts.first_name , contacts.last_name , contacts.salutation, contacts.assigned_user_id,
contacts_cstm.activado_c,contacts_cstm.apellido_c,contacts_cstm.cantidaddeambientes_c,contacts_cstm.cantidad_c,contacts_cstm.caracteristica_c,contacts_cstm.caracteristica_celular_c,contacts_cstm.categoria_c,contacts_cstm.codigopostal_c,contacts_cstm.cod_area_c,contacts_cstm.cod_area_celular_c,contacts_cstm.comentarios_c,contacts_cstm.comocolaborar_c,contacts_cstm.country_c,contacts_cstm.direccion_c,contacts_cstm.distrito_c,contacts_cstm.edaddesde_c,contacts_cstm.edadhasta_c,contacts_cstm.edad_c,contacts_cstm.estadocivil_c,contacts_cstm.experienciavoluntario_c,contacts_cstm.fechacontacto_c,contacts_cstm.fechanacimiento_c,contacts_cstm.genero_c,contacts_cstm.hijos_c,contacts_cstm.horariocontacto_c,contacts_cstm.ingreso_c,contacts_cstm.interesvoluntario_c,contacts_cstm.llega_c,contacts_cstm.localidad_c,contacts_cstm.motivo_c,contacts_cstm.nivelestudios_c,contacts_cstm.noenviarmails_c,contacts_cstm.nombre_c,contacts_cstm.numeropersona_c,contacts_cstm.numero_c,contacts_cstm.poseeinternet_c,contacts_cstm.provincia_c,contacts_cstm.seccion_c,contacts_cstm.sector_c,contacts_cstm.sitioweb_c,contacts_cstm.situacionlaboral_c,contacts_cstm.subcategoria_c,contacts_cstm.telefono_c,contacts_cstm.temasactualidad_c,contacts_cstm.tipo_c,contacts_cstm.vivienda_c,
accounts.name account_name,
jtl0.account_id account_id , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod
FROM contacts
LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c
LEFT JOIN accounts_contacts jtl0 ON contacts.id=jtl0.contact_id
AND jtl0.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id
AND accounts.deleted=0
AND accounts.deleted=0
LEFT JOIN users jt1 ON jt1.id= contacts.assigned_user_id
AND jt1.deleted=0
WHERE
contacts.deleted=0
ORDER BY
numeropersona_c DESC
LIMIT 0,101;

EXPLAIN:

id * select_type * table type possible_keys key key_len ref rows Extra *
1 SIMPLE contacts ref idx_contacts_del_last,idx_cont_del_reports,idx_del_id_user idx_contacts_del_last 2 const 6316 Using where; Using temporary; Using filesort
1 SIMPLE contacts_cstm eq_ref PRIMARY PRIMARY 108 sugarcrm_db.contacts.id 1
1 SIMPLE jtl0 ref idx_contid_del_accid idx_contid_del_accid 112 sugarcrm_db.contacts.id,const 1 Using index
1 SIMPLE accounts eq_ref PRIMARY,idx_accnt_id_del,idx_accnt_assigned_del PRIMARY 108 sugarcrm_db.jtl0.account_id 1
1 SIMPLE jt1 eq_ref PRIMARY PRIMARY 108 sugarcrm_db.contacts.assigned_user_id 1

From what I saw the problem is that it's not using the numeropersona_c index to sort the results, if I ommit the ORDER BY the query runs very fast, another scenario is if I remove the WHERE and make the LEFT JOIN with contacts_cstm an INNER JOIN the query uses the numeropersona_c index and the query also runs very fast. I think I can make that LEFT an INNER JOIN in the application but I can't ommit the WHERE condition.

Any advice would be appretiated
Thanks in advance

Upload data by FTP (no replies)

Alex Colman — Fri, 03 Jul 2009 18:15:29 +0000

Is there any way to upload data file through FTP?

Thanks in advance.

MySQL not starting during initial configuration (no replies)

Bob Ivey — Fri, 03 Jul 2009 17:12:14 +0000

I have been fussing with this off and on for 6 months. During the initial configuration setup on XP PRO MySQL will not start on the localhost. I have removed and reconfigured the instance numerous times with no luck. I have port 3306 configured for TCP/IP and have the port in the firewall exclude list. I have even RTFM. I have SQL Server 2008 installed but stopped - works fine when it is running. Any help will be appreciated.
Bob

msql.exe se cae al intentar acceder ana tabla desde mi sitio web (no replies)

Tomas Martin — Fri, 03 Jul 2009 16:08:56 +0000

Hola.

Tengo Xammp 1.7.1 instalado en un windows Vista ultimate. Desde esta mañana mi aplicacion web que tengo instalada en este equipo ha comenzado a provocar caidas del servicio mysqld.exe.

Me he dado cuenta de que mientras ninguna de mis paginas accede a una tabla que llamo usuarios todo funciona correctamente, pero en cuanto entro en un página que accede a esta tabla el servicio msql se cae.

Si entro con phpmyadmin, puedo ver todas las bases de datos que tengo creadas salvo la mia. Al puslar en ella se vuelve a caer el servicio.

Todas las tablas de esta base de datos son InnoDB. Supongo que algo esta corrupto.

¿Se puede recuperar? ¿Como?

Saludos

Error using hebrew chars (no replies)

Giora Genender — Fri, 03 Jul 2009 15:57:31 +0000

My system is written in ASP on an IIS7 server (64bit) and I'm using "MySQL ODBC 5.1 Driver" as my connector.
The system works fine in English but when I use Hebrew chars I get the following error:

"Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties."

Again, this error only takes place when I use Hebrew chars for writing into the database. It has no problem reading them though.
Could anybody help me?
Thanks in advance.

No such process (no replies)

J G — Fri, 03 Jul 2009 15:55:31 +0000

Hello,
Can someone tell me what this error means? Mysql has been installed for some time and was running fine and then just stopped. As far as I can tell the box it resides on did not crash.

When I try to restart it I get the below error.

Starting MySQL...../etc/init.d/mysql: line 159: kill: (16197) - No such process

Any suggestions? I've been googling most of the night trying to figure this out however most responses/suggestions deal with recent installs which is not the case for me.

Thanks!

Case sensitivity of query, not names, not data (1 reply)

Timo Kriel — Fri, 03 Jul 2009 15:05:27 +0000

I came across this weird situation where SELECT ... produces a different result from sELECT ....

Please see below (note the row count at the end of the results).

Also, adding asc to the order clause fixes the situation (the last set below).

Is there anything I need to look out for or adjust?



mysql> SELECT * FROM buy_action order by action ;


+-------------+


| action      |


+-------------+


| appointment |


| bpreceived  |


| bpsubmit    |


| call        |


| capture     |


| converse    |


| getcall     |


| getmail     |


| getrequest  |


| getsms      |


| getwebreq   |


| mailbrpt    |


| mailinfo    |


| maillist    |


| mandate     |


| meet        |


| sendfax     |


| sendmail    |


| sendsms     |


| sms         |


| snailmail   |


| update      |


+-------------+


22 rows in set (0.00 sec)





mysql> sELECT * FROM buy_action order by action ;


+-------------+


| action      |


+-------------+


| appointment |


| bpout       |


| bpreceived  |


| bpsubmit    |


| call        |


| capture     |


| converse    |


| followbp    |


| followinfo  |


| getcall     |


| getmail     |


| getrequest  |


| getsms      |


| getwebreq   |


| infoout     |


| mailbrpt    |


| mailinfo    |


| maillist    |


| mandate     |


| meet        |


| sendfax     |


| sendmail    |


| sendsms     |


| sms         |


| snailmail   |


| update      |


+-------------+


26 rows in set (0.00 sec)





mysql> SELECT * FROM buy_action order by action asc;


+-------------+


| action      |


+-------------+


| appointment |


| bpout       |


| bpreceived  |


| bpsubmit    |


| call        |


| capture     |


| converse    |


| followbp    |


| followinfo  |


| getcall     |


| getmail     |


| getrequest  |


| getsms      |


| getwebreq   |


| infoout     |


| mailbrpt    |


| mailinfo    |


| maillist    |


| mandate     |


| meet        |


| sendfax     |


| sendmail    |


| sendsms     |


| sms         |


| snailmail   |


| update      |


+-------------+


26 rows in set (0.00 sec)

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: (4 replies)

Anil Karamchandani — Fri, 03 Jul 2009 15:14:13 +0000

Hi i am a newbie in mysql and i have written a code in java with mysql as the db. The error which i get while executing one of the codes is

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit '1', '5'' at line 1

and the mysql query is

s.executeQuery("select p.product_name, p.product_desc,v.vendor_name from product p, vendor v, category c where c.category_id='"+keyid+"' and p.vendor_id=v.vendor_id and limit '"+fr+"', '"+lr+"'");

fr, lr and keyid are the parameters passed to a method in which this query is written.

any help would be appreciated

thanks !

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: (-1 replies)

Anil Karamchandani — Fri, 03 Jul 2009 15:04:42 +0000

-- moved topic --

Best practice - variable number of fields (no replies)

Vlad Gotlib — Fri, 03 Jul 2009 14:45:19 +0000

Hello,

I am recording user's hobbies. I have a reference table with the unique hobbies. In my "UserHobbies" table I need to associate each user with his list of hobbies. Should I have separate integer fields to record their hobbies, like "Hobby1", "Hobby2" etc (let's say up to 10, leaving extra unused ones blank), or should I have just one varchar field "Hobby" where I concatenate the hobbies separated by semicolons? Which is a best practice for such a necessity?

Much appreciated.

problems with update (1 reply)

Rea Kel — Fri, 03 Jul 2009 13:27:32 +0000

I have the following table:

+---------+---------------------+--------+---------------+
| LoginID | LoginTimeNOW | CompID | LogoutTimeNOW |
+---------+---------------------+--------+---------------+
| 1 | 2009-07-03 14:36:23 | k4423 | NULL |
+---------+---------------------+--------+---------------+
1 row in set (0.00 sec)

I want to update it so that the NULL entry changed to a DATETYPE now(), like this:

update Logins set LogoutTimeNOW=now() where CompID='k4423' AND LogoutTimeNOW=NOW;

but this doesnt work. Is this a bug, or is there a way to do this simple task?

[now() returns the date and time]

DLL protection (no replies)

David Patricks — Fri, 03 Jul 2009 13:09:41 +0000

Hello!
For security I should not to use any temporary files except single .exe. DLLs should be embedded in exe file. Would you, please, advice me how can I load DLLs, used in my app, without extracting them run-time?
Thanks!

Effective tool for run-time errors and memory leaks detection (no replies)

David Patricks — Fri, 03 Jul 2009 13:07:31 +0000

Hi!

Created application is working toooo slow, looks like there are a lot of memory leaks, there are a lot of pointers. So, please, can you advice some effective tool for run-time errors and memory leaks detection in Visual Studio C++?

Reading a flat file and execute command dynamically (no replies)

pratap kumar tripathy — Fri, 03 Jul 2009 12:56:36 +0000

Is it possible to read the a flat file in mysql procedure?

we get numerous flat files with sql statement in it. basically we want
to:

1. read the list of .sql file in a directory
2. read each sql file in turn
3. read each sql statement in the sql file and fire that dynamically.
if it fails then write the error to error table
4. finally delete the sql file

we have done it in oracle using a oracle job. is it possible to do so in mysql.

Reading a flat file and execute command dynamically (-1 replies)

pratap kumar tripathy — Fri, 03 Jul 2009 12:56:36 +0000

-- moved topic --

Primary key is not allowing same value in upper and lower case (1 reply)

pratap kumar tripathy — Fri, 03 Jul 2009 13:46:49 +0000

Primary key is not allowing same value in upper and lower case. we need to allow this. is there any way. Please see details below to replicate the problem.

mysql> create table pkt (name varchar(10) not null);
Query OK, 0 rows affected (0.16 sec)

mysql> alter table pkt add primary key pk_pkt(name);
Query OK, 0 rows affected (0.22 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> insert into pkt values('pratap');
Query OK, 1 row affected (0.03 sec)

mysql> insert into pkt values('PRATAP');
ERROR 1062 (23000): Duplicate entry 'PRATAP' for key 'PRIMARY'

subquery/self join syntax help (no replies)

Tom Gill — Fri, 03 Jul 2009 11:40:06 +0000

Hello all, I wonder if someone can point me in the right direction....

I am working with nested sets for a tree structure, and am trying to retrieve all leaf nodes of any nodes with a particular option. For example my tree has many trees, the nodes of which represent particular options e.g. colour, size etc, each tree represents one product.

I would like to be able to select all leaf nodes where a tree has an option red (npt_option=7) - the node which has an option of red could then have descendants with a size option or anything else.

So for each row I have a left and right value and also an option value, selecting rows of a particular option is easy enough:

SELECT npt_left, npt_right
FROM tbl_product_tree
WHERE npt_option = 7

But the rows returned are not necessarily leaf nodes, so now I need to use the left and right values returned from this simple query to select the rows (from the same table) whose left and right values are between these left and right values - this will return all descendants, I can then cut that down to leaf nodes by selecting only those that whose right value is equal to it's left value + 1.

So I have the following so far:

SELECT node.npt_node, node.npt_left, node.npt_right, node.npt_child, node.npt_product
FROM tbl_product_tree AS node, (
SELECT npt_left, npt_right
FROM tbl_product_tree
WHERE npt_option = 7
) AS opt
WHERE node.npt_left BETWEEN opt.npt_left AND opt.npt_right
AND node.npt_right = node.npt_left + 1

Which doesn't give me an error, but doesn't give me the result I would like either! I think I need a self join here, but I can't work out the syntax.

Any help would be appreciated.

Many thanks, Tom.