monitoring mysql performance

). What do you guys recommend me? Thanks! Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

mysql administrator I get the username correctly. Regards and thanks for the promptly answer Miguel De: Claudio Nanni Para: Miguel Gonzalez CC: Tim Pownall ; mysql. Enviado: Miércoles 29 de Mayo de 2013 9:24 Asunto: Re: SSH tunnels and non root accounts get

Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

entry as I said. Regards, Miguel De: Tim Pownall Para: Miguel González CC: mysql. Enviado: Miércoles 29 de Mayo de 2013 3:29 Asunto: Re: SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

SSH tunnels and non root accounts get "the server service or the configuration file could not be found"

sions in the linux box and filled it with: [client] pass='mypass' user=myuser Server configuration file is under /etc/my.cnf. What am I doing wrong? Regards, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

fragmentation in innodb tables

innodb_buffer_pool_size= 2G I have run either optimize table and alter table mytable engine=INNODB and both commands don't end up shrinking the space in the idb files. The script above reports the same fragmentation. Regards, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Promoting MySQL 5.5 slave to master

- Mensaje original - De: Manuel Arostegui Para: Miguel Gonzalez CC: mysql@lists.mysql.com Enviado: Jueves 21 de marzo de 2013 9:17 Asunto: Re: Promoting MySQL 5.5 slave to master 2013/3/21 Miguel Gonzalez > > > > Can you elaborate about this? I thought that once y

Re: Promoting MySQL 5.5 slave to master

the RPM package has been included in most YUM repos and it has been throughly tested. I still remember how painful was to install a new system with MySQL (5.5 I believe) under Ubuntu last May. I had to report a bug and make some tweaks in order to get the mysql service installed. Regards, Migu

Promoting MySQL 5.5 slave to master

crashed. So far I have read that if the master crashes I should issue an stop slave in the slave server and restart the mysql service (otherwise the master info is still kept in memory) with a skip-start-slave setting. Is that right? Is that all? Regards, Miguel -- MySQL General

Deploying a MySQL application

Hello After days of tests with different configurations for my VC++ project, finally I was able to run it using both Release and Debug versions with MySQL... now I have a few doubts on the application deployment... 1. The library was linked DINAMICALLY (DLL) since I want the MySQL code independen

Unhandled exception at 0x51716970 in MSQ.exe: 0xC0000005: Access violation reading location 0x00000000.

Hello I have a simple application that uses MySQL C API that works fine in release mode, but when run in debug mode it crashes: Unhandled exception at 0x51716970 in MSQ.exe: 0xC005: Access violation reading location 0x. and don't know what can be the problem. The application was bui

Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

"...\mysql\lib\debug" in DEBUG mode... maybe running the debugger will not work with the lib, still have to test, but at least it compiles with no errors... can you comment something about this? On Tue, Jun 19, 2012 at 2:24 PM, Lars Nilsson wrote: > On Tue, Jun 19, 2012

Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

ib\debug directory contains just the static library mysqlclient... Do I have to include an aditional library so the symbols are resolved correctly? The release mode works perfect and the application runs fine in that way only... Thanks, Miguel -- MySQL General Mailing List For list archives:

Emergency backup from *.frm *.MYD *.MYI files

Hello My linux system died due a bad system driver and it does not boot ANYMORE, I am backing up my data files to restore a previous worlking backup of the whole system that DOES NOT INCLUDE THE DATABASES... I'm still backing up and will take some time before restore the system, in the mean time

Re: best way to copy a innodb table

data. The destination doesn't need to be on the same database or on the same server. Take in account that this tool by default deletes data from the source table, so use --no-delete option. Try it on a testing environment before executing it in production :) Regards, -- Miguel Ángel Nieto, S

RV: mysql listed as "attach page" by google?

¡¡Very clear video!! http://blog.armorize.com/2011/09/mysqlcom-hacked-infecting-visitors-with.htm l -Mensaje original- De: Peter Brawley [mailto:peter.braw...@earthlink.net] Enviado el: lunes, 26 de

Re: from excel to the mySQL

Hi, Ive always used navicat for mysql and it does wonders for import/export (wether it be from excel or any other file type) and also general database management. Actually, too many features to list here, check the website: http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html

Re: table structure problem

forgive the duplicate email. I replied only to you first, instead of all. On Mon, Jul 12, 2010 at 4:37 PM, Shawn Green (MySQL) < shawn.l.gr...@oracle.com> wrote: > On 7/8/2010 11:29 PM, Miguel Vaz wrote: > >> Hi, >> >> I am having some uncertainty while desi

