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

[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

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

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

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

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

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

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

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

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 |

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

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.

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

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

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

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