use ' not`
learn the syntax rules

ahhhhhhhh … thanks archivist …
you are an O:-)

can I somewhow use the call result (a select) from a stored procedure in another procedure?
with a cursor or loop or so?

hey, i wanna upgrade from mysql 3.23.x to mysql 5
apart from backing up all the databases. is there anything else i should do before the upgrade
apart from pray

the datetime format has changed beware of that
timestamps are different

bizzeh, see upgrading docs for issues
joins change a bit

time functions are fine, but if you convert outside php mysql web hosting unixtimestamps back and forth there will be trouble

and passwords are different

they all get purged

i always select UNIX_TIMESTAMP(field) anyway

mysqldump

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

omg why?

because mysql3 timestamps are not unix timestamps
and php cant strtotime mysql3's times

what is preferred? second or third? select now(), now() - interval 1 day, date_sub(now(), interval 1 day);
maybe i should ask, which one is (more) portable?

Hi all!

Hi one!

ping

who me

Yes you!

i reckon you'd know the answer to my simple question

How can you create databases with specific default character sets from within a script?

dunno

oh

mysqladmin -u root -p create foobar_blah default character set utf-8 collate utf8_general_ci doesnt work

use a real sql host statement instead of mysqladmin? mysql -u root create_foobar_blah.sql

ah okay, cool thanks

hello
how can i search for all records in a week ?

date_sub(now(), INTERVAL 7 DAY)

someting like that

bye all!

ok, thanks

well sorry for being a pain in the ass,
but it got mysql to work in chroot
i just needed to chown a bunch of folders
and add some libs here and there

hey guys. Is there anyway to speed up group bys for a left join when what your grouping by is on the left part of the join?

Voltaire, use explain check index usage

hmm. good point.
ta

is it possible to alter table add column XXX ONLY if column doesnt exist?

is there a verbose way to use mysqldump, to see for example how much it's dumping so far ?

hey guys do i need to create a hard link between mysql and mysqld
if i chrooted mysql

bye bye

why would you create a hard link between mysql and mysqld?

SELECT * FROM table ORDER BY MAX(field) LIMIT 1

Danielss89, no SELECT * FROM table ORDER BY field desc LIMIT 1
Danielss89, you need an index on the field for maximum speed

yes archivist

anyone any Ideas why this SQL wont run
http://rafb.net/p/8FNieU49.html
mysql says #1064 - You have an error in your sql syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '——————————————
  `1_desc` text NOT NULL,
  `1_head' at line 24

Take a look just before the quoted text
that —————— looks suspicious
heh
And learn about database normalization please!

eh

You have combined 20 different tables into a single one

what do you mean database host normalization, we need details

what do i need to import a access db

I dont need 20 different tables
religion

normalization

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://datamodel.org/NormalizationRules.html and http://mysqldump.azundris.com/archives/20-Nermalisation.html and some here http://www.keithjbrown.co.uk/vworks/mysql/

I would suggest one of the more outlandish cults, perhaps one with live human sacrafice

religion ?

Religion is not defined in RDBMS theory nor in SQL standard

sorry, I realld dont like access, I was being sarcastic

what do you guys have about like and no like. As iam porting access to mysql its clear iam not liking it too..but its a job.

Relational databases are optimized for tables with few columns and millions of rows. Just adding one more column will make it possible to cut your table to 40 columns, but even that is too much for such structure
It's like saying your religion says you must only drive your car backwards. Possible, but not very efficient

xored, you guys!!! sorry man. I know jack anyhow

Importing tables is doable, but I hope you don't expect MySQL to import anything else like forms and reports

why should it import forms ?
they are based on the data..they stay in the access-app

For single table the fastest way would be to export to tab delimited (or any other delimiter) text file and then LOAD DATA in MySQL
Or you can connect directly from Access to MySQL with Connector/ODBC
Or you can use Migration Toolkit

ok odbc driver. do i have to install it on debian etch for mysql hosting ?

I wish the Migration Toolkit did not rely on java

http://www.mysql.com/products/tools/migration-toolkit/
No. You install it on windows box where the Access resides

ah !
so its nothing server sided, its client sided
Where do i get the ODBC driver ?

Indeed

is the migration-toolkit free ?

dev.mysql.com/downloads

Free as a bird

thank you :9

hello salle

Hello here

but then you need the java jre download fails for the last few days for me

get a new isp!

i get the server but no download
ist odd
its
sun was part of that colo failure last week

what failure?

just re trying on other box