Re: ANN: Upscene releases Database Workbench 5.4.4

Sent from my Samsung Galaxy smartphone. Original message From: "Martijn Tonies (Upscene Productions)" Date: 09/07/2018 13:17 (GMT+00:00) To: firebird-to...@yahoogroups.com, mysql@lists.mysql.com Subject: ANN: Upscene releases Database Workbench 5.4.4 Upscene Productions

RE: Machine Learning

Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:ga

RE: Machine Learning

Ah, Getting clearer and clearer. So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For instance, N1 runs a command in ‘domain’ D20 which it successful – it send information to node N20 that is the authority on domain D20 and N20 records it as success; N5 runs a comman

RE: Machine Learning

Hi Garot, Ok, the concept is getting clearer, but let’s bring this down to earth a little bit more. I love DB design and problem-solving and am quite curious about this. Is the idea that you have a central computer (not HAL J) somewhere so that other computers can: 1) Refer to it for

RE: Machine Learning

Hi Garot, You'll have to elaborate some more ... I understand you may want to protect the idea as well, so if you can narrow it down to some technical specifics then it'll help. What is the objective of this system, for instance ? Thanks, Justin From: Martin Gainty [mailto:mgai...@

RE: Machine Learning

Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating syst

RE: Database design help

Hi Neil, May be your question is too vague. You have already identified the 'real world' objects that you want represented in the database. Have you identified the specific pieces of information that you want stored for each object ? After you do that, you can then start to see what the relation

RE: Count Query question

Hi Keith, The way I would go about this is to try and pinpoint what the issue is, by breaking the query up. For instance, if you remove the 'product_quantity > 0' condition, do you get any more rows in your result ? I also notice that your 'products_date_avaiable' is defaulting to '2008-10-01

Re: Upgrade Mysql

Thank You for all the help. I was upgrading from 4.0.x to 5.0.x The new mysql recognized the old databases without problems. Bye :)

Upgrade Mysql

Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be "recognized and imported" to

Joins with sums

I'm missing something really silly in a query. I want to produce a list of accounts, the invoices and receipts and the balance against them. Simply, there is an accounts table, invoices and receipts. I want to show the account details, sum(invoices), sum(receipts) and the balance. There is a sit

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

Hello, Not wanting to "hijack" this thread, but what is the best source for a zip code database? The "best" free one I could find was from census data from the last census. Sometimes it won't recognize all the zips from large cities. Thanks, R -- MySQL General Mailing List For list archiv

One question about Perl DBI interface.

Good morning! Important: SQL Server used: MySQL (version 4.0.17) on UNIX FreeBSD. Answer this question please: Can I make a request, consisting of several SQL commands at one step, like this: use DBI; my $db = DBI->new(); $db = DBI->connect(...) or die "Can't connect to DataBase:", "error code",

It is possible to copy the database of mysql-3.22.32 on version 4.0.20? There is possibility that they work?

It is possible to copy the database of mysql-3.22.32 (/usr/local/mysql/var) on version 4.0.20 (/usr/local/mysql_new/var)? There is possibility that they work? My O.S. is Solaris 8 Thank's Alessio P.S. In that case I must use the function "mysqlhotcopy"? I don't have the possibility to use

Fw: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

> Yare sure that this resolves my problem? > My problem is the client graphical (webmin or phpmyadmin), working from > shell (SSH) is all to place. > Thanks > Alessio > > > - Original Message - > From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECT

Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the suggestions of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin (last version -2.6.0-pl2) I have this problem: "DBI connect failed : Client does not support authentication protocol requested by serve

Mysql-4.1.7 Start - Ended error - Solaris 8

Sorry form my english, I am Italian. They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the suggestions of Gleb Paharenko. Now I have this problem: When start the command "mysqld_safe &" mysql start and ended immediately. In the log file I find this error: "041115 20:4

Solaris 8 error make on mysql_4.1.7

