Re: Search engine database structure
Most search engines use databases. Some search directories or web addresses directly. Some use spiders to collect data. Search engines are as varied as the kinds of jobs they do. First, decide what needs to be searched and what searched for. Then research it. Don't just plug a stock program into a slot and expect it is going to do what you want. If you have ever explored college websites, you might notice that most are large affairs that often have a lot of disjointed and poorly organized pages. Most try to solve bad organization with a stock search engine like ht://Dig or Ultraseek, without realizing that for many prospective customers, it is a lame solution. The ideal, on the other hand, could be a lot more expensive and time-consuming to put together. In any case, take stock of your customers and what they are looking for, and do the research to find something that comes close. On 26 Jan 2001, at 2:26, Tobias Talltorp wrote: As I understand it, search engines use a "special" type of database structure. They have a special table for common words/phrases and another one with all the data. They link theese together by a third one that contains only the ids from the other two, thus making the search much faster. How do they determine the common words? Is it done similar to the FULLTEXT search in Mysql, all words over three characters? I think I have heard someone call it "many to many", but am not sure. Anyway, is there any good tutorial out there so I can design my own? Or perhaps someone could take a few minutes of their time and explain some of it to me. Thanks, // Tobias - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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
[Q]index and data on different disks
Hi! I have so many data more than my SCSI HDD. But I can add large IDE HDD. I have an idea put index files on one HDD and data files to another. What do you think about this idea? What is more effictive, leave data to SCSI HDD or leave indexes on SCSI? ___ Andrey Kotrekhov [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
Installation problems
I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL command, I get the following error: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)" What can I do to rectify this? Rudi von Fintel N Dip Electrical Engineering Light Current Sugar Milling Research Institute Durban (tel) 031 2616882 ext 210 (fax) 031 2616886 - 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
Querying database from another unix box......
Hi guys Havent worked much with mysql or any databses for that matter, I have created a small database on my unix box and I want to make a query to the database from another unix box without telneting in or ssh, I beleive that it runs on port 3306.??? help regards, Mark Coetser support engineer the internet solution telephone (011) 283 5500 / 0860 50 5000 fax (011) 283 5401 http://www.is.co.za - 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: Installation problems
Hi You need to start the server first, using the safe_mysqld daemon -Original Message- From: Rudi von Fintel [mailto:[EMAIL PROTECTED]] Sent: 26 January 2001 13:30 To: [EMAIL PROTECTED] Subject: Installation problems I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL command, I get the following error: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)" What can I do to rectify this? Rudi von Fintel N Dip Electrical Engineering Light Current Sugar Milling Research Institute Durban (tel) 031 2616882 ext 210 (fax) 031 2616886 - 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
MySQL-Warnings
Hi, is there any way to disable all the MySQL-Warnings that are sent to my visitors browsers when the database is down for a moment. I am using the database to count the pageviews, and if the connection to the DB is impossible, there should not be sent any warning to the visitors browser! Is there any way to disable it via PHP or so? Thanks, Martin - 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: Querying database from another unix box......
At 11:36 AM +0200 1/26/01, Mark Coetser wrote: Hi guys Havent worked much with mysql or any databses for that matter, I have created a small database on my unix box and I want to make a query to the database from another unix box without telneting in or ssh, I beleive that it runs on port 3306.??? help You need the mysql client on your computer (check the downloads section at www.mysql.com; they probably have a client-only download). Then you can just use the -h parameter: mysql -u username -h hostname -p databasename Also, the permissions on the database need to be set up to allow access from your computer; see the docs on setting up permissions and the 'GRANT' command. - steve regards, Mark Coetser support engineer the internet solution telephone (011) 283 5500 / 0860 50 5000 fax (011) 283 5401 http://www.is.co.za -- +--- "They've got a cherry pie there, that'll kill ya" --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +-- FBI Special Agent Dale Cooper ---+ - 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-Warnings
* Martin Ramskogler [EMAIL PROTECTED] wrote on 26.01.01 12:36: is there any way to disable all the MySQL-Warnings that are sent to my visitors browsers when the database is down for a moment. I am using the database to count the pageviews, and if the connection to the DB is impossible, there should not be sent any warning to the visitors browser! Is there any way to disable it via PHP or so? This is not a MySQL issue... If you prefix your mysql_connect(...) call in PHP with an "@", it will disable warnings for that function call. Then just check the return value of the call to make sure you get a proper handle, and if not, just don't try to do anything else with mysql (or prefix all of them with @, which isn't probably a very good idea for debugging). -- Tomi Junnila [EMAIL PROTECTED] http://www.badzilla.net/~topeju/ Electronics and Information Technology, University of Turku, Finland - 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: how to get the union of the values in a SET column ?
I have a column that is defined as a SET. For simplicity's sake,
let's say the column is defined as:
set_col SET ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'Z')
After entering a few hundred rows, I know that some but not all
values of the SET have been used at least once. How can one work
out which values have been used at least once ?
Doing a SELECT DISTINCT(set_col) on the table might provide
something like this:
A,B,D
A,C,G,N,M,P
C,E,F,H,I,R,S
C,E,G,I
D,F
G,H,L,M,O
etc
But it then requires processing to work out which
values have been used at least once. It's not very
scalable.
Is there a method to retrieve a list of all the values
that have been used at least once ?
Sir, the basic problem is that you've violated first normal form,
which states columns should only contain atomic (indivisible) data.
Since you plan to divide up the data in your columns, it's obviously
not indivisible.
My recommendation is to brush up on the first three normal forms and
redesign your tables. There may be a way to do what you want with
MySQL functions, but that will require a lot of processing and slow
your queries down. You'll be back where you started, with a solution
that doesn't scale well.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
-
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: Strange behavior of MySQL 3.23.xx with GROUP BY ...
I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ... I have a Table: CREATE TABLE groupbyTEST ( fldNAME varchar(20) NOT NULL, fldMONTH tinyint(4) DEFAULT '0' NOT NULL, fldSALARY decimal(10,0) DEFAULT '0' NOT NULL, fldDATE datetime DEFAULT '-00-00 00:00:00' NOT NULL, PRIMARY KEY (fldNAME, fldMONTH) ); with following records: INSERT INTO groupbyTEST VALUES ( 'stephan', '1', '1000', '2001-01-25 23:12:29'); INSERT INTO groupbyTEST VALUES ( 'boris', '1', '2000', '2001-01-25 23:12:45'); INSERT INTO groupbyTEST VALUES ( 'stephan', '2', '1200', '2001-01-25 23:12:56'); INSERT INTO groupbyTEST VALUES ( 'stephan', '3', '1000', '2001-01-25 23:13:08'); INSERT INTO groupbyTEST VALUES ( 'stephan', '4', '900', '2001-01-25 23:14:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '2', '1200', '2001-01-25 23:15:01'); INSERT INTO groupbyTEST VALUES ( 'stephan', '5', '1900', '2001-01-25 23:15:16'); INSERT INTO groupbyTEST VALUES ( 'boris', '3', '2400', '2001-01-25 23:15:39'); INSERT INTO groupbyTEST VALUES ( 'boris', '4', '2100', '2001-01-25 23:15:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '5', '2300', '2001-01-25 23:16:01'); INSERT INTO groupbyTEST VALUES ( 'boris', '6', '200', '2001-01-25 23:16:11'); A statement like: SELECT fldNAME, fldMONTH, sum(fldSALARY) FROM groupbyTEST GROUP BY fldNAME HAVING sum(fldSALARY)200 should cause an error because of the missing fldMONTH in the GROUP BY clause, but it is executed without an error and results: fldNAME fldMONAT sum(fldGEHALT) boris 1 10200 stephan 1 6000 ... makes not very much sense ... does it?? Sir, why do you think it should cause an error? The statement is valid and the result is correct. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 to create duplicate table using existing table structure
I have tried as MySQL documentation help to create one duplicate table using existing table structure. But, It's raise error. i.e., create table newtable select * from oldtable; mysql mysql create table works SELECT * FROM t_Works; ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM t_Works' at line 1 mysql Please help in this regards. Thanks in advance, SubbaReddy
Re: How to use a database from Sun solaris to Linux
On Fri, Jan 26, 2001 at 01:28:14PM +0100, Legeard Luc wrote: Hello I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux computer. I have installed mysql on my linux and it works Now , i'like to move database from Unix to Linux A copy database ( *.ISD, *.ISM,*.frm) to Unix dosn't work. Also, t have seen that on linux the extention of the file are, not the same (*.MYD, *.MYI, *,frm). The version on unix is 3.22.23 and version on linux is 3.23.23-beta Help! Just read the manual, there's a separate section about this issue. Shame on you... -Remco - 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: How to use a database from Sun solaris to Linux
AFAIK, ISD, ISM is isam type table which are platform dependent. So, you cannot just COPY them. You need to do something trikier (sqldump and then restore using mysql) MYD, MYI - are myisam tables and they are declarede platform independet. You can move then around w/o trouble (AFAIK again). Mysql 3.23 support isam, myisam and dbd tables. And of course, RTFM. - Original Message - From: "Legeard Luc" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 3:28 PM Subject: How to use a database from Sun solaris to Linux Hello I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux computer. I have installed mysql on my linux and it works Now , i'like to move database from Unix to Linux A copy database ( *.ISD, *.ISM,*.frm) to Unix dosn't work. Also, t have seen that on linux the extention of the file are, not the same (*.MYD, *.MYI, *,frm). The version on unix is 3.22.23 and version on linux is 3.23.23-beta Help! Thank a lot - 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
MyFULLTEXT search
Hello, For the company I work for I have set up a MySQL database for a books website with more that 1 million records of books. The visitor can search for keywords. A sequential scan would be much too slow. (When I made the database, I had not yet heard of the new FULLTEXT index in MySQL.) To speed up searches I placed every word of every collumn in a seperate table called 'words'. table: words -- | WordNumber | Word | |- | .. | .. | | 200 | 'jack' | | 201 | 'road' | | .. | .. | -- I created another table called 'links' with references to the books table: table: links | WordNumber | BookNumber | |--- | .. | .. | | 201 | 258374 | | 675 | 578524 | | .. | .. | The 'books' table looks something like this: table: books - | BookNumber | Author | Title | ... | | .. | .. | ... | ... | 258374 | 'Kerouac, Jack' | 'On the Road' | ... | .. | .. | ... | ... - As records are added and deleted from the books table, I make sure the 'words' table and the 'links' table are updated. As an example, when the visitor searches for the keywords "jack kerouac road", then the following SQL statement is created: SELECT B.* FROM books AS B, words AS XL, links AS YL WHERE (XL.xWord LIKE 'jack%' OR XL.xWord LIKE 'kerouac%' OR XL.xWord LIKE 'road%') AND YL.WordNumber = XL.WordNumber AND YL.BookNumber = B.BookNumber; The website is getting incredibly busy and some searches are getting slow. Also, the links table is getting very big (more than 30 million records!). If it continues to grow like it does now, we will end up in problems in the near future. Could anyone give me advice on how to increase performance? Any help is much appreciated. Thanks! Tim Samshuijzen - 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
instlliion problems
Hi, While trying to install the latest mysql Binary distribution (mysql-3_23_32-pc-linux-gnu-i686_tar)to our Red Hat Linux 6.0 machine I have encountered the following problem. I would appreciate, if some can shade a light on it. When I tried to Create the MySQL grant tables shell scripts/mysql_install_db The "command not found " error was thrown. With kindly regards, *** Bruck Tadesse Computer Information Systems Assistant UNU WIDER Katajanokanlaituri 6 b FIN-00160 Helsinki Finland Tel +358 9 61599209 Fax +358 9 6159911 *** - 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
Update problem.
Hello! Need some help. I have two tables t1 with fields id and site t2 with fields id, from, to, koef I want to update t2 set koef=2 if the from field in t2 table exist in t1.url such update return error. update t2, t1 set t2.koef=0 where t2.from=t1.site Thank yoo very much. - 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: C problem
On Fri, Jan 26, 2001 at 02:28:37PM +0200, Evan James Dembskey wrote: It appears as if I have installed MySQL successfuly (under CLOS 1.2). CLOS ?? However, everytime I try to #include mysql.h OR #include "mysql.h" OR #include /usr/local/mysql/include/mysql.h ETC I get a "No such file or directory" error. Okay - so what library do I include then? It looks you're missing include files. What about checking the existence of the files, by: # locate mysql.h # ls -l /usr/local/mysql/include/mysql.h etc. Did you install just a precompiled version of MySQL? Sometimes there exist separate packages for developpers including the header files and libraries. -Remco -- Remco van den Berg Admin/SO/helpdesk DSE ICQ: 47514668 [EMAIL PROTECTED] http://www.dse.nl/ - 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
MyFULLTEXT search
Hello, For the company I work for I have set up a MySQL database for a books website with more that 1 million records of books. The visitor can search for keywords. A sequential scan would be much too slow. (When I made the database, I had not yet heard of the new FULLTEXT index in MySQL.) To speed up searches I placed every word of every collumn in a seperate table called 'words'. table: words -- | WordNumber | Word | |- | .. | .. | | 200 | 'jack' | | 201 | 'road' | | .. | .. | -- I created another table called 'links' with references to the books table: table: links | WordNumber | BookNumber | |--- | .. | .. | | 201 | 258374 | | 675 | 578524 | | .. | .. | The 'books' table looks something like this: table: books - | BookNumber | Author | Title | ... | | .. | .. | ... | ... | 258374 | 'Kerouac, Jack' | 'On the Road' | ... | .. | .. | ... | ... - As records are added and deleted from the books table, I make sure the 'words' table and the 'links' table are updated. As an example, when the visitor searches for the keywords "jack kerouac road", then the following SQL statement is created: SELECT B.* FROM books AS B, words AS XL, links AS YL WHERE (XL.xWord LIKE 'jack%' OR XL.xWord LIKE 'kerouac%' OR XL.xWord LIKE 'road%') AND YL.WordNumber = XL.WordNumber AND YL.BookNumber = B.BookNumber; The website is getting incredibly busy and some searches are getting slow. Also, the links table is getting very big (more than 30 million records!). If it continues to grow like it does now, we will end up in problems in the near future. Could anyone give me advice on how to increase performance? Any help is much appreciated. Thanks! Tim Samshuijzen - 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
SGI IRIX6.5 MYSQLGUI Bug
We are using all the recommended versions of software to get MySQLGUI compiled and running. When we try to login we get a bus error. After putting the software in the debugger, we found that the string conversion routine is causing the address of the string to be an "odd address". Has anyone had any experience in getting the GUI running on the SGI? Jennifer DeVilbiss SAIC - 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: Berkeley Tables under NT!
Mehalick, Richard RE SSI-GRAX writes:
I asked a week ago if BDB tables had ever been tested by the MySQL team on
RedHat 7. Any ideas?
-
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone: 281-544-5092(WCK)
/ Fax:281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-
It will work if you build it statically on some other Linux platform,
as RH 7 compiler is buggy.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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 web host
Do you know any free web hosting that supports MySQL. Please let me know. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. ** - 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
GNUe Forms 0.0.5 Released
GNUe Forms is a data entry/query tool that allows a designer to describe a data aware user interface via an XML based form definition language. This file is then parsed at client startup and a proper user interface is dynamically generated. Currently the client portion of the system is available, work on a screen painter still in the works. To make creating the forms easier (until the painter is ready) the package also includes a script that makes generating basic screens based upon tables quite fast. Some of the clients features include: Multi-platform capability: unix, linux, win32 Multi UI support: GUIs supported as GTK, Motif, Win32 (via wxPython), Curses based text support (still rough) Multi Datasource support: PostgeSQL, MySQL, GEAS, and ODBC (GEAS and ODBC still rough) 2-tier and N-tier capable: N-tier support via GNUe GEAS Client side Master/Detail relationships Client Side Triggers It has been successfully built on the following platforms Solaris Debian GNU/Linux RedHat Linux Win32 platforms (limited testing) It is part of the GNU Enterprise project (www.gnue.org) A GNU project which aims to develop a set of tools to build programs that together will form a complete system to provide functionality for most business needs. While the client is only at version 0.0.5 it has at earned our stamp of "usefullmaybe" :) You can find the python source code, rpms, and win32 version as well as some outdated screenshots at www.gnue.org Take Care James ([EMAIL PROTECTED]) -- James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561 Kansas State University Department of Mathematics -- - 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
Status of MySQL 4.0/Innobase engine/trx and row level locks
Hello! I promised to report to the mailing list how the interfacing of MySQL and Innobase engine progresses. Innobase will provide transactions, rollback, row level locking, and Oracle-style non-locking consistent read to MySQL. It currently runs on Intel Linux and NT. Following items from the TODO list from last week have been done: - 1. Optimize the MySQL/Innobase interface regarding to CPU time, and add support for small, less than 7.5 kB BLOBS. 6. Make the (implicit) select in UPDATE TABLE ... SET ... an x-locking read, not a consistent read. 7. Interface SELECT ... FOR UPDATE and SELECT ... IN SHARE MODE to Innobase, (MySQL parser in 4.0 already knows these syntactic constructs). - Following items remain: - 2. Test correct handling of all MySQL data types and the SQL NULL value. 3. Give appropriate information to the MySQL query optimizer about table sizes, and also to users about the file space occupied by each table, index, and other data structures. 4. Tell the MySQL query optimizer if a secondary index contains all the required columns: no need then to search the clustered index (in Innobase every table has a clustered index where the data is stored, this is similar to Sybase clustered indexes). 5. Add a timeout to lock waiting: Innobase can detect and resolve deadlocks within its own lock table, but if a user uses also MySQL LOCK TABLES... or BDB locks, a deadlock can occur where Innobase does not know of all the locks: this is resolved by adding a timeout for a lock wait, say 100 s., after which the transaction is rolled back. 8. Move the SQL NULL value as the first in the alphabetical order. 9. Prevent MySQL from using 'generate_table' in DELETE FROM ... . That is not good if we want a rollback. 10. Port to Solaris, HP-UX and all different Unix flavors. From the progress we can give an estimate that the interfacing is done 3 weeks from now. But a distribution version requires MySQL 4.0 source, and that may still be farther out. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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
you can tell
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [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: SGI IRIX6.5 MYSQLGUI Bug
Jennifer Devilbiss writes:
We are using all the recommended versions of software to get MySQLGUI
compiled and running. When we try to login we get a bus error. After
putting the software in the debugger, we found that the string
conversion routine is causing the address of the string to be an "odd
address". Has anyone had any experience in getting the GUI running on
the SGI?
Jennifer DeVilbiss
SAIC
Hi!
In order to build properly mysqlgui (and all required libs) you must
have a full installation of gcc 2.95.2 and it's STL library.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: Update problem.
petro writes:
Hello!
Need some help.
I have two tables
t1 with fields id and site
t2 with fields id, from, to, koef
I want to update t2 set koef=2 if the from field in t2 table exist in
t1.url
such update return error.
update t2, t1 set t2.koef=0 where t2.from=t1.site
Thank yoo very much.
Hi!
This kind of update is in the works on the 4.0 branch.
With 3.23, if you can program in C++, you may take a look at
updel_x.cc example in MySQL++ source distro.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump
Sam Wong writes:
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins, especially at night (high
traffic?) I've tried to enable/disable SMP, modify the memory setting in
my.cnf, concerrency thread setting etc. And apply the lastest snapshots and
make world. Binary, compile by myself with and without -O cflags, all these
give the same result - core dumps every 5-10 mins...
It's core dumps due to bus error (that's what it report...), not
segmentation fault.
I've also tried to change the RAM, mother board and harddisk, but still...
Hi!
Beside Jeremy's notable comment, please try latest FreeBSD binary
available on our site.
Also follow Ken Manzel's info on FreeBSD 4.* patches.
The fact that you have SMP kernel should not matter much, as FreeBSD
native threads can not use SMP for threaded servers.
If you still get problems with all above settings, you should try to
debug MySQL. Please follow the corresponding instructions in the
manual on the subject.
Most likely it is some bug in FreeBSD kernel.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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 and Actuate
Hi, I would like to know if Mysql can be used with Actuate Report writer. If yes what drivers will I need. Thank you, Anju Bagaria Total E Care Corp. 130 Campus Drive, Edison NJ 08837 Email:[EMAIL PROTECTED] Phone:732-225- x199 Fax: 732-417-0482 - 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: Browser-based client UI design question
One approach might be to use a hierarchal menu -- first level is first letter of the company, second level is all of the companies whose names begin with that letter. Or, set a search to pull up the list of companies which contain a certain phrase. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 10:17 I apologize for the OT question, but I've asked this on several other forums and gotten no constructive replies. If someone wants to refer me to a better place to ask this, I'd be grateful. I've got a complicated question, which probably has a simple answer, so I'll try to avoid wasting everyone's time as best as I can. I've read tons of stuff about relational database design - normalization, integrity, etc., but none of it is really relevant to my question. My question is this: When you're designing the user interface for a browser-based data entry system, what's the best way to accomodate linked records? There's loads of info out there on querying and reports, but everyone seems to ignore the fact that the data has to get into the database somehow, and often it's via online entry. For example: You have a table of Service Calls and a table of Companies. Each Service Call can be linked to one or two companies (trust me, there's a reason). You're using an Auto-Incremented Integer, call it 'comp_id', for a Primary Key for Companies. Now, when someone goes to enter a Service Call online, how do they establish the relationship to the correct Company or Companies? If you have two attributes in Service Calls, say 'comp1' and 'comp2', surely you don't expect the person entering the data to just happen to know the correct value of 'comp_id'? But you can't pop up a list of 1,000 'comp_id' and 'comp_name' combinations, either. What am I missing? (I have the feeling I'm going to feel stupid when I get the answer, so let's go ahead and get it over with...) Sorry for the long-winded question, and thanks in advance for any suggestions. - 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: secure web server to database server connection
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
It just occurred to me, however, that this becomes a much bigger
problem when the web server(s) and the database server are running
on different machines.
Only if they're on different networks. Ideally, you could put the web
server(s) and database server on different ports of a high-speed
switch.
This must assume some kind of hardware firewall, then (i.e. inside the
switch), else how would this provide any kind of security? All the
switches I currently use essentially just act as repeaters, so anyone
with a physical connection to the switch (i.e. the whole Internet, more or
less) can grab the packets passing between the 2 machines.
Simply putting one of the servers behind a firewall does nothing to
stop a packet sniffer.
This point I don't see at all. If your network is configured like this:
{Web Server Pool}
/
/
E1
Internet --- E2:Firewall
E3
\
\
Database Server
you simply create firewall rules which prevent any packets from passing
between interfaces E2 and E3 (i.e. any packets originating from E3 are
only allowed to pass through E1 to the web server pool.
What you really want is some sort of encrypted
network connection. I'd suggest using SSH to do it. I've run
replication across the country via an SSH tunnel before.
So this must be some sort of TCP wrapper? Where could I find some good
documentation on how to implement this?
-
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: Tru64 MySQL Compilation Problems
Julian Hiscock writes:
We are currently trying to compile MySQL V3.23.32 under Tru64 V5.0a running
on a Compaq Alphaserver DS20E. The error messages are as follows:
Object file format error in: /usr/local/mysql/lib/mysql:
read_pass1_info_malloc: bad file magic number
ld:
Object file format error in: /usr/local/mysql/lib/mysql: read_curr_obj_info:
File is not a regular file
make[2]: *** [mysql] Error 1
make[2]: Leaving directory 'julian/mysql/mysql-3.23.32/client'
make[1]: *** [all-recursive] Error 1
make[2]: Leaving directory 'julian/mysql/mysql-3.23.32'
make: *** [all-recursive] Error 2
This was using the cxx compiler. We'd like to use gcc but we can't get that
to compile either and we can't find a Tru64 binary version on the web.
If anyone can help with the compilation errors or knows where to get a gcc
binary for Tru64 V5.0a(other than the Compaq freeware CD's which our DS20
refuses to read) then please reply!
Cheers,
Julian
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Hi!
The above is some error with Compaq compiler. As this compiler
produces better code for Alpha then GNU, you should stick to it.
You should however consult Compaq on this issue.
And you should use GNU make, not Compaq's make.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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
Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
Hi. You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. I need to quicken DB to the maximum and to keep minimum size of the DB. Thanks. Nick. - 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
Not a lame question about index usage of MySQL
The manual says that if two seprate single-column indexes exist on two different colums (col1, col2) and someone issues a query: SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2 optimizer will choose the index which matches the least records and use it. This is it. Manual does not say what happens nexts. Assuming exactly what has been said abouve we have a terrible situation. For example if tbl_name has 100,000 records in col1 and for each of the values we have 100,000 values in col2. In this case MySQL would have too look through thousands of records to get the results if it does not apply another index after using the first one. So, my question is: Are things so bad? MySQL cannot apply more than one index per query per table? Regards, Artem - 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: 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump
Beside Jeremy's notable comment, please try latest FreeBSD binary available on our site. Also follow Ken Manzel's info on FreeBSD 4.* patches. The fact that you have SMP kernel should not matter much, as FreeBSD native threads can not use SMP for threaded servers. If you still get problems with all above settings, you should try to debug MySQL. Please follow the corresponding instructions in the manual on the subject. Most likely it is some bug in FreeBSD kernel. Could you point me in the direction where i coudl find that "Ken Manzel's info on FreeBSD 4.* patches." I am having the same problem with 3.23.32 on 4.2-stable (dies sporadically with sig 11). Regards, Artem - 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: Not a lame question about index usage of MySQL
In the last episode (Jan 26), Artem Koutchine said: The manual says that if two seprate single-column indexes exist on two different colums (col1, col2) and someone issues a query: SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2 optimizer will choose the index which matches the least records and use it. This is it. Manual does not say what happens nexts. Assuming exactly what has been said abouve we have a terrible situation. For example if tbl_name has 100,000 records in col1 and for each of the values we have 100,000 values in col2. In this case MySQL would have too look through thousands of records to get the results if it does not apply another index after using the first one. So, my question is: Are things so bad? MySQL cannot apply more than one index per query per table? Most database products only allow one B-tree index per table in a query. Using two indexes is a waste of disk I/O. Why look up the value in the second index when you can simply look it up directly in the table? The best solution is to create a compound index on (col1, col2). -- 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
need help
Hi, I am trying to install MySQL on my Sun workstation which has Solaris 2.6 installed. I have completed following steps 1. configure 2. make After step 2 when I am doing "make install" (step3) it is giving me following error: --- Warning: You do not have permissions to install into /auto/perl-hard/5.004_04/lib/site_perl/sparc-sun-solaris2.6 at /opt/perl/packages/5.004_04/lib/ExtUtils/Install.pm line 58. Cannot forceunlink /auto/perl-hard/5.004_04/lib/site_perl/sparc-sun-solaris2.6/./auto/DBI/DBIXS.h: Read-only file system at /opt/perl/packages/5.004_04/lib/File/Find.pm line 135 make[3]: *** [pure_site_install] Error 30 make[3]: Leaving directory `/users/swhamid/servers/mysql-3.21.33b/perl/DBI' make[2]: *** [install-dbi] Error 2 make[2]: Leaving directory `/users/swhamid/servers/mysql-3.21.33b/perl' make[1]: *** [install-exec] Error 2 make[1]: Leaving directory `/users/swhamid/servers/mysql-3.21.33b/perl' make: *** [install-recursive] Error 1 --- Is it possible to get rid of this error by installing the perl module locally. Can you please guide me how to do that. I do not have administrative rights on my workstation so the directory structure is going to be read-only. I appreciate if you could help at the earliest. Thanks Syed W. Hamid __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need help
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I get stuck sql_yacc.cc .. Any pointers? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 414-5359 - 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
Selecting * from 2 tables
Hello list, How would you go about selecting * from 2 tables? I have 2 tables: table_1 and table_2 In table_1 I have the following data. dog bird cat In table_2 I have: mouse rat hampster How do I show both tables contents like: +--+ |dog | |bird | |cat | |mouse | |rat | |hampster | +--+ I've tried the following but its not producing what I need. select * from table_1,table_2; select * from table_1 where ID IN (select ID from table_2); select * from table_1 UNION select * from table_2; Any help would be great Thanks for your help --Mike __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Selecting * from 2 tables
You can't do select * from table_1 UNION select * from table_2; 1st the structures of both queries have to be exactly the same. Second, you have to specify them in the select. select animalType from table_1 UNION select animalType from table_2; should work, assuming that you have a field named animalType in both tables and they are the same type and size. HTH, Cal http://www.calevans.com -Original Message- From: Mike Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 1:05 PM To: [EMAIL PROTECTED] Subject: Selecting * from 2 tables Hello list, How would you go about selecting * from 2 tables? I have 2 tables: table_1 and table_2 In table_1 I have the following data. dog bird cat In table_2 I have: mouse rat hampster How do I show both tables contents like: +--+ |dog | |bird | |cat | |mouse | |rat | |hampster | +--+ I've tried the following but its not producing what I need. select * from table_1,table_2; select * from table_1 where ID IN (select ID from table_2); select * from table_1 UNION select * from table_2; Any help would be great Thanks for your help --Mike __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: need help
What do you mean "get stuck". You some kind of error or just it does shows that it compiles it and makes you wait a lot. Well, if you look a bit above you will see that the following compile may take a long time and IT DOES TAKE A VERY LONG TIME ON SLOW MACHINES. So.. WAIT! If you got error, then say what error you've got. Good luck! - Original Message - From: "System Administrator a.k.a. The Root of the Problem" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 10:00 PM Subject: Re: need help Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I get stuck sql_yacc.cc .. Any pointers? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 414-5359 - 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: Selecting * from 2 tables
assuming that each table only has one element, you could do a select * from 2 table. If you don't and you need to combine everything, then you're trying to do a UNION. mySQL doesn't support UNION's yet. one way to do a union is to create a temporary table then use two queries to fill the temporary table. if you need the data on a more permenant basis, then you won't create a temporay table. the problem might be for the data to be constantly updated. you could schedule a cron job (UNIX) or write a script and schedule it with Task Scheduler (NT,2000) create table everything ( animalname varchar(25) ); insert into everything values (animalname) select animalname from table1; insert into everything values (animalname) select animalname from table2; -Original Message- From: Mike Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:05 AM To: [EMAIL PROTECTED] Subject: Selecting * from 2 tables Hello list, How would you go about selecting * from 2 tables? I have 2 tables: table_1 and table_2 In table_1 I have the following data. dog bird cat In table_2 I have: mouse rat hampster How do I show both tables contents like: +--+ |dog | |bird | |cat | |mouse | |rat | |hampster | +--+ I've tried the following but its not producing what I need. select * from table_1,table_2; select * from table_1 where ID IN (select ID from table_2); select * from table_1 UNION select * from table_2; Any help would be great Thanks for your help --Mike __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: If exists UPDATE else INSERT
Why not do an update regardless if the record exist or not, then insert it if you get an error? -Opprinnelig melding- Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sendt: 26. januar 2001 19:02 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: Re: If exists UPDATE else INSERT I've seen something about this in the manual. At the moment the problem was how to call such an SQL command (like REPLACE for DELETE/INSERT). I wonder if it was implemented in 3.23.32 or is it only in 4.x? - Original Message - From: "Jan Willamowius" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 7:34 PM Subject: If exists UPDATE else INSERT I'm have a lot of queries where i have to check if a record exists and if it does, increment a counter in it (most of the time). If it doesn't exist I insert a new record with counter=1 (this case is rare). Right now I do a select form Perl and then do one or the other. To speed things up I could always do an INSERT IGNORE and always an UPDATE. This would save one statement on the INSERT case, but that is rare anyway. I'd really like to do this in one (fast) statement, since this is a real time application with literally milions of UPDATEs that come in this way every day. Would it be possible to write a UDF to do this ? Cheers, Jan -- Jan Willamowius, [EMAIL PROTECTED], http://www.willamowius.de/ Caution: Penguin Inside ! - 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
Re: SV: If exists UPDATE else INSERT
Do it the other way around. If insert fails, do the update. Udate may fail, and before you insert, another tread could do the insert. Now your insert would fail, and your data would be lost. Pl Wester wrote: Why not do an update regardless if the record exist or not, then insert it if you get an error? -Opprinnelig melding- Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sendt: 26. januar 2001 19:02 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: Re: If exists UPDATE else INSERT I've seen something about this in the manual. At the moment the problem was how to call such an SQL command (like REPLACE for DELETE/INSERT). I wonder if it was implemented in 3.23.32 or is it only in 4.x? - Original Message - From: "Jan Willamowius" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 7:34 PM Subject: If exists UPDATE else INSERT I'm have a lot of queries where i have to check if a record exists and if it does, increment a counter in it (most of the time). If it doesn't exist I insert a new record with counter=1 (this case is rare). Right now I do a select form Perl and then do one or the other. To speed things up I could always do an INSERT IGNORE and always an UPDATE. This would save one statement on the INSERT case, but that is rare anyway. I'd really like to do this in one (fast) statement, since this is a real time application with literally milions of UPDATEs that come in this way every day. Would it be possible to write a UDF to do this ? Cheers, Jan -- - 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
COUNT question
Hi-- I'm running an art archive, and for the artist listing pages I have to come up with a query something like the following: select name,dirname,sortname,pictures.artistid,count(pictures.artistid) as imgnum,avg(rating) as rateavg,max(uploaded) as lastmod from artists,pictures,ratings where artists.id=pictures.artistid and artists.id=ratings.artistid group by sortname order by imgnum desc There are three tables involved: "artists", "pictures", and "ratings". "artists" has all unique entries (identified by "id"). "pictures" has thousands of entries with multiple entries per "artistid". "ratings" has multiple entries per "artistid". I have to count the entries in "pictures" per "artistid", and I have to average the entries in "ratings" per "artistid". The problem is that running the query as I have it above, the "imgnum" variable (count(pictures.artistid)) is coming back vastly higher than what I need, which is the number of pictures-- e.g. the number of entries in the "pictures" table with "artistid" matching the artist it's grouping by. I think the problem has something to do with the "where" spec; I guess I'm just not conceptualizing the problem properly. I need to get all this data in one fell swoop, or else my scripts will get much slower and more complex. Is there any way to get COUNT() to count only the rows within a grouping? Or am I going about this all the wrong way? Many thanks in advance for any insight! Brian Tiemann - 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: Doing multiple updates
Can somebody provide me with some sample code for the following. I read it
over in the manual but am still lost.
thanks
Randy
+++
Sounds like you want a mutex and you can use get_lock and release_lock in
mysql for that.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
GET_LOCK(str,timeout)
Tries to obtain a lock with a name given by the string str, with a timeout
of timeout seconds. Returns 1 if the lock was obtained successfully, 0 if
the attempt timed out, or NULL if an error occurred (such as running out of
memory or the thread was killed with mysqladmin kill). A lock is released
when you execute RELEASE_LOCK(), execute a new GET_LOCK(), or the thread
terminates. This function can be used to implement application locks or to
simulate record locks. It blocks requests by other clients for locks with
the same name; clients that agree on a given lock string name can use the
string to perform cooperative advisory locking:
mysql select GET_LOCK("lock1",10);
- 1
mysql select GET_LOCK("lock2",10);
- 1
mysql select RELEASE_LOCK("lock2");
- 1
mysql select RELEASE_LOCK("lock1");
- NULL
Note that the second RELEASE_LOCK() call returns NULL because the lock
"lock1" was automatically released by the second GET_LOCK() call.
RELEASE_LOCK(str)
Releases the lock named by the string str that was obtained with GET_LOCK().
Returns 1 if the lock was released, 0 if the lock wasn't locked by this
thread (in which case the lock is not released), and NULL if the named lock
didn't exist. The lock will not exist if it was never obtained by a call to
GET_LOCK() or if it already has been released.
Mark.
-Original Message-
From: Randy Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 8:48 PM
To: [EMAIL PROTECTED]
Subject: Doing multiple updates
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to implement this.
How do I make sure that a balance for a particular account is (locked) so
only 1 spend for that account can happen at one time?
for example my php script grabs the balance from the payer account and
receiver account. How do I make sure that the balance is locked so the
balance is read before the updated transaction occurs causing the person to
spend money that he/she doesn't have.
I hope I have provided enough explanation for you guys to point me in the
right direction.
thanks
randy
-
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: aborted connections?
As far as PHP is concerned, 4.0.4pl1 is not enough. You need to install CVS
version later than 2001-01-18. At least this is my experience.
Maciek
-Original Message-
From: tc lewis [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 8:47 PM
To: Maciek Uhlig
Cc: [EMAIL PROTECTED]
Subject: RE: aborted connections?
so we upgraded to 3.23.32 last night, but i'm still seeing a ton of:
010126 11:15:24 Aborted connection 30757 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
type errors in the error log.
i'm seeing these errors from both php connections and from perl dbi
connections. the versions involved are:
mysql-3.23.32
php-4.0.4pl1
DBI-1.14
Msql-Mysql-modules-1.2215
oh and perl is v5.6.0.
which i believe are the latest stable releases of each.
anything else i should be looking for?
-tcl.
On Tue, 23 Jan 2001, tc lewis wrote:
thanks for the reply. i found a followup on this problem from sasha
("Follow up on aborted connections bug in 3.23.31"), but wading through
the archive searching for the original thread hasn't ended up being
successful yet. anyone know offhand in which thread this was originally
discussed?
not all of these errors are coming from php connections. does php have
some related issue with this also?
-tcl.
ps- i like these informative changelog entries:
. "Fixed security bug in something (please upgrade if you are
using a earlier MySQL 3.23 version)."
. "Fixed buffer overflow bug when writing a certain error message."
On Tue, 23 Jan 2001, Maciek Uhlig wrote:
Read the archives. The detailed story can be found there. Use
newest MySQL
and newest PHP CVS. These errors will go away.
Maciek
-Original Message-
From: tc lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:56 AM
To: [EMAIL PROTECTED]
Subject: aborted connections?
we're seeing a lot of errors like these in our error log
files from mysql:
010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
i haven't investigated too too much about this yet, but i
was wondering
what common problems this error might be associated with. i'll keep
looking through the manual, but suggestions would of course
be wonderful.
the connections are over ethernet/tcp, and the eth
interfaces on the mysql
server are showing 0 errors after months of uptime, so i'm
guessing it's
not a tcp/ip issue, as the wording of that error might suggest.
-
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: how many colums can i create before it becomes unusable?
Hello Anna, According to the MySQL Crash-Me the maximum numbers for 3.23.xx are: - Columns in table 3398 - max table row length (without blobs) 65534 - table row length with nulls (without blobs) 65502 If you understand the concepts of DB normalization don't bother reading the following: 300+ columns seems like a lot of columns for member information. Are you sure you can't normalize your DB a little more by grouping or data into relevant tables? Example: table members: id | first | last | job_1 | job_2 | job_3 | job_4 | You could create another table called jobs and your resulting tables would look like: table members mem_id | first | last | table jobs job_id | mem_id | job | job_no | Regards, -Scott i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that for each user record, i am only storing integers, for the most part tinyints and smallints. Is there a limit on the number of fields per record. I can easily see this new system requiring 300 fields(columns). what are the consequences for making a table with so many columns. this table will be updated very frequently - will access time degrade severely even though i use mainly ints in this table? thanks for your help. anna - 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 to set the date format to dd/mm/yyyy for all tables in MySql for insertion, selection etc.,
Hello, I would like to change the default date format MySql from /mm/dd to dd/mm/. Does anyone know, how to make this change in MySql? Thanks. - 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: How to set the date format to dd/mm/yyyy for all tables in MySql for insertion, selection etc.,
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote: Hello, I would like to change the default date format MySql from /mm/dd to dd/mm/. Does anyone know, how to make this change in MySql? You can't. However, you can select DATE, DATETIME, or TIMESTAMP values using DATE_FORMAT() in whatever format you like. - 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
[Fwd: Re: COUNT question]
Update, which may be helpful: The number I'm getting back (which I said is vastly too high) is in fact the number of pictures multiplied by the number of ratings entries for that artist. I wanted to be able to get those two groupings separately. Is there a way I can do that (like with an explicit LEFT JOIN or some such), or do I have to do two separate queries? Brian Brian Tiemann wrote: Hi-- I'm running an art archive, and for the artist listing pages I have to come up with a query something like the following: select name,dirname,sortname,pictures.artistid,count(pictures.artistid) as imgnum,avg(rating) as rateavg,max(uploaded) as lastmod from artists,pictures,ratings where artists.id=pictures.artistid and artists.id=ratings.artistid group by sortname order by imgnum desc There are three tables involved: "artists", "pictures", and "ratings". "artists" has all unique entries (identified by "id"). "pictures" has thousands of entries with multiple entries per "artistid". "ratings" has multiple entries per "artistid". I have to count the entries in "pictures" per "artistid", and I have to average the entries in "ratings" per "artistid". The problem is that running the query as I have it above, the "imgnum" variable (count(pictures.artistid)) is coming back vastly higher than what I need, which is the number of pictures-- e.g. the number of entries in the "pictures" table with "artistid" matching the artist it's grouping by. I think the problem has something to do with the "where" spec; I guess I'm just not conceptualizing the problem properly. I need to get all this data in one fell swoop, or else my scripts will get much slower and more complex. Is there any way to get COUNT() to count only the rows within a grouping? Or am I going about this all the wrong way? Many thanks in advance for any insight! Brian Tiemann - 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: How to set the date format to dd/mm/yyyy for all tables in MySql for insertion, selection etc.,
Thank paul. I know about Date_format, but was curious if there is some setup parameters would allow us to define the MySql date format . Paul DuBois wrote: On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote: Hello, I would like to change the default date format MySql from /mm/dd to dd/mm/. Does anyone know, how to make this change in MySql? You can't. However, you can select DATE, DATETIME, or TIMESTAMP values using DATE_FORMAT() in whatever format you like. - 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
GRANT Privileges
I was just wondering what the "USAGE" privilege is good for and where it would be used? Pauls's book says that USAGE is a special "no privileges" privilege. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [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: Unable to like libmysqlclient statically
Add -lz to your linking options and all should go well. "Dave Juntgen" [EMAIL PROTECTED] wrote: Hello everyone.. I am trying to compile a CGI program written in C statically and I keep getting this one error. I am using MySQL version 3.23.31, the compiler error below shows that it is libmysqlclient.a that is having problems. Can anyone help? -Lgd -lgd -lcrypt -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib/mysql -lmysqlclient /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x99): undefined reference to `uncompress' - 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: Unable to like libmysqlclient statically
Hi, Check that you have zlib installed and then just add -lz to the libraries you will be linking with. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Dave Juntgen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 3:18 PM Subject: Unable to like libmysqlclient statically Hello everyone.. I am trying to compile a CGI program written in C statically and I keep getting this one error. I am using MySQL version 3.23.31, the compiler error below shows that it is libmysqlclient.a that is having problems. Can anyone help? -Lgd -lgd -lcrypt -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib/my sql -lmysqlclient /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x99): undefined reference to `uncompress' /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x128): undefined reference to `compress' collect2: ld returned 1 exit status make[1]: *** [webchart.cgi] Error 1 make[1]: Leaving directory `/usr/local/prj/working/djuntgen/webchart_dev' make: *** [all] Error 2 Thanks for your help.. --Dave J. --- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 - 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: Large Table Problem
Hi. You posted to the wrong list. This list is for developing of MySQL itself. As for your problem, MySQL does not have a good solution at this point. Have you tried using the BACKUP command? It will flush and lock the table and copy only the data and .frm files. A RESTORE will rebuild the index. This, I think, will be faster. Otherwise, do you have an updatelog and a backup? And depending on your application, there are other things you can do. Is there a timestamp or autoincrement field? Are there only inserts going on? You could copy smaller sets of the table until done for example. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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
Was FULLTEXT bug fixed?
Hi, There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in 3.23.32? Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: Selecting * from 2 tables
You can create a "MERGE TABLE" (read all about it in the manual)... CREATE MERGE TABLE everything ( animalname varchar(25)) TYPE=MERGE UNION=(table_1,table_2); Thereafter, you can select * from everything; Cheers, Kent Hoover - 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
ftp driver for mysql,
I am a customer to a web designer that I have since cut relations with.He left me high and dry and I am left to my own devices to ftp my web site to another hosting co. Is there a driver exclusively for ftp work that you can sell me; with step by step instructions of how to use it. or is there an alternative thing that you can do to help me with my delima.Needless to say every one uses the html coding and I cannot find good help. also I do not think I should hve to redesign or recode my site. You can see the mysql program that was used as a data base if you try to punch up ladykight.com lost in california USA - 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: Getting totals from database
http://www.mysql.com/doc/M/a/Mathematical_functions.html Please please please read manual before asking questions. SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser' GROUP BY user - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 26, 2001 3:00 PM Subject: Getting totals from database I know this is probably a simple thing, but what I would like to be able to do, is to query a specific account name for minutes each day and then have those minutes ADDED up to show the current total time online. My database has all of the info in the table, all I want to do is be able to query for a specific user and show total time for the month to date. Any help appreciated! Please reply via separate email.. == Phillip Ferraro WorldNet Access, Inc [EMAIL PROTECTED] Onslow County's PREMIER InterNet Service Voice (910) 346-0835 824 Gumbranch Square, Suite Q FAX (910) 455-1933 Jacksonville, Nc 28540-6269 == - 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
Loss of connection to MySQL Server
Greetings all, I have installed PHP 4.0.2 and MySQL 3.22.32 and Apache 1.3.12 on a Sun Sparc 20 running Solaris 2.6. I can now connect just fine using the mysql client and can run queries, etc. However, when I try to do the normal connection transaction using PHP Scripts, I get an error that says "MySQL Said: Lost connection to the Server During Query". The server just says that it aborted every connection attempt. The really weird part is that if I refresh the browser a bunch of times in a row, I get the phpMyAdmin index page to come up. But not in any realiable way. Does anyone know a reason for this very sporadic service? There have also been some security scripts run on this computerand I kinda feel that they are to blame, because I have been able to get MySQL to answer up on a stock 2.6 system. Thanks so much for your attention, Bill Whitaker [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
Error 2002: can't connect to mysql.sock
I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep getting error 2002: can't connect. I have looked at every piece of documentation, and can't find the solution. The mysql.sock file exists, but it still can't connect. I have used the rpm of version 3.23.32 to install everything. Thanks, Mike - 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: Error 2002: can't connect to mysql.sock
Redhat is funny. I have 7 and had tried everything in the books to get mysql back up and running after a shutdown. Fortunately, I had an experienced programmer who had helped me set it up. I queried him and set back this command: /etc/rc.d/init.d/mysqld restart That did the trick. It seems v.7 comes with all the packages I either had installed, or tried to install on 6.2, and everything else boots with Apache, but they left off mysql. Go figure. Apache also does not respond to the typical shutdown and restart commands given in the Apache manuals. Redhat has it set up to respond to their own commands. On 26 Jan 2001, at 19:10, Mike Tuller wrote: I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep getting error 2002: can't connect. I have looked at every piece of documentation, and can't find the solution. The mysql.sock file exists, but it still can't connect. I have used the rpm of version 3.23.32 to install everything. Thanks, Mike - 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 John Jensen Jensen's Directories www.college-without-classes.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: Error 2002: can't connect to mysql.sock
I've heard that redhat 7 is not that good. They implant many beta version code inside. Sam - Original Message - From: "Mike Tuller" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 27, 2001 9:10 AM Subject: Error 2002: can't connect to mysql.sock I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep getting error 2002: can't connect. I have looked at every piece of documentation, and can't find the solution. The mysql.sock file exists, but it still can't connect. I have used the rpm of version 3.23.32 to install everything. Thanks, Mike - 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
Can't start as user 'mysql'
I'm running Slackware Linux (2.0.36) and just set up a binary version of MySQL 3.23.32. I followed the directions exactly and all looks to be fine. However, when I try and start MySQL by using typing bin/safe_mysqld --user=mysql I get the following error: www:/usr/local/mysql# Starting mysqld daemon with databases from /usr/local/mysq l-3.23.32-pc-linux-gnu-i686/data 010126 18:54:14 mysqld ended I then check the error log and it reports this: 010126 18:54:14 mysqld started 010126 18:54:14 Warning: setrlimit couldn't increase number of open files to more than 256 010126 18:54:14 Warning: Changed limits: max_connections: 100 table_cache: 73 Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 010126 18:54:14 Aborting 010126 18:54:14 mysqld ended I know the user 'mysql' exists for sure and all directories and files are owned by 'mysql' and have the group ownership of 'mysql' but things still don't work. The other erros about not being able to increase the number of open files to more than 256 and the other warning about the 'Changed Limits' I don't know anything about. Could they be causeing a problem. I can successfully get MySQL to start if I don't start it as user 'mysql' but then I can't quit it using any quit command. I first tried using: mysqladmin stop and it reported the 'slave was not running' and couldn't quit mysqld I then tried 'mysql.server stop' and it gave me this: ./mysql.server st op ./mysql.server: @HOSTNAME@: command not found ./mysql.server: my_print_defaults: command not found Killing mysqld with pid 15998 ./mysql.server: kill: (15998) - No such pid Wait for mysqld to exit\c .\c .\c .\c gave up waiting! and it never quit. I have to do a force quit for each process with a kill -9. Any help here would be greatly appreciated. Thanks, John __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update question
For example, I have a table value position 3001 1002 5003 2004 I have to update position ordered by value, and table must look like this value position 3003 1001 5004 2002 Is it possible to make such update in single query?
Re: Error 2002: can't connect to mysql.sock
You are right that RedHat is funny. 7 really seems weird. I tried for two days to get everything going, (still am) and ran into all kinds of errors with Mysql. I tried different versions, and had different problems on each. I finally ran up2date to get everything update, and thought that would do the trick. Not so. I know, just configure it yourself, and don't use the rpms, but it is so much better to maintain if you can use the rpms. At least for me. I don't get lost trying to find where things are installed. Back to the problem. I have tried doing what you said before, and tried it again just now. Here is what I get. [root@cypher mtuller]# /etc/rc.d/init.d/mysqld restart Stopping MySQL: [FAILED] Starting MySQL: [ OK ] All looks good!!.. Now I enter this. [root@cypher mtuller]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (111) I check to see mysql.sock is missing. [root@cypher mtuller]# locate mysql.sock /var/lib/mysql/mysql.sock I've ran mysql_install_db, I've flushed the databases, reinstalled, updated, prayed to the server gods, and still I get the same thing. I know mysql will work, because I had Supportwizard's version of Mysql running earlier, but wanted to switch to a generic version so that I could use it for other things. GRRR! What next? Any ideas? From: "John Jensen" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 26 Jan 2001 17:29:10 -0800 To: [EMAIL PROTECTED] Subject: Re: Error 2002: can't connect to mysql.sock Redhat is funny. I have 7 and had tried everything in the books to get mysql back up and running after a shutdown. Fortunately, I had an experienced programmer who had helped me set it up. I queried him and set back this command: /etc/rc.d/init.d/mysqld restart That did the trick. It seems v.7 comes with all the packages I either had installed, or tried to install on 6.2, and everything else boots with Apache, but they left off mysql. Go figure. Apache also does not respond to the typical shutdown and restart commands given in the Apache manuals. Redhat has it set up to respond to their own commands. On 26 Jan 2001, at 19:10, Mike Tuller wrote: I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep getting error 2002: can't connect. I have looked at every piece of documentation, and can't find the solution. The mysql.sock file exists, but it still can't connect. I have used the rpm of version 3.23.32 to install everything. Thanks, Mike - 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 John Jensen Jensen's Directories www.college-without-classes.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
using libmysqlclient
I'm trying to use libmysqlclient as described in the manual to compile another program in SCO Open Server Release 5.0.5, whe i tri to do gcc -O2 -g -o mysql1 mysql.c -L/usr/local/mysql/lib -lmysqlcl ient -lnsl i get this messages can someone help me. Undefined first referenced symbol in file main /usr/ccs/lib/crt1.o pthread_cond_destroy /usr/local/mysql/lib/libmysqlclient.a(my _thr_init.o) htons /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) pthread_mutex_lock /usr/local/mysql/lib/libmysqlclient.a(my _open.o) pthread_getspecific /usr/local/mysql/lib/libmysqlclient.a(my _pthread.o) pthread_setspecific /usr/local/mysql/lib/libmysqlclient.a(my _thr_init.o) socket /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) pthread_mutex_destroy /usr/local/mysql/lib/libmysqlclient.a(my _init.o) connect /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) gethostbyname /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) getservbyname /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) setsockopt /usr/local/mysql/lib/libmysqlclient.a(vi olite.o) inet_ntoa /usr/local/mysql/lib/libmysqlclient.a(my _net.o) pthread_cond_init /usr/local/mysql/lib/libmysqlclient.a(my _thr_init.o) ntohs /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) floor /usr/local/mysql/lib/libmysqlclient.a(pa ssword.o) shutdown /usr/local/mysql/lib/libmysqlclient.a(vi olite.o) getsockopt /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) pthread_mutex_unlock /usr/local/mysql/lib/libmysqlclient.a(my _open.o) pthread_init /usr/local/mysql/lib/libmysqlclient.a(my _init.o) pthread_mutex_init /usr/local/mysql/lib/libmysqlclient.a(my _open.o) getpeername /usr/local/mysql/lib/libmysqlclient.a(vi olite.o) pthread_key_create /usr/local/mysql/lib/libmysqlclient.a(my _thr_init.o) inet_addr /usr/local/mysql/lib/libmysqlclient.a(li bmysql.o) mysql1: fatal error: Symbol referencing errors. No output written to mysql1 collect2: ld returned 1 exit status - 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: using libmysqlclient
On Sat, 27 Jan 2001, Marcelo wrote: I'm trying to use libmysqlclient as described in the manual to compile another program in SCO Open Server Release 5.0.5, whe i tri to do gcc -O2 -g -o mysql1 mysql.c -L/usr/local/mysql/lib -lmysqlcl ient -lnsl i get this messages can someone help me. ... You are missing some libraries -lgthreads -lz -lcrypt -lsocket -lm -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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
AW: Strange behavior of MySQL 3.23.xx with GROUP BY ...
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that a column that is displayed and has no grouping function applied to it MUST also appear in the GROUP BY-clause!!! The result: fldNAME fldMONAT sum(fldSALARY) boris 1 10200 stephan 1 6000 itself makes no sense ... none earned as much money in January (1) ... ! Postgres gives an error, Oracle gives an error, SQL-Server 7 gives an error even M$-Access 2000 gives an error why doesn't MySQL? Literature: http://www.newi.ac.uk/walshea/db1/sql04/index.htm there: http://www.newi.ac.uk/walshea/db1/sql04/sld015.htm http://www.nku.edu/~raghavan/gby.html http://info-it.umsystem.edu/oracle/svslr/svslr.2.1089.html http://www.sk.postgresql.org/docs/user/sql-select.htm and so on ... I think ANSI-Specs should even tell you the same ... ! -Ursprungliche Nachricht- Von: Bob Hall [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 26. Januar 2001 12:18 An: [EMAIL PROTECTED] Betreff: Re: Strange behavior of MySQL 3.23.xx with GROUP BY ... I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ... I have a Table: CREATE TABLE groupbyTEST ( fldNAME varchar(20) NOT NULL, fldMONTH tinyint(4) DEFAULT '0' NOT NULL, fldSALARY decimal(10,0) DEFAULT '0' NOT NULL, fldDATE datetime DEFAULT '-00-00 00:00:00' NOT NULL, PRIMARY KEY (fldNAME, fldMONTH) ); with following records: INSERT INTO groupbyTEST VALUES ( 'stephan', '1', '1000', '2001-01-25 23:12:29'); INSERT INTO groupbyTEST VALUES ( 'boris', '1', '2000', '2001-01-25 23:12:45'); INSERT INTO groupbyTEST VALUES ( 'stephan', '2', '1200', '2001-01-25 23:12:56'); INSERT INTO groupbyTEST VALUES ( 'stephan', '3', '1000', '2001-01-25 23:13:08'); INSERT INTO groupbyTEST VALUES ( 'stephan', '4', '900', '2001-01-25 23:14:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '2', '1200', '2001-01-25 23:15:01'); INSERT INTO groupbyTEST VALUES ( 'stephan', '5', '1900', '2001-01-25 23:15:16'); INSERT INTO groupbyTEST VALUES ( 'boris', '3', '2400', '2001-01-25 23:15:39'); INSERT INTO groupbyTEST VALUES ( 'boris', '4', '2100', '2001-01-25 23:15:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '5', '2300', '2001-01-25 23:16:01'); INSERT INTO groupbyTEST VALUES ( 'boris', '6', '200', '2001-01-25 23:16:11'); A statement like: SELECT fldNAME, fldMONTH, sum(fldSALARY) FROM groupbyTEST GROUP BY fldNAME HAVING sum(fldSALARY)200 should cause an error because of the missing fldMONTH in the GROUP BY clause, but it is executed without an error and results: fldNAME fldMONAT sum(fldGEHALT) boris 1 10200 stephan 1 6000 ... makes not very much sense ... does it?? Sir, why do you think it should cause an error? The statement is valid and the result is correct. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: secure web server to database server connection
On Fri, Jan 26, 2001 at 10:39:46AM -0600, Patrick Goetz wrote:
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
It just occurred to me, however, that this becomes a much bigger
problem when the web server(s) and the database server are running
on different machines.
Only if they're on different networks. Ideally, you could put the web
server(s) and database server on different ports of a high-speed
switch.
This must assume some kind of hardware firewall, then (i.e. inside
the switch), else how would this provide any kind of security? All
the switches I currently use essentially just act as repeaters, so
anyone with a physical connection to the switch (i.e. the whole
Internet, more or less) can grab the packets passing between the 2
machines.
The difference between a hub in and a switch is that the hub will
allow any port to see the data transmitted by any other port. A
network switch will not do that. It's true circuit switching, just
like a telephone switch. Thus the name "switch".
Simply putting one of the servers behind a firewall does nothing to
stop a packet sniffer.
This point I don't see at all. If your network is configured like
this:
{Web Server Pool}
/
/
E1
Internet --- E2:Firewall
E3
\
\
Database Server
you simply create firewall rules which prevent any packets from passing
between interfaces E2 and E3 (i.e. any packets originating from E3 are
only allowed to pass through E1 to the web server pool.
You misread (or misunderstood) what I wrote. I said "simply putting
ONE of the servers..." But your diagram shows ALL of the servers
behind a firewall. Of course that makes sense. But your original note
said " is this usually handled by simply putting the database server
behind a firewall?" That implied that the database server would be
behind the firewall but the web servers would not be.
What you really want is some sort of encrypted network
connection. I'd suggest using SSH to do it. I've run replication
across the country via an SSH tunnel before.
So this must be some sort of TCP wrapper? Where could I find some
good documentation on how to implement this?
SSH (Secure Shell) is a telnet/rsh replacement that provides
encryption and the ability to forward arbitrary TCP ports from one
machine to another over an encrypted connection.
To find info:
http://www.google.com/search?q=ssh
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951
-
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: Text Max
Firstly, text is a reserved word in mysql. Secondly, varchars or chars can only have 255 characters. You should use a text type column which can be very large (megabytes!). You have read the manual on the different field types? Clearly, he *did* read up on the field types in the manual and found that a text field can hold 64k characters. He just didn't realize that you don't set a length specifier on the text field. [EMAIL PROTECTED] wrote: Hi, I`m setting up a field in my DB called Description and basically want it to have a max character length of 1000, my MySQL manual tells me varchar is limited to 255 so thats out of the window then it goes on to say text has a max of 64 kb of text and defines all the others in this way. I did try entering as follows Description text(1000) but it isn`t accepting it should I be using something else?? Try without the length specification (i.e. drop '(1000)'). / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Newbie: difference between tinytext and varchar
I am trying to determine when it is best to use varchar and when it is appropriate to use tinytext. I have looked at the manual and have read the difference between them but would like to have an understanding of this in more practical, real-life terms. Is a space between characters considered a character in both column types or does one handle it differently? Yes, it's a character in both; However: a varchar will strip trailing spaces in a string whereas a text field will keep it. When I use a varchar I have to define its maximum length. I don't have to declare max length in tinytext. does this make a difference when it comes to storage space? The difference between a varchar and a tinytext is that a varchar is stored directly in the table data, whereas the tinytext is stored outside the table. Tinytext fields can only be indexed in MyISAM tables. Also, you cannot specify a default value for a tinytext. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
