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 MyISA

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 __

[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

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 na

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 na

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 usi

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 u

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 fr

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 fr

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 sel

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 sel

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 recor

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 ___

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

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

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 thoug

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 ta

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 reve