table structure problem

Hi, I am having some uncertainty while designing the following structure: I have two sets of data: * arqueology sites (can be natural): id name description id_category id_period x y * natural sites (can be arqueological also - bear with me -, so there will be duplicate records in the above ta

Uninstalling MySQL 6.x from Windows

Hello I have an old windows installation with MySQL 6.x and want to remove it so I can install latest version 5.1.48 but I tried once before with another computer and newer installation never worked, had to reinstall whole windows to make a new clean installation. How can I remove completely vers

MySQL application & development LIBS

Hello I have a small Windows application linked to the MySQL development libraries and have to run in on another computer, do I have to copy the DLL/LIB files or are they already static linked to the application? The other computer has no MySQL installed, and the application will run only as clien

Re: Compiling mysql-5.1.41 in Fedora 12

Hi, http://bugs.mysql.com/bug.php?id=42039 "The --with-mysqld-libs option should be given an argument, something like --with-mysqld-libs="-L/path/to/lib -lfoo -lbar" 2009/12/27 Kurian Thayil : > Hi All, > > I was trying to compile MySQL 5.1.41 in a Fedora 12 box. I don't want to do an > RPM  ins

Re: Can't execute the given command because you have active locked tables or an active transaction

Hi, > I am getting "Can't execute the given command because you have active locked > tables or an active transaction" error when I am trying to truncate table. I > am unable to understand the error as when I am using the mysql query browser > then the same command is working fine but when I am doi

Re: MySQL slave master replication

Hi, MySQL replicate the databases at SQL level, so if the two servers are using the same engine (innodb), they will be replicated without problems. If the BLOB data is big, don't configure the replication over a WAN or you will get too much latency (of course, it depends on your bandwidth). 2009

Re: mysql load balancing

> Load balancing, or high availability? > > I do not think there is anything good and simple AND generic out of > the box.  As previous posters have noted, you generally have to build > something on top of other tools. Hi, I have the HA solved with MMM. Now, I want load balacing, sending read que

Re: mysql load balancing

Hi, El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón escribió: > 2009/12/21 Miguel Angel Nieto : >> Hi, >> >> I am searching fot a Mysql Load Balacing tool. I read about mysql >> proxy, sqlrelay, haproxy... >> >> What do you prefer? > > Hi,

mysql load balancing

Hi, I am searching fot a Mysql Load Balacing tool. I read about mysql proxy, sqlrelay, haproxy... What do you prefer? What are the benefits and bugs? :) Thank you. -- Lo que haría sería hacerme pasar por sordomudo y así no tendría que hablar. Si querían decirme algo, tendrían que escribirlo

Re: Count records in join

essage- > >From: Miguel Vaz [mailto:pagong...@gmail.com] > >Sent: Wednesday, December 16, 2009 9:39 AM > >To: Johan De Meersman > >Cc: Gavin Towey; mysql@lists.mysql.com > >Subject: Re: Count records in join > > > >Thanks all for the feedback. Here's what i

Re: Count records in join

lect id_prog from events where > id_prog = progs.id_prog); > > My syntax might be off, check "not exists" documentation for more info. > > > On Tue, Dec 15, 2009 at 8:14 PM, Gavin Towey wrote: > >> Hi Miguel, >> >> You'll need to use LEFT JOIN, that

Count records in join

Hi, I am stuck with a suposedly simple query: - i have two tables (: PROGS id_prog name EVENTS id id_prog name How can i list all records from PROGS with a sum of how many events each have? I want to find the progs that are empty. I remember something about using NULL, but i cant remember. :-

Join using Table1 or Table2 - depending on content of rel table

Hi, How would one go about doing this: - I have 3 tables: - A relationship table(REL), then TABLE1 and TABLE2: REL TABLE has fields: . ID . TYPE - type of event . ID_EVENT - id of event, but this id will either point to TABLE1 or TABLE2, depending on the content of the field "TYPE" Is it poss

Re: Several languages for content

t;"; } > elseif (ACTIVE_LANG == "spanish" && $RECIPES->name_spanish == "") { > $return = "".$RECIPES->name_english." [Sólo inglés disponible]"; } > elseif (ACTIVE_LANG == "english" && $RECIPES->name_english != &quo

Several languages for content

Hi, This is my first post, and could use some points of view on the subject. Have a project that will have several languages for its records, for places, for example, whose names and descriptions will be in 3 languages. Have already read several sites about it but always end up with several persp

LIMIT/OFFSET to paginate results

Hello list :) I am developing an application that will show records in paginated documents, i.e. 10 records per page Lets supose this row structure MyTable ID(autoincrement) SectionID Name Description The ID is automatic autoincrement for unique records, the SectionID is to separate items