Sorry form my english, I am Italian. I have a problem when run "make", the error is following g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include -g -DSAFE_MUTEX -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/download/mysql_4.1.7/mysql-4.1.7/include -DHAVE_RWLOCK_T -c -o mysql.o `test -f 'm

Help query with MySQL 4.0.11

Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma The query is: SELECT U.usu_id, U.usu_login FROM cva_usuario U WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U usu_id Where GU.gru_id=4) Help please.

Problem Query EXISTS and IN

Hi (Sorry by my english, i speak spanish) I have problem with a Query. It does not recognize EXISTS nor IN nor NOT IN My version is MySQL 4.0.11a-gamma But I do not know if it recognizes those clauses. I have dealed with the two forms: 1. SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT

Re: Signal 11 shortly after upgrading to 4.0.12

The problem appears to be caused by inadvertently running mysql_convert_table_format on a database which had a few Berkeley DB tables. The other databases seem to work well. The comment given in http://www.mysql.com/doc/en/Upgrading-from-3.23.html about the use of the script should be more clea

Signal 11 shortly after upgrading to 4.0.12

>Description: I upgraded Mysql from 3.23 to 4.0.12, and everything went well. I even installed MySQL-Max, and the server restarted and apparently was well. However, when I stopped the daemon with service mysql stop" and then tried to start it again ("service mysql start"), refuses to sta

Load Data Infile problem.

Hi List. I have been working on a problem that is driving me crazy. I have to create a process in which I upload some info to a table. Since I have to add some different information to that table, I decided to do it like this. 1.I create a temporary table copying the structure of my final table.

RE : Dropping foreing key without losing data

reant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or

Dropping foreing key without losing data

Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - Before posting, please check: http://www.mysql.com/manual.php (the manual)

ÓòÃû×¢²á,ÐéÄâÖ÷»ú

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǺͿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»

RE : Optimizing

ces ? Use top to find out. What are the memory parameters used in my.cnf ? The answers to these questions will provide some helpfull answers to your problem. Simon On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote: > I migrated my site from a low end PC mutualized hosting to a brand new >

Optimizing

I migrated my site from a low end PC mutualized hosting to a brand new P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL slower now, the time for a PHP page is now about 6 seconds and was about .6 before!!! I haven't done any optimization and the DB is the same, so the size (ab

Re[2]: temporary and merge tables

Hi, sorry, didn't look at the changelog... ;) thanks! corin Monday, December 30, 2002, 9:29:12 AM, you wrote: PD> At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote: >>Hi, >> >>when trying to create a temporary table of type merge, mysql >>2.23.53 fails

temporary and merge tables

Hi, when trying to create a temporary table of type merge, mysql 2.23.53 fails with an error like this: Can't find file: '#sql24b_776_0.MRG' (errno: 2) when not using the temporary keyword, everything works fine. so i assume this is a missing feature (not documented that this is forbidden/not sup

ÓòÃû×¢²á,ÐéÄâÖ÷»ú

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǺͿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»

MySQL on virtual hosting

Dear list, Does any of you guys operate a mysql server in virtual hosting environment? I need some advice on tuning and restriction based on system resources. My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1 giga of RAM. I have 2 hd's in raid 1 mode (hardware). I currenl

RE : RE : Duplicate key delete record with same key

Victoria, So I looked deeper in my PHP code (I wrote it in February 2002) and saw I use a REPLACE statement: class persistent { // put method to save properties into the DB function put($thePrefix) { // job no

RE : Duplicate key delete record with same key

', `joined` bigint(20) default NULL, `expired` bigint(20) default NULL, `status` varchar(20) NOT NULL default '', PRIMARY KEY (`account`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM A+ JM -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21,

Duplicate key delete record with same key

Using PHP 4.2.3 with MySQL 3.23.52 Report: --- - Table has 2 keys: 'account' as PRIMARY and 'id' as unique - I make an SQL update on an existing a record with id="anid" setting id="anotherid" but another record exists with id ="anotherid" - The update is performed and the record already existi

MySQL Process ID & Unix PID

Hi, Is there a way to compare between a mysql process ID showed in top or ps with a process ID from mysqladmin processlist ? I'm asking this because we operate a mysql machine used for webhosting and it has many users and many databases. If users do crazy stuff that result in high usage of resou

Crystal Reports & MySQL

Hi, does anyone knows if Cristal reports is a good reporter to make reports out of MySQL, or does anyone knows a good reporter for PHP MySQL? Thanks The Vampmaster - Before posting, please check: http://www.mysql.com/manua

Fw: FLOAT EQUAL OPERATOR

Rimini (RN) Internet : http://www.infotel.it e-mail : [EMAIL PROTECTED] --- --- - Original Message - From: <[EMAIL PROTECTED]> To: "WebMaster - Infotel Telematica S.r.l." <[EMAIL PROTECTED]> Sent: Wednesd

using php to connect to a 2nd mySQL server

Hello all, I am new to this list ... and hope to find an answer to a question which has come up. On the server for my websites at my ISP, a mySQL server is installed to handle different customers' databases (1 database setup for each customer) Now, as I have a need for a mySQL server where

RV: off-topic informix to oracle.

Sorry but I'm sure one of you guru's knows about the best software (ltl) to migrate informix database to Oracle, I need to link then oracle to MySQL, and then to report via crystal reports. EJB - Before posting, please check:

install mysql on osx 10.2

Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james --

RE : How to see warning messages for load data infile

Maybe try one line... I got this tons of warnings this morning making an import from Excel. But it was apparently successful...but all decimal value where store truncated like 128.00 , the reason is I'm in France and Excel exports decimal with coma 128,34 but MySQL expects 128.34 so I just replac

Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ

Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ

MAX_ROWS

Hello, I created a table using: "CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (pa)) TYPE=HEAP MAX_ROWS=10" Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned 16 records. Why this??? Does i should return only the last 10 records I inserted???

HEAP tables

Hello everybody, I have two questions: 1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I insert more 3 records. Does mysql delete older records and insert new ones?? 2) I created a table using this: CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (p

Need some direction please

Here's my dilema. Our website runs a quarterly prize giveaway. Currently we have an ASP form that gathers the inputed info into a database and then sends us an e-mail confirmation of the entry. Our rules specifically state that only one entry is allowed per quarter. As I am not a programmer (just

Re: Re: mysql uses 99% cpu under freebsd 4.3

> So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - Before posting, please check: http://www.mysql.com/ma

Re: Using RAND()

Hi When I used the RAND() function (MySQL 3.23.45) I found the results were not very random, instead I use an extra bit of php code to make sure the results are more random. mt_srand((double)microtime()*100); $sql = "select order by RAND(".mt_rand(0,32767).") limit 50" $rs = mysql_query

MySQL performance issues - PLEASE ADVICE!!

I am having performance problems with my MySQL installation - what would be an appropriate channel for requesting help to such a problem? I have posted to this list twice and another one as well. Volumes are very high on using MySQL/standard SQL questions, but not an single suggestion has been s

Re: Maximum number of rows in the table

> I don't think there is a limit. > Just as long as your harddisk can contain the data there should be no > problem. Yes, I guess this should be the case. Theoretically, though; the limit would be the number of indexable rows, wouldn't it? Since the integer length used to store this is 11 digits,

Problems with MySQL on FreeBSD4.5

(Sorry if I am reposting this now, guys...ehe) I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 3.23.49). >From time to time top shows that it runs >98% of CPU time, and of course the site's >response gets sluggish... Sometimes queries even times out or MySQL

Problems with MySQL on FreeBSD4.5

I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 3.23.49). >From time to time top shows that it runs >98% of CPU time, and of course the site's >response gets sluggish... Sometimes queries even times out or MySQL reports that no sockects are free to complete th

Re: What is `Aborted Clients` ?

Hi >> Can anyone explain me what is an Aborted Client ? I begin to wonder about this because this number was about 20 or 30 last week, and now suddenly it got above 200 ! I have no idea of what it means, so any help would be appreciated. << This is incremented if one of the following has happene

Re: general query

Hi >>We say MySQL is open source database, so it can easily be adjusted to your requirements. But I wonder how many administrators have actually gone into the source code and made any modifications to match their specific needs, if any. << The point is you "can" make modifications if you want to

Sorts

Hi List, If I run the sql query SHOW STATUS how can I tell how many queries required sorting? Here are some of the variables SHOW STATUS returns Questions 6623371 Sort_merge_passes 357 Sort_range 29213 Sort_rows 11271509 Sort_scan 231944 I want to try and calculate the percentage of sort

select first or last row

Hi MySql Details My server is running MySQL 3.23.45 and I have 4.0.0-alpha-nt on my local test machine. What is the fastest way to select the first or the last row from a database? I have tried queries like this (id is an auto incrementing primary key) select * from names order by id de

Re: ADO API & ODBC Alternative help

Hi! Check the "MySQL with ASP" Forum at www.dwam.net/mysql/ in particular a thread called "Multiple Step Error" You can also find working ADO code samples on the site (using AddNew method) Finally you should consider using the latest MyODBC drivers 2.50.39 if you want to stick to 2.xx version 3

update a row without affecting timestamp-type column

Hello all, I have a question which just may very well be ridiculous. In one table, we have a column of type "timestamp". In normal cases, we want any changes to this row to update this timestamp (hence the nature of this datatype). However, there is one case where we do NOT want the timestamp

Re: Hoe to create indexes on existing tables

|Hi, | |I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual |Basic application. | |I had a set of tables which I exported from Access database. |But now, I want to index these tables. How do I go about that? | Hi! the simplest solution is to get a GUI client for MySQL,

Updating tables via cron

I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis. Currently I am resetting the appropriate fields to 0 on a daily and monthly basis (not fun). Is there a

Re: help bad

i meant 3.23.. just so you all know -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 10:26:50 -0500 >i went through my code 20 times.. hit the help sites and all

help bad

i went through my code 20 times.. hit the help sites and all to see if it was a linux problem or what.. i am running 4.05 php 2.23.37 mysql (i believe, been awhile sine i touched it *l*) its definately 2.23 i can say i even got the 2.1 gd installed with it thought took a week still shows as 1.6 t

help please!-- i -hate imail! *l* which is why ask a cc to my reg account

Back | Next | Reply | Reply All | Forward | Delete | Move To database / sql/ mysql Message: 1 of 11122 Printable Version From: [EMAIL PROTECTED] Save Address Date: 25 Dec 2001 15:14:07 - To: "Webmaster" <[EMAIL PROTECTED]> Subject: Re: Re: Need Help b

Re: Need Help bad!.. today.. of all days!

hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough "alot dont" -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> R

Re: Need Help bad!.. today.. of all days!

$i_sub++;}; i know theres some redundant code in there etc.. but hey.. till it works i dont like to delete -- Original Message -- From: Justin Farnsworth <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 09:28:53 -0500 >I think y

Need Help bad!.. today.. of all days!

Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two

html ina text feild

I've set up a database with a text feild and want to call that information with html code embeded into the text( eg. ). Do I need to change the type of field ?. At the moment the html code is being returned as plain text. -

question!!!

Hi All: I have Mysql,Php and apache webserver running on Freebsd 4.3 RELEASE, I need to connect via Web to an application done in php but that requests me user and password. - Before posting, please check:

Need A book for dynamic website

Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Wel

Problem mysql installation

Hi all; i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, when I execute a make i get an error "make: no target to make". Thanks and have a great day! - Before posting, please check: http://www.my

Re: ASP & MySQL

YES!!! I use ASP and MySQL... Works Great (Win2K, IIS5.0) John (www.smalltownworld.com) - Original Message - From: "L_U_I_Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 2:08 PM Subject: ASP & MySQL > I'm developing an application and I have to cho

Re: Can some PLEASE tell me what this error means

ASP question... not MySQL (if I understand correctly...) But just do a replace... variabletoinsert = replace(thevariablecomingin,"'","\'") INSERT INTO ASP (title, description, code, user, email, date_created) VALUES ('title', 'description', '" & variabletoinsert & "', 'user', 'email', 'now')

Re: Please Advice

I am using ASP and MySQL and am very happy with the performance! If you are on a Windows box, and have IIS5, there is no reason not to use ASP and the MySQL/MyODBC set up... it really does work well... (you could, of course, install PHP on your Windows box... (www.php.net)... I do like PHP... and

Missing libmysqlclient.so.6

Hi: How I can install or copy mysqlclient.so.6 without reinstall?? I'm trying to execute PHP script (Phorummail) from shell, but I receive that this lib is missing. [root@corotu docs]# ./phorummail > > php: error in loading shared libraries: libmysqlclient.so.6: cannot open shared > > object fi

Select without taking all items

Hi I am trying to write a query that pulls all the items from a database except two here is what I am using: $query = 'SELECT DISTINCT Type FROM Products WHERE Type != "System, Upgrade"'; This populates the drop down box with all including the System and Upgrade. What do I have to do to make t

Drop Down Boxes

HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design http://ww

New member question

I have just subscribed to this list, so forgive me if my question has been answered many times before but I was not sure where else to find this information. I am new to mysql and am going to be using it on a website that I maintain. My question is, is there a program/utility or easy way to conv

Cobalt raq4 and mysql

Hi all, I'm looking for a beginners resource for working with Mysql on a raq4 linuxbox. Any suggestions? Bye, Patje... Behandel mij met zachtheid, ik ben een overlevende van het vorige millennium! Handle with care, I'm a survivor of the previous millennium! -

How to round

> >How to round the result number after the multiplication, >below are the PHP codes, > >any help greatly appreciated > > > > >If (@$rcurr =="") >{ echo (""); > >?> > >while ( $row = mysql_fetch_array($result) ) >{ echo(""); >echo("" . $row["Room_Category"] . ""); >echo("" . $row["R

How to ROUND numbers

How to round the result number after the multiplication, below are the PHP codes, any help greatly appreciated "); echo("" . $row["Room_Category"] . ""); echo("" . $row["Room_Size"] . ""); echo("" . $row["xsp"] . ""); echo("" . $row["xan"] . ""); echo(""); } echo(""); ?>

encrition /security

I have a customer who needs to have a very secure site, more secure than usual, he thinks that having a secure server is not enough so what kind of security for his transactions can I offer him? we are not talking about money transfers, his bussines is not about money is about information, I n

Challenging SQL Problem

Hello, I am having a lot of trouble trying to find the best way to write the SQL to do the following: I have a table called "referrals." In this table I have a column called "ref." The data in the ref column are of the form "p/$promo_id/$date". An example would be "p/26/20010629" which says p

Question about weird filenames...

I have weis in my mysql data directory, and I was hoping someone could tell me what they were... I understand that most tables will have 3 files associated with them (in my mysql setup anyway): .ISM, .ISD and .frm files. However, I have files like this in my directory: B-431a.ISM, B-431a.ISD,

Clarification wanted

Hi,   We  are developing a portal which has pictures of machines in the form of HTML pages. I want to know whether I can store HTML in Database & can I do search in the HTML pages stored.   Please let me know at the earliest.   Thanks in advance Infiniti. Infotech India Powered by MediaRing

setting an index

I'm not sure if an index would help me or not in this case.. and not sure how to set one at creation. So I'll explain it all My main select is select * from on_db where time>$t_tim ORDER BY place DESC I also run the query select * from on_db where time>$t_tim AND place='thisplace' $t_tim is th

sql manual

is there any sql manaual over the internet0' no matter that is not a mysql specificly, I would like to have a good manual for beguiners, cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Mysql Problem

Hi Here is my my.cnf. pls suggest the changes to make the performance better. I am upgrading to the latest version. === # Example mysql config file. # You can copy this to one of: # /usr/local/mysql/etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific opt

Mysql Problem

Hi I am facing great problems beacuse of Mysql server which is not able to take load. My apache is working fine even when the load average shoots of to 130 but my mysql server goes sleep when the load of apache shoots above 30. I am on a dedicated server. My Mysql Ver 3.22.32 I have red h

Re: SQL help

(*) from it >2) from the above resultset, program to draw whatever number of records you >want. >3) submit the query, select * from it where id in (your random record ids); > > >- Original Message - >From: "Webmaster" <[EMAIL PROTECTED]> >To:

SQL help

How do I write SQL in MySQL to randomly select 5 records from a table? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Re: database problems

.. so it seems the myisamchk is not fixing the tables.. any clues? -- Webmaster AngelHaven.com Gerald Clark wrote: > > Shut down the server before repairing tables. > > Robert Clugston wrote: > > > List, > > I'm having some serious problems with MySQL. I ha

Ever heard of anything like this?

I can't connect to my database via mysql This is the load of crap I'm getting... I would appreciate any input or feedback you have. We are on a virtual server..we set up with this company AITcom.net to be resellers. First of all we are getting this error message when we try to conn

INSERT PROBLEM

Hello all I am running linux mandrake with Mysql vers 3.23.23-beta, for pc-linux-gnu on i686 I've had a problem with recieving to many connections which i am working on but my MAIN problem currently is that it will not allow me to insert into tables. I cleared out all the connections and can que

MYSQL Problem

Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries

MySQLGui for macintosh?

Hi! I am currently building a web site for Sciences-Espace. We work on macintosh computers. I found a version of MySQL for mac but not the MySQLGui (the API), or MyODBC. Please tell if a version for mac exists and how I can get it. Sincerely, SCRIPT --

URGENT - daemon dying frequently

Running mysql 3.22.32-log on Apache virtual server (FreeBSD) I can restart my mysql daemon with ./bin/safe_mysqld - but it only runs for a few hours before dying. Following hints from both the manual and the list, I've tried several things... I've deleted my mysql database and manually re-ins

Double your website traffic

Do you want to double the number of visitors to your homepage everyday? The perfect solution is PopUp Window Exchange! It's a brand new concept from LinkExchange. It will pop up websites instead of traditional banners. As a result, it can bring you REAL web traffic instea

Too Many Connections

I have been on occasion recieving "Too Many Connections" errors which lock up mysql.. I know i can set the connections in my.cnf.. atleast thats what i've seen on this listover the past few months.. For starters.. i dont seem to have a my.cnf according to mysqladmin Default options are read from

mysql error

I have suse linux 7.1, I installed mysql and php, I tyr to connect to the database and I get a socket error why? is there any kind of special confg? I type mysql on a terminal window and get the error msg, cheers - Before

  1   2   >