blob size
>From manual: LONGBLOB A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters If I insert a 400k file into a longblob, will it occupy 400k in actual space on the harddrive, or will it occupy the maximum for a longblob? Is there any difference here between innoDB an MyISAM? I read that MyISAM only can handle blobs up to 16 mb... Any thoughts? // Michelle SQL, Query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Smallest install of mySQL
This question might be a little OT. My question is, what is the smallest working install of mySQL? Can you install it in a PDA, like the Yopy, that uses linux as OS? http://www.yopy.com/english/products/specification.htm // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
[OT] Smallest install of mySQL?
This question might be a little OT. My question is, what is the smallest working install of mySQL? Can you install it in a PDA, like the Yopy, that uses linux as OS? http://www.yopy.com/english/products/specification.htm // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Unicode
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? 2) Will these querys work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE name='name using russian alphabet' 3) Is it going to affect anything regarding performance etc? 4) I read some of the things on unicode.org, but this is only the pros. Is there any cons for using unicode? When should I use it? Any thoughts? // Michelle < sql, query > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Unicode
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? 2) Will these querys work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE name='name using russian alphabet' 3) Is it going to affect anything regarding performance etc? 4) I read some of the things on unicode.org, but this is only the pros. Is there any cons for using unicode? When should I use it? Any thoughts? // Michelle < sql, query > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Unicode
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? Will this work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE name='name using russian alphabet' 2) Is it going to affect anything regarding performance etc? 3) I read some of the things on unicode.org, but this is only the pros. Is there any cons for using unicode? When should I use it? Any thoughts? // Michelle < sql, query > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
How indexes work?
I have some questions on how an index is built and used. I have a very simple table like this: char_col char(10) not null Index (char_col) If I have 1000 records in this table, how big will the index become? The data-size would be 10 000 right? How does an index look like and how can it speed up searches? >From what I can think, the index on the rows in the table above would look like this: name address name phone There must be something more, like a pointer of some sort and a more efficient way of storing the indexed stuff. Any thoughts? // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: Select Where !=
> So... > Select n.uid, n.name from names_table n > LEFT JOIN exclude ON n.uid = exclude.n_uid > WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, "cat_id". This shows which catalogue the names have been excluded from. I want to do the operation above, but limit it to only the current catalogue, namely 16. I tried: Select n.uid, n.name from names_table n, exclude e1 LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL AND e1.catid=16; I also tried putting some left joins in aswell, but I didn't get them to work. Am I mixing too much into the same query? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: Select Where !=
> So... > Select n.uid, n.name from names_table n > LEFT JOIN exclude ON n.uid = exclude.n_uid > WHERE exclude.n_uid IS NULL; OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, "cat_id". This shows which catalogue the names have been excluded from. I want to do the operation above, but limit it to only the current catalogue, namely 16. I tried: Select n.uid, n.name from names_table n, exclude e1 LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL AND e1.catid=16; I also tried putting some left joins in aswell, but I didn't get them to work. Am I mixing too much into the same query? // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Select Where !=
I have two tables. One with names and one for excluding certain names. Exclude-table contains the uid for the name excluded. If I want to see which names has been excluded, this query does the job: Select n.uid, n.name from names_tables n, exclude WHERE n.uid = exclude.n_uid But if I want to select all names, but leave out the ones that are in the "exclude"-table, I thought this would do it, but no. Select n.uid, n.name from names_tables n, exclude WHERE n.uid != exclude.n_uid It has something to do with the != thingy... Any thoughts? // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Select Where !=
I have two tables. One with names and one for excluding certain names. Exclude-table contains the uid for the name excluded. If I want to see which names has been excluded, this query does the job: Select n.uid, n.name from names_tables n, exclude WHERE n.uid = exclude.n_uid But if I want to select all names, but leave out the ones that are in the "exclude"-table, I thought this would do it, but no. Select n.uid, n.name from names_tables n, exclude WHERE n.uid != exclude.n_uid It has something to do with the != thingy... Any thoughts? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: Limit and Order by
> you mean mySQL does the search on 100 first entries > and then order the > results, instead of getting the results and > returning only the first 100 ? > If yes I too would like to know what's the right way > to do it in SQL then ? That is correct. This is what I have: One table with 1000 records. Two columns, students names (name) and the total score of a test (total) When I try this query, I sort by the highest total: Select * from mytable ORDER by total desc When on the other hand I use this query, mySQL only takes the first hundred rows and sorts them: Select * from mytable ORDER by total desc limit 0, 100 The problem is that there can be a very high score at row 234, that should be in the top one hundred result, but this is left out. So the question is, can I limit the result and get all the highest scores from my table with a query, or do I have to add a counter in my PHP-script that breaks out of the loop at 100? Thanks, // Michelle sql, query > > -Message d'origine- > > How can I limit the result after the "order by" > has > > been executed? This stops efter 100 rows and the > > result is not as I intended... > > > > Select * from mytable ORDER by total desc limit 0, > 100 > > > > Must this be done in PHP? > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Limit and Order by
How can I limit the result after the "order by" has been executed? This stops efter 100 rows and the result is not as I intended... Select * from mytable ORDER by total desc limit 0, 100 Must this be done in PHP? Thanks for all replys to my topics, btw. Any thoughts? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Join-question
I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1 | 2| name3| | 4 | 1 | 3| name4| | 5 | 1 | 2| name5| ... How do I get this (WHERE uid=5): -- | rootid_name | parentid_name | name | -- | name1 | name2 | name5| -- If you need more info, please tell me. Any thoughts? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Select and count duplicates
I have a column containing headlines. In this column there are some duplicates, like this: --- monsters headline1 monsters halloween monsters halloween ... -- How can I get a result like this instead? HEADLINE | HITS --- monsters | 3 halloween | 2 headline1 | 1 --- Any thoughts? // Michelle __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Character-sets
If I want to create a database with an arabic character-set, will only the data-cells be affected by this or will the table names, column names etc also be in arabic? Can I mix two character-sets (English and Arabic) in the same database, or does it have to be in two separate databases? Any thoughs? // Michelle (sql, query) __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
Distributing table-files to other machines
At the moment, the files for tables in a database are all stored in mysql/data/databasename/. Is it possible to distribute the table-files to different discs, or even better, different machines, and still keep the flexability of having everything in one database. Example 1: Prefs: 1 Database 5 tables 5 discs Explanation: Put the first table on the same DISC as the database. The other tables have one DISC each. Example 2: Prefs: 1 database 5 tables 5 servers Explanation: Put the first table on the same SERVER as the database. The other tables have one SERVER each. Any thoughts? // Michelle __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
Table-sizes, number of tables etc
I am trying a "worst-case-scenario" of my databse. I have, so far, come up with some numbers to do the calculations with and perhaps a way of splitting one big table into smaller, yet structured, tables. (These questions are not limited by hardware, because if the need for speed is there, the revenues are too.) The numbers are: Thought-up number entries in one table: 100 000 000 000 (100 billion) Number of tables: 10 000 (I could perhaps limit the number of entries to a maximum of 9 000 000, but I need to have a hell of a lot of tables.) So here are the questions regarding MySQL: 1) How many tables can one database have? (The absolute maximum) 2) How many entries can one single table have? (The absolute maximum) Any thoughts? // Michelle __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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