Removing MySQL to install new version

Hello I noticed that mysql 6 alpha is no longer available so I want to remove it from my laptop and install the latest 5.x version. I have just restored my Linux system image so my database is clean and empty and is a good moment to do it. My question is, how can I remove it completely from my di

Linking mysqlclient to a windows program

Hello I have configured my VC++ to link my programs with mysqlclient, but now am trying a program with Qt that is compiled using "make" from the command line, is it enough to add "mysqlclient.lib" to my makefile library configuration? I mean, is it enough to add the path to the header files and my

Re: mysql behaviour

aparently, it says that the error log is in the syslog file but here I didnt find any errors. I will cofigure an exclusive log file for the slow connections and the errors. Thank you very much for your help. best regards, Miguel On Tue, 2009-03-10 at 00:41 +0100, Claudio Nanni wrote: > I

Re: mysql behaviour

i m not lucky, the server has not an exclusive error log. It is not configure. It says: Error logging goes to syslog. This is a Debian improvement :) but I can not see anything clear in syslog. On Mon, 2009-03-09 at 23:20 +0100, Claudio Nanni wrote: > uld be > just a Django problem (does no

Re: mysql behaviour

On Mon, 2009-03-09 at 22:37 +0100, Miguel wrote: > as you say, it is not a fact. I m trying to find the problem but I > have no experiences with ddbb performance. > > I have also found file descriptors really big like this one (lsof > info): > > > > > mys

Re: mysql behaviour

queries? thank you very much, Miguel On Mon, 2009-03-09 at 18:31 +0100, Claudio Nanni wrote: > It is really not enough for me to give an opinion but I do not see > anything strange, what is your worry? > > > Miguel wrote: > > thank you Claudio, something that is messing m

Re: mysql behaviour

dio > > > 2009/3/8 Miguel > > > Hello, > > > > I wanted to know how mysql behaves when accessing to its tables. > > I have check the file descriptors and I could see different MYI and MYD > > opened. > > > > mysqld 17638 mysql 125u REG

mysql behaviour

83051 /usr/var/lib/mysql/y.MYD [...] my question is , must these files descriptors be closed after accesing to the tables? or these files keep opening? thank you very much, Miguel

Re: VC++ 2008 / MySQL debug / Unhandled exception

a debug session, and the problem arises inside the MySQL library, not in the MySQL code but inside the shared memory function it calls. I hope this could help to get an idea Regards, Miguel

Re: VC++ 2008 / MySQL debug / Unhandled exception

Hi I tested with both release and debug versions and the problem is the same, it fails when calling mysql_real_connect() shared memory request function strcpy() asm code access violation to 0x Regards, Miguel On Sun, Jan 11, 2009 at 9:57 AM, Patrick Sherrill wrote: > I s

VC++ 2008 / MySQL debug / Unhandled exception

Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe:

Re: stuck on a query

Got it to work perfectly, thanks, although it takes some time (CILS has >150.000 records). There was no need for unique since all the results are already surprisingly unique. Thank you, it was a different way of doing things. Well, different to me, at least. :-) In the meantime, i found an altern

MySQL programming from *NIX to Windows

ks for any help, Miguel

BACKUP DATABASE * TO '/tmp/all.backup'; - DOES NOT WORK (6.0.4-alpha)

Hello Hello I have troubles with 'BACKUP DATABASE', I thought it was problem of syntax, but have tried even the samples in http://dev.mysql.com/doc/refman/6.0/en/backup-database.html and the command is not recognized $ mysql --version mysql Ver 14.14 Distrib 6.0.4-alpha, for pc-linux-gnu (i686)

MySQL 6.0.4: 'RESTORE TABLE' *nor* 'RESTORE DATABASE' available

Hi I've just reinstalled my system and used the oportunity to get the latest MySQL, so I got 6.0.4 version and installed it. The problem is that want to restore some tables but 'RESTORE TABLE' nor 'RESTORE DATABASE' (as specified in the manual online) are not available, 'BACKUP xxx' are neither a

