| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> http://images.dp.cx/misc/DC/rc5-completion-20060202.png
<0> http://images.dp.cx/misc/DC/rc5-completion-20060209.png
<0> 120 years, in the span of a week
<0> not too shabby :)
<1> is it better to use the timestamp data type rather than using an int and putting in a unix timestamp?
<0> ww :(
<2> paulgb: depends on what you're using it for
<1> inviso: for example, for storing the time that a new user signed up to a website, or when a post was made
<2> so, for input, you'd generally have a date rather than a unix timestamp. How about display usage? Would you ever fetch a unix timestamp or would you want a formated date?
<3> in a table i have a string, that string actualy is a regexp pattern can i get the rows that contain the regexp that matches a string?
<4> So who was annoyed by my find-next-free-UID problem?
<2> jengelh: ooo, you're back ;o)
<4> Try this
<4> select min(uid)+1 from users as u1 where not exists (select uid from users as u2 where u2.uid=u1.uid+1) and uid between 1500 and 1509;
<2> oh my goodness
<4> heh
<4> now what
<2> why would you do that to yourself?
<5> anyone know of a winxp gui mysql diff app thats free? I'm looking at SQLBalance but thats i'm guessing $85. Thanks
<1> i would want a formatted date, but I would also want to easily make date comparisons.. i used to use the timestamp data type, but I switched to unix timestamps a while ago because i found it was easier to format in php
<2> paulgb: format using date_format in the database and store as a date
<4> inviso: cause i don't want to read the full table with the underlying C program to scan all table entries for what I want
<2> jengelh: heh, you're dodging the issue. Good luck with the monster you have created
<4> that would mean I ran more than 20000 iterations of mysql_fetch_row for each 'looking for next uid'
<2> !tell Brendon_ about gui
<6> Alrighty.
<7> Hey guys, how do I add an account for a client to access my msqld remotley?
<8> paulgb: Using a datetime lets you use all of the date functions and lets you convert to unix timestamps with unix_timestamp when necessary. Using an int lets you get at the unix timestamp but makes you convert from unix timestamps with from_unixtime in order to use the date functions. Figure out which one you need more and use that.
<5> thanks inviso, i'll check those out.
<2> niGhTm4r3|: where 'my_string' regexp col should work
<2> !m dusty- adding users
<6> dusty-: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<3> wow.. thanx inviso :P
<7> danke
<2> niGhTm4r3|: np, enjoy
<1> thanks inviso and mendel
<9> I was wondering if someone could point me in the right direction here. I have a .sql file that was created using mysqldump and it contains all the db's from one server and I'd like to transfer only parts of that db into a new db on a new server.
<9> does anyone have any idea how I might go about this?
<10> Gumby you'll probly have to remove the DB's from the dump file
<9> so remove all of what I dont need. and then what? I dont want to import the whole DB, only parts of it
<10> oh
<10> so the db already exists..
<10> and you only want to import a couple tables?
<9> correct
<11> where can I change parameters? In the my.cnf under mysqld section?
<12> psycho circus autor: kiss!
<10> zap123 yeah for instance
<12> welcome to the show..
<10> Gumby well, you'll have to take the other stuff out then, or can you make the dump again?
<2> zap123: yup
<10> because then you can do: mysqldump [OPTIONS] database [tables]
<11> do I have to restart my mysqld for it to take affect?
<11> thanks
<10> zap123 you can set most stuff in an active mysqld
<10> just add it to conf file, then also change directly by logging in as root and changing the variable.
<9> Jax: yeah, unfortunately the old db is gone, and the user that backed it up just did all db's
<9> hehe
<10> but some things need a reboot i guess.
<9> but i am sorting through it deleteing all non relevent info
<10> :(
<11> jax how do I change the variables directly?
<2> Gumby: why not load the whole dump into a test db and do a new dump?
<10> zap123 which one? SET @@global_var='X'
<11> I want to change join_buffer_size size
<9> inviso: thats what I'll end up doing I think. I have to remove all the other db's from the file first though
<1> !tell me about indexs
<6> But I don't know a thing about that.
<1> !tell me about index
<6> But I don't know a thing about that.
<13> hi
<13> i have an error with a mysql-dump using mysql 5.0 http://phpfi.com/101266
<10> `credits` int(11) NOT NULL default ''
<10> does that look right to you pretor66 ?
<13> yes .. at least similar to `hits` int(11) NOT NULL default '0' where no error occurs
<13> argh u right
<13> forgot the 0 for int
<1> do varchars need an extra char for a null char?
<11> What good value for join_buffer_size?
<13> thx cya
<10> cya
<1> is there a way to change the order of columns in a table in phpmyadmin or mysql syntax?
<14> can I do SELECT COUNT(DISTINCT(f.*)) FROM foo f
<14> apparently I can't, but there must be some way to do it
<10> Davey what you trying to do?
<15> hello! how can I set the default maximum packet size of my mysql server? Since I tried to insert an mp3 as a blob and it complained that the maximum packet size is tooo low... what can I do?
<14> Jax: I have a query with a JOIN, and I want to COUNT the number of DISTINCT results
<10> drop the ( )
<1> bright: why do you need to store an mp3 file in a mysql db?
<10> SELECT COUNT(DISTINCT results) FROM student;
<14> Jax: that also doesn't seem to work
<15> paulgb: Well actually I want to store arbitrary files there and an mp3 was just the first that came under my mouse pointer ;)
<14> SELECT COUNT( DISTINCT * ) AS numrows
<14> FROM acalog_course c
<10> you need a specific field or?
<1> bright: http://hashmysql.org/index.php?title=Storing_files_in_the_database
<10> SELECT COUNT(DISTINCT myColumn) AS distinctColVals FROM t1;
<14> ah, MUST specify the column, thanks :)
<10> well
<10> you can use a list too COUNT(DISTINT, c1, c2, c3) i think
<16> could someone help me please connect to mysql 5 from c under windows? either odbc or mysql api, just make it work. i might have problems properly linking mysql.h and mysqlclient.h under borland builder 6 ( in case you haven't figured out yet, i'm a rookie :) )
<1> bright: I don't really know how to answer the question, I was just reading the faqs and I came across that as you asked the question
<10> oh Davey try this: COUNT(DISTINCT)
<15> paulgb: ok. thanks!
<17> when i try to select data into an outfile, e.g. select * from table1 into outfile 'test.out'; it show diagnostics message 'ERROR 1045: Access denied for user: 'jade@localhost' (Using p***word: YES)' any ideas how to resolve?
<14> that didn't work, specifying a specific column does, however :)
<10> Davey which version?
<10> and 'doesn't work' -> error, or different result than expected?
<10> yeah i gues COUNT(DISTINCT) is not allowed.
<10> then again mysql is nice enough to allow COUNT(DISTINCT c1, c2, c3, ...) ANSI SQL does't allow this
<18> the world is over
<18> the end is near
<14> friggen finally.
<19> heya, I just installed mysql on fedora core 4
<19> and i get the error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" when i give the command mysql
<10> well does that file exist?
<16> can someone help me with including mysql.c under borland builder? it keeps saying "declaration missing" for my_socket fd; in mysql_com.h
<16> (and i could use some help with linking in borland builder in general :)
<19> i'm not sure :-s I've never tried to use mysql before... I'm stumbling around in the dark
<19> no, that file does not exist :(
<17> for a 32-bit x86 linux os, what is the max db size?
<20> depends on your filesystem
<17> ext
<17> ext2
<21> what is the "most efficient" way to accomplish this: "if row exists, update column name. Otherwise insert row"
<20> jade: I don't know the specifics, but google does
<20> !m Kaitlyn INSERT
<6> Kaitlyn: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<20> see ON DUPLICATE KEY
<19> jade: my best guess would be 65536 records... but i really have no idea, don't take my word for it, thats a *GUESS*
<20> Tinned_Tuna - that's a joke, right?
<21> sjrussel: What about prior to 4.1?
<19> it's my best geuss, lol
<20> Kaitlyn, it just depends on your OS
<22> Tinned tuna thats silly thats a 16 bit number
<19> ahh ok
<20> Tinned_Tuna: you're thinking of Excel
<19> hehe *hits head on desk*
<19> im new here ;)
<19> i can't even get MySQL to run :-(
<20> is your refrigerator running?
<19> i think so...
<20> you better go catch it!
<17> Tinned_Tuna: thanks, looks like MySQL Version 3.23, the maximum table size was increased to 8 million terabytes
<19> so how do i get around the error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" ? :-s
<20> you start mysql
<19> i have just mkdir a mysql dir in /var/lib
Return to
#mysql
or
Go to some related
logs:
upgrade from ubuntu 5.10 to 6.06 LTS using install CD
alternative eselect-compiler
debian etch xorg fixed font
#postfix
smp mtable bad signature
not a debian disc ubuntu
#sed
php6 preg_match
gphpedit shortcut
linux giftd really slow
|
|
