| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> Ah resources its simply ****s here
<1> that's always the problem
<0> infi, I need a link
<1> for what?
<0> the wtf gives me wrong link
<0> for running two instance of mysql on the same machine
<2> how do i count the number of rows of a table?
<3> select count(*) from table;
<2> thanks
<1> Wulf4, ahahaha
<1> nice PDF
<4> hello all, I have a problem with concat_ws and dates
<4> mysql> select concat_ws(' ','My Master',now()) regexp '[[:<:]]master[[:>:]]' ;
<4> +-----------------------------------------------------------------+
<4> | concat_ws(' ','My Master',now()) regexp '[[:<:]]master[[:>:]]' |
<4> +-----------------------------------------------------------------+
<4> | 0 |
<4> +-----------------------------------------------------------------+
<4> 1 row in set (0.00 sec)
<4> but
<1> ccosta, use a pastebin
<4> mysql> select 'My Master 2006-02-07 11:47:56' regexp '[[:<:]]master[[:>:]]' ;
<4> +----------------------------------------------------------------+
<4> | 'My Master 2006-02-07 11:47:56' regexp '[[:<:]]master[[:>:]]' |
<4> +----------------------------------------------------------------+
<4> | 1 |
<4> +----------------------------------------------------------------+
<1> or don't...
<4> pastebin?
<1> see topic
<0> infi, google not very helpful today :)
<4> I've put here my -problematic- queries: http://hashmysql.org/1421
<1> kokoko1, really, just do what Wulf4 said
<5> is there any additional optimisation in indexing enum() than tinyint() given that there are only a certain range of values allowed?
<6> ccosta: my understanding is that concat_ws returns a binary string and comparison is made taking care of string case... see these tests: http://hashmysql.org/paste/1422
<7> do you know when (what version of Mysql) introduced SQL_CALC_FOUND_ROWS + FOUND_ROWS() ?
<8> _fil_: 4.0
<8> _fil_: It's in the manual
<9> anyone alive at this ridiculously early hour?
<1> no
<7> salle: thank you!
<9> lol, im using the FreeBSD ports collection on FreeBSD 6.0
<8> VampireBlake: It's quite decent hour you know. 2 hours past noon
<1> 9pm here
<9> i installed the client and server ports and setup /var/db/mysql
<1> the Intarweb isn't only in the US, you know ;)
<9> but when i goto run the daemon, it errors out looking for a file thats there
<9> 060207 0:41:48 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
<9> root@titanium# locate host.frm
<9> /var/db/mysql/mysql/host.frm
<9> ah ha, ok i feel dumb now lol, I forgot to use -R when i did chown on the dir
<10> hello
<10> does anyone here know of a good and free mysql query builder?
<11> please
<11> can someone help?
<12> pls help. i have installed mysql community edition 5.0. where can i download a GUI that would help me create tables, put values in tables, etc. thanks
<11> rye: webyog
<12> sal: is it for free?
<11> yes, there is a free version
<12> okie. thanks
<11> the only thin that differs it from the pro version are someutilies like bd sync
<11> db sync
<11> nothing
<13> !tell Sal`` about gui
<14> Alrighty.
<12> Sal``: i am new in databases. i downloaded mysql community edition 5.0. is this what i need? i need to create tables, manipulate tables.. etc. for my database project in sch
<1> rye, sure, why not
<0> infi, what wrong with this file
<0> http://paste.uni.cc/8551 <-- this is my.cnf
<0> but mysql not reading it, always starts on 3306
<15> does LOCK TABLES do a re-ordering of the tables to avoid deadlocks on its own?
<16> heu
<16> is there a way to query the disksize a database has?
<17> SunDevil - just go to hte data dir and ls -alh
<17> or something
<16> sjrussel: yes, but i need to get it from inside a script and a systemcall would be a bit ugly
<0> if mysql running on different port then the default 3306, howto connect to it using "mysql" from CLI?
<16> --port=
<17> SunDevil - maybe with the check syntax
<17> !m sjrussel CHECK
<14> sjrussel: (How to Check MyISAM Tables for Errors) : http://dev.mysql.com/doc/mysql/en/Check.html
<16> aw sorry, 4.0.24 mysql server
<17> that's ok, it's the same
<17> but it won't do it
<17> myisamchk does
<17> but it's cmdline too
<0> SunDevil, not working
<18> how to store a gzcompressed var into mysql ? (using php gzcompress command)
<19> hi everybody
<20> Morning, faber2
<19> when i use mysqldump, can i specifiy to only include certain columns of a table?
<21> anybody home? -- Field terminated by should be what for csv file?
<20> um... csv, isn't that comma delimited? I ***ume you're generating it in mysql, check the product you're importing it in to and see what it can use for delimiters
<16> xiaogil: standard way, only put it in a blob
<22> a quick question: MySQL 5.1.5 does not have mysqld.exe, right?
<16> CSV: Comma Seperated Value
<23> hi all
<22> hi
<18> SunDevil: iactually I had to use this => $compressed = mysql_escape_string(gzcompress($row['file'], 9));
<18> SunDevil: it works fine now
<23> I would like to know if it's possible to retrieve sql data type of procedure arguments ?
<23> I don't see that in INFORMATION_SCHEMA
<23> so I think it's not possible, and you ?
<19> can i select INTO and generate a new table?
<21> cornell, YOU THERE?
<24> !perror 1114
<13> Leithal an idea
<25> cornell ****s
<26> archivist: pm away
<27> Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
<27> wtf ?
<13> do it a table at a time as mysqldump drops out at the first bad table therefore missing a portion
<13> Damn xchat
<26> archivist: interesting
<28> hello all, i need to implement a parent child relationship on the same table, anybody have any ideas on how to accomplish it?
<26> would have to have a thread holding global lock as well
<20> Morning Leithal
<26> not sure if that's possible in batch ;p
<13> sounds a bit yuck
<26> indeed
<28> or is it best to model it at the application level rather than database level?
<26> otherwise you are simply not going to a get a consistent snapshot, dumping a table at a time
<13> very true but a dead table kills 90%
<13> heads you lose , tails you lose
<26> how running a check tables on all tables before hand?
<26> s/how/how about
<13> yes then tell/stab the user/admin
<26> well I think would be part of a wider framework
<26> i.e. if the log bombs then notify x by email - with some other process
<21> Badly need help importing a file into mySql
<26> and bombing a mysqldump based on the bad check table (before trying to dump)
<1> frankg: mysql < file.sql
<13> yup should be clean ish then
<21> infi, it's a csv file
<26> !m frankg load data infile
<14> frankg: (Problems with NULL Values) : http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html
<26> gah
<26> !m frankg load data
<14> frankg: (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<21> I have phpMyAdmin
<1> then you should probably read the docs that come with it
<21> they're sad
<1> alternately, ask in #php, because that's php-specific and unrelated to the backend database software itself
<21> maybe I'll try LOAD DATA INFILE
<21> looking
<29> is there an option you can set in my.cnf so that new tables are created using InnoDB by default?
<16> disable skip_innodb
<16> err skip-innodb
<29> skip-innodb?
<16> yes
Return to
#mysql
or
Go to some related
logs:
#perl
#php
#ldap
delete files from dvd
#mysql
MYSQL Substract two counts
apt-get install xfont-artwiz
#css
#suse
sarge etch upgrade 64 bit
|
|