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]
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]
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]
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: 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.id0; 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: 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: 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]
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
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
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('a href=', link, ''), link, '/a') 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
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. Beln. 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. Beln. 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. Beln. 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
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? -- /chris 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: 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
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: 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
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 Beln. 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
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 Beln. 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