A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll

Hi. I have this code: cId = fila(cmbCodigo.SelectedIndex).ToString cMedida = fila(cmbMedida.SelectedIndex).ToString cDenomina = fila(cmbDenominacion.SelectedIndex).ToString oComando.CommandText = "INSERT INTO preciodeno(id, medida, denomina ) " _ & "VALUES(?cId, ?cMedida, ?cDenomina

[ excel to mysql ]

Hi! How i do for transfer data from excel file to mysql? Some example? Thanks

select with table name

Hi, I have a small issue that i can get my head around to solve: Is it possible to do a select from two tables using a union all (select * from t1 union all select * from t2), and have it display the table name in front of each row? What i need is, on the big resulting lis

change field types from several tables

ALTER TABLE * CHANGE * * TEXT But obviously this doesnt work. Is this even possible using MYSQL? I could do it programmatically using PHP, i guess, but a single command would be far better. :-) Miguel Vaz -- MySQL General Mailing List For list archives: ht

join between databases

Hi, I am building a new system for the place i work and i was thinking about organizing my tables in several databases, like "management", "financial", "production_line" to make things more tidy. I will have tons of tables, so is it a usual procedure in organizing tables? The othe

Selecting rows by DATE ranges

UAL operator does not include the last day, so my reports with "<=" are done by adding one day but don't like to use it this way since it could be confusing and generate errors on reports. Thanks for any comment, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Avoiding TIMESTAMP

Hello list I need to solve a little problem but don't mind how, maybe you could suggest something. I have a database which registers payments, records have a AUTO_INCREMENT field to assign a unique consecutive number associated to every payment, some other fields that store the amount, type of

Re: Problem with GRANT ... 'user'@'%'

> Hm, I didn't know that! I thought it was only a special value to the > client tools, which I know will try to connect via socket on UNIX machines > when they see 'localhost' but will try to connect via TCP/IP when they see > '127.0.0.1'. Thanks for pointing this out! > > Baron In fact that was

Re: Problem with GRANT ... 'user'@'%'

> Localhost is indeed a special value that isn't include in '%'. It's a > feature not a bug ;) > > Regards, Bingo! That was the point! If i connect to the server ip or server name it works perfectly, but if I try to connect to localhost it fails unless I add a new user specific to localhost :D

Re: Problem with GRANT ... 'user'@'%'

> If you don't specify a hostname in SHOW GRANTS, '%' is assumed. My mistake > for not telling you this before. If you enable networking, and connect > with > > mysql -h 127.0.0.1 > > instead of > > mysql -h localhost Well, in fact 127.0.0.1 and localhost produce the same effect but

Re: Problem with GRANT ... 'user'@'%'

> Remember to quote the user and host carefully. So, The quoting is okay, I tested again > If you have doubts about what you actually granted, do this: > SHOW GRANTS FOR 'user' I've sent this command: grant all on mydatabase.* to 'myuser'@'%' identified by 'mypass'; Then tested the show grants

Problem with GRANT ... 'user'@'%'

Hello list I have a problem adding a user with host '%' ... *** If I add a user with host '%' when trying to connect get this error: ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) *** If I add the same user with localhost it connects and works fine... My

INSERT using SELECT results

2 t2 Thanks Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

to join or not to join, that is the query

tables (levels and sizes). :-P Heres what i need as a result: - id_person, name, descA, sizeA, descB, sizeB descA, etc, being the id_levelA, etc replaced, and i assume i need to give it a new name to fetch the results, right? Can you guys point me in the right direction?

Re: simple alternate query

I am dumb, so sorry: select * from table1 where id=1 or id >=3 and id <=4 Have to go spank myself until i bleed now, thanks. Miguel At 02:15 28-01-2007, Miguel Vaz wrote: Hi, I Cant get a simple query to work, heres wha

simple alternate query

ut how can i get record 1,3,4 and 5? Thanks Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Good day

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were dele

select from multiple tables

s: id id_type namedescprice 1 2 prod1 blah45 table types: id_type name 1 razor 2 string I want the list to show: prod1 string blah45 Thanks,

Compiling mysql-5.0.18 under solaris 10

