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

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

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

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

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

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

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

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 archives:

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, \n;

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 PROTECTED] Sent:

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

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

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

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

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 start

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

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

RE : Dropping foreing key without losing data

[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 desactivate a foreign

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

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

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

RE : Optimizing

. 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 P3 1GHz 512M server I now

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

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 with an error like this: Can't find file

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

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

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

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

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 existing

RE : Duplicate key delete record with same key

, `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, 2002 3:31 PM To: BPF Webmaster; MySQL Subject: Re

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

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

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:

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: Wednesday, October 09, 2002 9:52 PM

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

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

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

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾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

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:

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,

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

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 =

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 the

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

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, try

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 happened:

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

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

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

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

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

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

like to delete -- Original Message -- From: Justin Farnsworth [EMAIL PROTECTED] Date: Tue, 25 Dec 2001 09:28:53 -0500 I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: Hello.. of all days i

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] Reply-To: [EMAIL PROTECTED] Date: Tue

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 bad!.. today.. of 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

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 to see if it was a linux problem

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. br). Do I need to change the type of field ?. At the moment the html code is being returned as plain text.

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:

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 choose a

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...

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') you

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 file:

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

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

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 numbers

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

How to round

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

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

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

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 the

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

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

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

Re: SQL help

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: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:38 AM Subject: SQL

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 have some PHP and perl scripts that do

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

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

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

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

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 -

test

test - 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

please urgent

I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 4.0, acording to the info for this ver of php this ver has all the odbc connetciones incluided, the ver 3.0 has a library called php3_oci80.dll wich is used for conections to oracle 8, where can I find all the librarys

JDBC question

I am , well I will have to wioork with oracle and jdeveloper, can some of you please please please telll me where canI find examples of conections to a database an oracle databse and if I use php again eh the same question where can I see examples of conections to an oralce data base

JDBC-MySql==Sex?????????

Hi Everyone, Sorry for the subject but I am in a very very desperate state 'coz the whole site is down and if I cannot connect to the database through my servlet my @ss is grass. Everything seems to be working fine except when I execute the servlet I get this @$#$@$# error: " Server

Re: Problems with mySQL and DBTools

do any one knows about a mailling list of oracle? wich is the eamil address for subscribing to it? please mail me back ASAP, cheers On Thu, 8 Feb 2001, clay bond wrote: Date: Thu, 8 Feb 2001 13:23:08 -0500 (EST) From: clay bond [EMAIL PROTECTED] To: unlisted-recipients: ; Cc: [EMAIL

  1   2   >