ORDER BY DESC, missing rows
I have a problem with a bulletin board type system. When a new message is posted the script redirects back to the page that displays the messages. If I do a simple query i.e. SELECT * FROM messages WHERE subject='$subject'ORDER BY ID Then all relevant messages are displayed including the one just added. If I want to display the last message first SELECT * FROM messages WHERE subject='$subject'ORDER BY ID DESC Then the last couple of messages are always missing! -- Best regards, Pat [EMAIL PROTECTED] - 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
Change of Directory
hello sir, we are using MySql is my backend in SunSolaries5.8. I got a problem with present slice (/usr/local/mysql) where mysql is installed. Now i want to chage my database into another slice(/export/home/database) with out any dirstrubence to database. Can i move my present directory /ust/local/mysqlto /export/home/database/mysql and change the path and class path. This will work?.. What should i take necessary steps and precautions before i change.. Plz guide in this regard. thank you very much sekhar Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - 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: Re: distinct / limit optimization
X Gogo writes: Well, the order in which the queries are made doesn't matter. The query with LIMIT is always slower than the one without it. When I used EXPLAIN SELECT... I actually found that MySQL uses temporary table for the query with the DISTINCT / LIMIT combination. I presume this slows it down. Be well :) George What version of MySQL are you using ?? If not the last available, give it a try. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.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: bug please help
At 14:58 29/06/2001 -0500, Jose Garcia wrote: Hi, Please read the Manual on \mysql\docs the chapter: 8.7.2 InnoDB startup options Notice that you need to create 2 directories before the start called c:\ibdata and c:\iblogs in the sample. I you don't want the support of tables InnoDB use the below variable in the configuration file: skip-innodb Regards, Miguel I was trying to install Mysql in win 98 and after several attempts all I got was: (using mysqld command) (I also send you the my.cnf file I had to edit several times) Please help InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 3145728 Innobase: Assertion failure in thread 4294055337 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010629 14:51:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010629 14:51:37 Aborting InnoDB: Warning: shutting down not properly started database 010629 14:52:12 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.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
mysql, perl and retrieving long column
Hi,
If I have a table:
create table messages (
id int unsigned not null unique,
datalongtext );
and I have a perl script:
1 $sth = $dbh-prepare( SELECT data FROM messages WHERE id = ?;);
2 $sth-execute($id);
3 $data = $sth-fetchrow;
QUESTION:
will the script stop at line 3 until all data is read into $data?
(i think it is)
if so, if data is 4GB long, and my NT has 512MB RAM and 512MB
pagefile, will the server crash from out of memory?
seeing that #2 is a big problem, is there a way to retrieve data
safely? like retrieiving sections by sections similar to
open SFILE, filename;
binmode SFILE;
while (SFILE-read($data,1)) { print $data; }
can I use mysql's substring function?
$i = 0;
while (1)
{
1 $sth = $dbh-prepare( SELECT substring(data,$i,1) FROM messages
WHERE id = ?;);
2 $sth-execute($id);
3 $data = $sth-fetchrow;
4 print $data;
5 $i += length($data);
others here
}
-
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: system error 1067
At 23:46 29/06/2001 -0500, Tyler Longren wrote: Hi, The 1067 error, means an MySQL server aborted. The cause should be: - Missed (dropped) or corrupted MySQL grant tables. - Problems with the \share directory or errmsg.sys files. - Wrong variable(s) on the configuration file (my.ini\my.cnf) Troubleshooting: - Take a look at \mysql\data\mysql.err file if the last lines you find the cause of the abortion. - Rename the my.ini/my.cnf file and try to start the service using the defaults values. If well success, then the problem is a variable(s). If the 2 items above, don't resolve the problem. Do: - Remove the service: mysqld-max-nt --remove - Start the server in standalone mode to see the message errors: mysqld-max-nt --standalone --skip-innodb Try to correct the errors show by the last command and re-install the service. Regards, Miguel Hello everyone, I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had been running just fine, then all of a sudden stopped working. When I try a 'NET START mysql', I get the below error: ---Begin Error The MySql service is starting. The MySql service could not be start A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. ---End Error Has this happened to anyone else? Or am I just the unlucky one? Tyler - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.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: bug please help
Hi! You are probably usinf mysqld.exe from 3.23.38. It was accidentally compiled with __NT__ defined. Use mysqld-max.exe or upgrade to 3.23.39. Regards, Heikki http://www.innodb.com At 14:58 29/06/2001 -0500, Jose Garcia wrote: I was trying to install Mysql in win 98 and after several attempts all I got was:(using mysqld command) (I also send you the my.cnf file I had to edit several times)Please help InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib logfile0 size to 3145728 InnoDB: Log file c:\iblogs\ib logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib logfile1 size to 3145728 InnoDB: Log file c:\iblogs\ib logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib logfile2 size to 3145728 Innobase: Assertion failure in thread 4294055337 in file M:\mysql-3.23\innobase\os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010629 14:51:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010629 14:51:37 Aborting InnoDB: Warning: shutting down not properly started database 010629 14:52:12 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete - 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
how do I reset an auto_increment index to match the number of records in the DB
Ok could some kind soul point me to the doc's for reseting the index after deleting a few records below is my database and I did a delete where rec 0 and it worked however the index is still at 6 how can I correct this or reset the index to the number of records in the data base hum... Thanks for the help going to try the doc's again :) # Server version3.23.39-log # # Table structure for table 'guestbook' # CREATE TABLE guestbook ( name varchar(100) default NULL, age varchar(4) default NULL, email varchar(150) default NULL, website varchar(254) default NULL, comments text, time varchar(100) default NULL, rec int(11) NOT NULL auto_increment, PRIMARY KEY (rec) ) TYPE=MyISAM; # # Dumping data for table 'guestbook' # - 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 transaction related question
Hi!
MySQL provides three transaction-safe tables including Berkeley_DB, GEMINI
and InnoDB Tables, I have some queries on them:
1. What are the differences between these three type of transaction-safe
table types?
BDB has only page level locks, InnoDB has row level locks and an Oracle-
style consistent non-locking read, Gemini has row level locks.
2. Which type should be used for the E-Commerce web site?
Use a transactional table type, but I am biased to give any further
opinion.
3. Is true that BDB is free while the other two are not free?
No it is not true. InnoDB is published under the same GNU GPL license
as MySQL itself.
4. In MySQL, we can use transaction as the following:
BEGIN;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summmary=@A WHERE type=1;
COMMIT; (or ROLLBACK)
but how to apply it in the E-Commerce web site with PHP programming?
From the PHP website www.php.net I found the following example.
?php
$link = mysql_connect(mysql_host, mysql_login, mysql_password)
or die (Could not connect);
print (Connected successfully);
mysql_select_db (my_database)
or die (Could not select database);
$query = SELECT * FROM my_table;
$result = mysql_query ($query)
or die (Query failed);
// printing HTML result
print table\n;
while($line = mysql_fetch_array($result)){
print \ttr\n;
while(list($col_name, $col_value) = each($line)){
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
mysql_close($link);
?
Best regards,
Heikki
http://www.innodb.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
Diagrams and Flowcharts on mySQL tables
I have a bunch of tables and would like to get an overview. Does a program (with pref. Win32) exist with takes mySql tables and represents them graphically where you could draw your link and print them out? Regards Robert Goeres - 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
Access to Other Databases Thru MySQL
Dear Sirs, We are new in MySQL. We work basically with Microsoft Access. Please can you give us same info about: To make links, like MSACCESS to other Types of Databases in Linux/Windows, using Java, thru MySQL? Our need is to access to MSACCESS, ORACLE and SQL Databases in java, having the links to those other Databases defined in MySQL, and not by importing the data in those databases to a table in MySQL. In MSACCESS/WINDOWS we can do that using ODBC. In MySQL how can we do it? Best Regards, Manuel Mesquita Rapidata, Lda Email: [EMAIL PROTECTED] - 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: Diagrams and Flowcharts on mySQL tables
I have a bunch of tables and would like to get an overview. Does a program (with pref. Win32) exist with takes mySql tables and represents them graphically where you could draw your link and print them out? I don't know what you mean, but I manage my dbs and tables with phpMyAdmin and am pretty happy with it as are numerous others. You get it at http://www.phpwizard.net/projects/phpMyAdmin/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
mysql/php query from 2 tables
im having problems getting results querying two tables but I am not sure of the correct php syntax for the query statement below. It always yields 0 results. $query2 = select * from dir,free where 'dir.inst' = free.inst'; This is what I use in mySQL database but I get 0 results when querying from php. SELECT* FROM dir,free WHERE dir.inst = free.inst Any help would be greatly appreciated. felicia The last of the human freedoms is to choose one's attitudes. -Victor Frankl - 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
tough query
i have 3 tables: offers, rewards, and sources. sources has just a source name and source id. both the offers and rewards tables have a source_id field which relates to the sources table. i need to write a query that selects the source name and the count in each table with that source id. is this possible? i tried: select s.source_name, count(o.source_id) as offer_count, count(r.source_id) as reward_count from sources as s, offers as o, rewards as r where s.source_id = o.source_id and s.source_id = r.source_id group by s.source_id order by s.source_name; the AND makes it produce no results. so i tried: select s.source_name, count(o.source_id) as offer_count, count(r.source_id) as reward_count from sources as s, offers as o, rewards as r where s.source_id = o.source_id or s.source_id = r.source_id group by s.source_id order by s.source_name; notice the or instead of and...this produces invalid results. someone help please! =) TIA, Daren Cotter - 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: tough query
i have 3 tables: offers, rewards, and sources. sources has just a source name and source id. both the offers and rewards tables have a source_id field which relates to the sources table. i need to write a query that selects the source name and the count in each table with that source id. is this possible? i tried: I hope I understand your problem. If you want results in each table, you should make two selects, one for each table, to get the result for each. If you have 3 in table rewards and two in table offers, what do you expect to get from a combined query? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Diagrams and Flowcharts on mySQL tables
Try Dezign for Databases. Works pretty well and is much cheaper than the big ones (ER/Studio and ERWin) http://www.datanamic.com/dezign/ -- Original Message -- From: Robert Goeres [EMAIL PROTECTED] Date: Sat, 30 Jun 2001 16:37:28 +0200 I have a bunch of tables and would like to get an overview. Does a program (with pref. Win32) exist with takes mySql tables and represents them graphically where you could draw your link and print them out? Regards Robert Goeres - 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: Diagrams and Flowcharts on mySQL tables
powerdesigner from sybase works very well. it's very expensive though... you cna get a trial from the sybase web site. -Original Message- From: Jack Baty [mailto:[EMAIL PROTECTED]] Sent: 30 June 2001 09:17 To: [EMAIL PROTECTED] Subject: Re: Diagrams and Flowcharts on mySQL tables Try Dezign for Databases. Works pretty well and is much cheaper than the big ones (ER/Studio and ERWin) http://www.datanamic.com/dezign/ -- Original Message -- From: Robert Goeres [EMAIL PROTECTED] Date: Sat, 30 Jun 2001 16:37:28 +0200 I have a bunch of tables and would like to get an overview. Does a program (with pref. Win32) exist with takes mySql tables and represents them graphically where you could draw your link and print them out? Regards Robert Goeres - 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 - 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
Replication
i was wondering if anyone could help out with some replication stuff. i went through the instructions from mysql.com and when i restarted the slave, it said that it was not configured correctly.
Re: Access to Other Databases Thru MySQL
In the last episode (Jul 01), Manuel Mesquita said: To make links, like MSACCESS to other Types of Databases in Linux/Windows, using Java, thru MySQL? Our need is to access to MSACCESS, ORACLE and SQL Databases in java, having the links to those other Databases defined in MySQL, and not by importing the data in those databases to a table in MySQL. In MSACCESS/WINDOWS we can do that using ODBC. In MySQL how can we do it? MS Access is a front-end as well as a database. Think of MySQL as more like MSSQL Server or Oracle -- just the database component. You don't use SQL server to build an interface; you do that in Access and link tables to MSSQL. Same thing with MySQL. You build the interface in MS Access, Delphi, VB, C, Perl, whatever. -- Dan Nelson [EMAIL PROTECTED] - 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
Strange pseudo-coded query
I am working with a commercially supplied database of zipcode numbers and related data. In the documentation, the following pseudo-coded SQL queries are included. I am mystified by two things here: 1) [Zip Code Distance Extractor] -- I have no clue as to what this is referring to 2) the use of the ! operator makes no sense to me in this context help? Thanks in advance... --- included text --- Programming Notes Zip Code Distance Calculator Tables: 1. CPA Firms Table (CPAFIRMS) Fields: 1) First Name 2) Middle Name 3) Last Name 4) Company 5) Address 1 6) Address 2 7) City 8) State 9) Zip Code 10 digit 10) Delivery Point 11) County 12) Code Number 13) Zip Code 5 digit 2. Zip Code Latitude Longitude Table (ZIP-LAT-LONG) Fields: 1) Zip Code 5 digit 2) Latitude 3) Longitude 4) City 5) State 6) County Queries: 1. Find Center Zip Code Finds matching Latitude/Longitude from ZIP-LAT-LONG table. SQL CODE: SELECT [ZIP-LAT-LONG].[ZIP CODE], [ZIP-LAT-LONG].LATITUDE, [ZIP-LAT-LONG].LONGITUDE FROM [ZIP-LAT-LONG] WHERE ((([ZIP-LAT-LONG].[ZIP CODE])=[Forms]![Zip Code Distance Extractor]![Zip Code])); 2. Find Distance Calculates Distance from Center Zip Code Query against Zip Codes in the ZIP-LAT-LONG table. SQL CODE: SELECT [ZIP-LAT-LONG].[ZIP CODE], [ZIP-LAT-LONG].LATITUDE, [ZIP-LAT-LONG].LONGITUDE, ([ZIP-LAT-LONG]! [LATITUDE]-[FIND CENTER ZIP CODE]![LATITUDE])*69.1 AS [Distance Lat], (69.1*([ZIP-LAT-LONG]! [LONGITUDE]-[FIND CENTER ZIP CODE]![LONGITUDE])*(Cos([FIND CENTER ZIP CODE]![LATITUDE]/57.3))) AS [Distance Long], ((([Distance Lat]^2)+([Distance Long]^2))^0.5) AS Distance FROM [ZIP-LAT-LONG], [FIND CENTER ZIP CODE]; 3. Find Distance by Radius Limits the results of the Find Distance Query by the radius number. SQL CODE: SELECT [Find Distance].Distance, [CPAFIRM'S].COMPANY, [CPAFIRM'S].FIRST, [CPAFIRM'S].MIDDLE, [CPAFIRM'S].LAST, [CPAFIRM'S].ADDRESS1, [CPAFIRM'S].ADDRESS2, [CPAFIRM'S].CITY, [CPAFIRM'S].STATE, [CPAFIRM'S].ZIPCODE FROM ([Find Distance] INNER JOIN [ZIP-LAT-LONG] ON [Find Distance].[ZIP CODE] = [ZIP-LAT-LONG].[ZIP CODE]) INNER JOIN [CPAFIRM'S] ON [ZIP-LAT-LONG].[ZIP CODE] = [CPAFIRM'S].ZIP5 WHERE ((([Find Distance].Distance)=[Forms]![Zip Code Distance Extractor]![radius])) ORDER BY [Find Distance].Distance; --- end included text --- - 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
FreeBSD version availabe at their web site
mySQL says; The easiest and therefor the preferred way to install is to use the mysql-server and mysql-client ports available on http://www.freebsd.org. So my question is ,,do these mysql-server and mysql-client ports from FreeBSD include the Innodb tables support like mySQL-Max does? I can;t seem to find any info on this.. P.S. this was my first attempt at mailing to a mailng list I hope it was to the right address..:) Ken
CHECK TABLE
Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: CHECK TABLE
Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: CHECK TABLE
On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote: it doesn't work on 3.23.32 either! Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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: CHECK TABLE
3.23.38 does -Original Message- From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing Corp.]On Behalf Of MikemickaloBlezien Sent: Saturday, June 30, 2001 4:35 PM To: [EMAIL PROTECTED] Cc: Werner Stuerenburg; [EMAIL PROTECTED] Subject: Re: CHECK TABLE On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote: it doesn't work on 3.23.32 either! Check table didn't exist in 3.22 Werner Stuerenburg wrote: Sorry, I don't understand from the manual how to use this (running MySQL 3.22.32 on RedHat) I tried to issue CHECK TABLE tbl_name as indicated, but get mysql CHECK TABLE sessData; ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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 Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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
php4, SQL, win98 configuration...
greetings, anyone know where a person could find information on configuring php4 for Win9x as a PWS in correlation with mysql...have only found information on configuration for Win2000 which is different from Win9x? also, based on the information ive gathered for php4 for Win2000, it advises to install IIS for php4 configuration...if this holds true, does IIS also need to be installed on to Win9x for configuration of php4 for a PWS(Personal Web Server)? appreciate any feedback... from, beginner - 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: php4, SQL, win98 configuration...
From PHP PHP 4.0.6 [755Kb] - 23 June 2001 (CGI only, MySQL support built-in, packaged as Windows installer to install and configure PHP, and automatically configure IIS, PWS and Xitami, with manual configuration for other servers. N.B. no external extensions included) Go to http://www.weberdev.com/ and Join -Original Message- From: stompbot [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 30, 2001 5:47 PM To: [EMAIL PROTECTED] Subject: php4, SQL, win98 configuration... greetings, anyone know where a person could find information on configuring php4 for Win9x as a PWS in correlation with mysql...have only found information on configuration for Win2000 which is different from Win9x? also, based on the information ive gathered for php4 for Win2000, it advises to install IIS for php4 configuration...if this holds true, does IIS also need to be installed on to Win9x for configuration of php4 for a PWS(Personal Web Server)? appreciate any feedback... from, beginner - 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
At SHOW STATUS what do you mean by big?
Hi The SHOW STATUS command: At status variables list there are some times an explanation using the expression: if x is big or This will be high if you are What basic value can I use to determine what is Big or High ? Some % of Questions ? Regards Rui Torres