Hello Am trying to compile mysql-5.0.18 under solaris 10 but get the following error Making all in zlib make[2]: Entering directory `/tmp/mysql-5.0.18/zlib' /bin/bash ../libtool --preserve-dup-deps --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T -o libz.la -rpath /usr/local/mysql/lib/mysql -ver

Re: Append one table to another?

f you need to have more control over what is copied, you can add a WHERE clause in the SELECT above. Also, you can restrict how it is done by adding some fields restrictions: INSERT INTO table1 (field1, field2) SELECT field1, field FROM table2 WHERE field1 =

User/Password for every host?

Hello list I have a doubt... Do I need to set a password to a user for each host the user has permission to connect from? Let's supose // add user 'somebody' GRANT ALL PRIVILEGES ON *.* TO somebody@"192.168.0.%" IDENTIFIED BY 'onepass'; if I want 'somebody' to have access from "dsl-A.B.C.D-pro

ADDING ALLOWED HOSTS

Hello I've just read the users management, it is pretty clear but have a technical doubt... I have a server at the office and want to work on it from home sometimes. It has not a fixed ip, is ADSL and address changes from time to time. Am able to access the server via ssh by using a domain ove

Creating HUGE reports

Hello... After solving some problems with the code, now am working with the real one database. On my tests was playing with 20,000 records and worked pretty fine sorting by X or Y field and setting some 'where ...' conditions. At this moment the database has 250,000+ records, new insertions are

myhostname-bin.000nn @ /usr/local/mysql/var

Hello list I wanted to know how much space was using the database am working on, but found some big files I don't know what they do... these files are located in /usr/local/mysql/var and are named 'myhostname-bin.000nn' (nn is 1 to 29 at this moment)... I don't know that are those files, so

Re: mysql_free_result() & 2 different connections

> 4.1.4 is beta version, isn't it ? I'll suggest you try the latest > binary for 4.1 available for your setup. Oops, sorry, type mismatch error... I mean 4.1.14, the most recent > > I suspect that the current version of MySQL frees the resources > > automatically, > no, it does not :-) I tho

Re: mysql_free_result() & 2 different connections

> Are your two tables in the same database ? > If yes only one connection if enough, and you could use a join query > to do it, thus having a speed improvement of several magnitudes. I've just downloaded another 2 mysql manuals and have been sit on my chair all day reading them, but still do not

Re: mysql_free_result() & 2 different connections

> > I have 2 different result sets, since are two different connections to > > the server, simultaneous but independent (two handles, two connections, > > two different queries) > > what is the code you're using ? in a very small representation the program is this *** dbmail and dbmail2 open 2 di

Re: mysql_free_result() & 2 different connections

Hello I was re-reading last mails, analized it carefull again and... > > while ( my1.fetch ) { > >    my2.query + my2.store > >    if ( my2.fetch ) { > >       report = my1 + my2 results > >    } else { > >       report = my1 > >    } > >    my2.FreeResult <--- free for every my2.query inside loo

Re: mysql_free_result() WITHOUT mysql_fetch_row()

Hello > Have you try : > select count(*) from mytable where id=x and list=something > if count ==0, it's like fetchrow==NULL from your solution, but without > all the fuss about use_result(); No, but looks fine, I didn't know this usage of count(*) combined with conditions, but now will use it :

mysql_free_result() CRASHES

Hello I've just experienced troubles with mysql_free_result() but don't know what is wrong... one of my programs has 2 simultaneous connections to MySQL and crashed when doing the mysql_free_result(), I thought it was 'cos the way I was making the program, but now I have the problem with single

Re: mysql_free_result() WITHOUT mysql_fetch_row()

> http://dev.mysql.com/doc/mysql/en/mysql-free-result.html > it does not says : you have to retrieve all rows before freing it. So > you should be able to free the result. Otherwise it's a bug or > undocumented behaviour. > But why don't you use the Count(*) solution ?? that's exactly what you > ne

mysql_free_result() --- PART II

Hello again Sorry, this is the third mail but found something strange... In the past mail commented about the following error: *** glibc detected *** double free or corruption (!prev): 0x08051d58 *** Aborted but found that mysql_free_result() produces this error only when ALL data has been ret

Re: mysql_free_result() WITHOUT mysql_fetch_row()

> In the last episode (Sep 17), Miguel Cardenas said: > > I have a technical doubt, very simple but not mentioned in the manual... > > > > What happens if I call mysql_free_result() after performing a query > > but without doing mysql_fetch_row() ??? > > > >

mysql_free_result() & 2 different connections

Hello list There is another doubt... I have programmed a C++ object that connects to MySQL, it has encapsulated its own MYSQL *mysql MYSQL_RES *result ... etc etc data, so it it possible to have several simultaneous connections to MySQL performing different jobs, but I have experienced a stran

mysql_free_result() WITHOUT mysql_fetch_row()

Hello list I have a technical doubt, very simple but not mentioned in the manual... What happens if I call mysql_free_result() after performing a query but without doing mysql_fetch_row() ??? It may sound strange, but just need to know if a data row exists more than the data itself... The rig

Re: MySQL Subquery bug or am I doing something wrong?

t you know... I'm not the only one inserting values into the table. :-) Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Subquery bug or am I doing something wrong?

t; FROM sites_criterios -> ); Empty set (0.01 sec) Note that this query is THE SAME as the previous one, but with a wider result set inside the subquery. This makes no difference in my queries as we confirmed at least the word "su-turno" does not exists. Thanks for your patience. If you think I'm doing something wrong please reply. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysqlhotcopy.

I install the last version of mysql and got this $mysqlhotcopy test File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) What happened ? Best regards, Miguel --- E-mail: [EMAIL PROTECTED] . ADVERTENCIA: La informacion co

Here is your documents.

The message contains Unicode characters and has been sent as a binary attachment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

automatic generation of table creation code

Hello all at mysql, Are there tools available to automatically generate database (tables) creation code starting from some grafical description of data... maybe it's a crazy idea but I think it makes sense... maybe: ER Diagrams to SQL or:Object Diagrams to SQL anything based on some kind of

select's with various levels

Dear all at mysql list I'dd like to know if it is possible (and the right sintax) to execute a nested (2 or more levels) select... something like this. select * from products where productId IN ( select idNumber from other_table ); This has the same result than a JOIN. I've done

Re: SELECT on string field

- www.domain.com?id=2 (There is no /) Beware though, this usage will not use indexes on "url" column so be careful and do not use this on big tables. You will need to use more elaborated techniques to speed up query times on big tables. Cheers, Jose Miguel

Re: c program Bus Error (core dumped)

Hi Andy! > After compiling with the options (as suggested by Jose Miguel Pérez) [...] > I now get ... > Everything Cool with the connection > Bus Error (core dumped) > > Sound familiar!! Sorry Andy but I couldn't help any more. I am not familiar with Solari

Re: c program Bus Error (core dumped)

z It worked fine, maybe you should try to compile with debug options and give gdb a try. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: c program Bus Error (core dumped)

o be some "%" inside "whatever" you will get coredumps. For instance, see what happends when in your program, mysql_error(connection) returns "Please use %d to display integers." (Not a real MySQL error, obviously!! :-) Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL unixsocket to tcp connection

My question is: Is there any program that opens a connection to mysql, and that I could use to connect to the database using unixsocket using always the same connection? Anyone have anyother ideia how I could speed up my connection phase? Thanks everyone, José Miguel Fernandes -- My

YOUR EMAIL ADDRESS HAS BEEN ADDED TO MY WHITE LIST

Your email address has been added to my Spam Fighter White List. Adding your address to the White List ensures that I will always receive email you send to me. If you aren't using All-in-One SECRETMAKER, I recommend that you examine this powerful freeware. I recommend All-in-One SECRETMAKER

Compiling 4.0.22 source including some 4.1.x functions

functions (which I suppose I can include them even as UDF functions). Please, anyone could give me advice on that? Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump + enum + default + umlaut

Juri Shimon wrote: Hi, Hello miguel, Tuesday, October 19, 2004, 10:52:03 PM, you wrote: ms> Hi, ms> Thank you for reporting this bug, I already opened the below ms> bug report: ms> http://bugs.mysql.com/bug.php?id=6165 How to repeat: create table t0 (id int not null auto_increment

RE: COUNT Problem

assigned tasks. If you want to > further select which one of the projects with the most assigned tasks you > want, you must order by another column, like date (or filter out the > projects in the WHERE clause). > > Given said that, > > Cheers, > Jo

RE: COUNT Problem

must order by another column, like date (or filter out the projects in the WHERE clause). Given said that, Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

subquery??

all female employees and, if exists the respective contacts…   Thanks 4 your help Best Regards Miguel Joaquim Rodrigues Loureiro  - Software Development * Internet Solutions -   <> smime.p7s Description: S/MIME cryptographic signature

  1   2   3   4   5   >