| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> shabbs you woudl think so huh
<1> that's what I gather from the docs
<1> but it's time for me to go, sorry man. g'luck
<2> !man how big
<3> (How Big MySQL Tables Can Be) : http://dev.mysql.com/doc/mysql/en/Table_size.html
<0> DogWater you need to make sure the .ini tells it where to go
<2> Is it safe to give a cat DogWater?
<0> DogWater, unless of course your using Linux then it is my.cfg
<0> will sure
<4> if i get the error
<4> [MySQL][ODBC 3.51 Driver][mysqld-4.1.16-max]Table 'm33accounts.Customers' doesn't exist
<4> but i login with mysql query browser from the same machine the odbc is running
<5> hi there, when importing an .SQL file into my database, I get "ERROR 1293 (HY000): Incorrect table definition; there can be only one
<5> TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"
<4> with the same username and p***word
<4> and i can query the customer table just fine...
<5> it seems other databases support this, is there any way to modify things to work with MySQL 5?
<4> what might be the problem?
<4> ..
<6> mutilator: what app uses myodbc?
<6> mutilator: did u read about the options switches of the myodbc driver?
<7> hi all
<7> i am looking for best practices of storing timezones of registered users, how would you store the timezone of the user?
<7> would you store it as say "America/Los_Angeles" or "GMT-09:00" or "PST"
<6> i would stor it as integer
<7> e-PUNK: care to elaborate
<7> e-PUNK: for the above Los_angeles
<7> what would you store?
<6> depends on how u use this information
<7> basically, just to display time to the end user
<7> so I would use, Timezone.getTimeZone("America/Los_angeles") in java
<6> and the user may choose a string which set his timezone?
<7> is there a database table somewhere where I could get this generic information
<7> yes
<6> u dont want to type these information in manually
<6> u dont want to type in these informations manually
<7> is that a question?
<6> yes
<8> olygoat: ya ya
<7> not really. in the user table, get a reference to the timezone table, say a timezone_id. in the timezone table, store the timezone_id and the actual value for the timezone to calculate the desired time. there are other tables that use the timezone table for reference
<4> e-PUNK: yea, iis is using it
<9> i just installed mysql on linux, how do i start using it? any links to tutorials?
<4> and i changed all switched like i normally have them
<6> oha
<9> specially on how to use the text-based client
<10> !m munti tutorial
<3> munti: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<7> any suggestions
<7> ?
<10> !tell us about tutorial
<3> archivist asked me to tell you this: MySQL Tutorial: http://www.mysql.com/doc/en/Tutorial.html SQL Tutorial: http://www.sqlcourse.com
<6> dingo001: i d never done something like that.
<10> have a small timezone table tz,offset_from_gmt
<7> archivist: this should be a fairly common problem, is there any public data wit hteh offset values?
<10> google
<11> how do you join two strings? I want to insert "Validated at"+NOW()... what do I use to actually join them?
<12> Ungy, and a table with 2 millons rows. MySQl will can work properly with that? Or it can be a problem?
<12> (my proyect is going to have thar numbers or rows in a table)
<13> Zarta: 2 million rows is not very big
<14> !m JoJoFAN CONCAT
<3> JoJoFAN: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<12> that is my problem.
<0> Zarta that is well within range of a mysql database
<15> Hi all, in mysql 4.1 can i convert a field with a date format like this 2005-01-25 into a timestamp then compare it to field in another table?
<14> !m Brendon date time functions
<3> Brendon: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<0> Brendon, yes
<15> thanks i'll check that out
<12> Ungy, and 700.000 rows? they will be to much?
<12> (for a table)
<16> hello. where is a good place to post requests for consultation? (not here i'm guessing)
<0> Zarat unless you have gigs of information per row no
<0> Zarta seriously go read the manual
<0> !m Zarta BIG
<3> Zarta: (How Big MySQL Tables Can Be) : http://dev.mysql.com/doc/mysql/en/Table_size.html
<10> jjb_lyceum join the mysql network
<11> inviso: I get the following: You have an error in your SQL syntax near 'CONCAT('Order verified: ',NOW()) WHERE id=1' at line 1
<16> archivist: then make my request in what venue?
<11> ooops nevermind!
<10> !m jjb_lyceum mysql network
<3> jjb_lyceum: Nothing found
<10> try here http://www.mysql.com/network/
<17> hey, i'm having trouble indexing a large table. the table was corrupted, so i dropped it and re-created it from fresh data. this much works, but the indexing kind of hangs after a while. what should i be looking for?
<13> creating an index takes a while
<13> how big is it, and how long is it taking?
<17> i know, about 45 million rows, about 63 characters each, varchar, indexing only that column
<17> after about 45 minutes (the usual time), mysqld's CPU drops, but the client is left hanging
<13> that index will be 2.4 GB at least
<17> it's of the .com domain list, usually closer to 1GB
<13> still, I'd guess you're getting disk bound
<17> right, i'll check that
<17> sjrussel: looks like /tmp is filling up
<13> how is it 1GB, though? 60*40 =2,400, right?
<17> the average length of the names is much shorter
<17> probably closer to 20 chars
<13> that sounds like the problem, then.. you can move the tmpdir to somethign with more space
<17> in my.cnf?
<13> right, IIRC
<17> k, thanks
<18> mysql is a dog on a mac. horrible horrible performance.
<19> hi, load DATA LOCAL INFILE '1156.csv' replace INTO TABLE mydb.mytable gives Query OK, 170 rows affected, 3395 warnings (0.09 sec)
<19> Records: 85 Deleted: 85 Skipped: 0 Warnings: 3395
<19>
<19> is this some kind of error?
<19> because I do not any changes in the database
<19> of these 85 rows some are new for the database some are the same
<20> MrKeuner: you did say replace. so you get the functionality that replace provides. see the manual.
<20> MrKeuner: you may also wish to check the warnings. there's a lot. could be truncation etc. SHOW WARNINGS (from 4.1 up)
<19> I thought replace would replace the old ones while adding the new ones to the databse...
<21> what is the easiest way to edit all the data in a mysql table at once? :)
<15> what is the correct syntax for this, UNIX_TIMESTAMP(tablename.fieldname)? Or am i not doing this correctly? Thanks in advance.
<19> Brendon/ why don't you just use integer for the type and store unixtimestamp that way?
<15> MrKeuner: in one table i have a date format like this 2005-04-30 and i need to convert that to a timestamp so i can grab timestamps from another table.
<22> anyone know if there is a way around this: http://bugs.mysql.com/bug.php?id=9090 (all subqueries executed as dependent subqueries)
<19> arjenAU/ I have also tried ignore more, I have removed the duplicate lines and tried only adding the new lines but still similar problem. mysql> load DATA LOCAL INFILE '1157.csv' INTO TABLE mydb.mytable FIELDS TERMINATED BY ',';
<19> Query OK, 0 rows affected, 140 warnings (0.04 sec)
<19> Records: 14 Deleted: 0 Skipped: 14 Warnings: 140
<19> what a I missing?
<20> MrKeuner: randomly trying other options is not a good idea. you need to understand what they do and choose the option you require.
<23> hey folks
<23> how can I turn SELECT * FROM media WHERE (filesize = '< 1048576' AND media.client_id = 1) into a working sql statement?
<24> ...
<24> SELECT * FROM media WHERE (filesize < 1048576 AND media.client_id = 1) ?
<23> yeah .
<23> I need to just hack something for now where I can leave the = there...
<23> is that possible?
<24> why
<23> cause I have a client meeting soon and I can't hack the thing that generates the query fast enough to do < > etc for things that its inserting from a hash..
<24> you could do it with "in", but not with =
<23> mm
<22> quik__: you dont need the parens
<22> and you might have to put the filesize in quotes if the filesize field isnt a number
<23> mmm?
<24> mae^ he knows he's trying to do something retarded
<23> thanks hans :)
<24> no problem, i'll stick up for you!
<14> quik__: Why did you put the < inside the quotes?
<23> its the way the hash table is written
<23> and the way it converts my hash to a query
<23> nevermind, I thought I could somehow escape the string
<23> or something
<24> you could just use dynamic sql
<14> Is '< 1048576' a valid value? Or is it rather '1048576' that is the actual value?
<24> '< 1048576' is the value i'm sure
<14> ok, then what do you mean by 'working' sql?
<24> so he just needs to use dynamic sql if he wants to evaluate that as a statement
<14> oh, the user typed in <1048576?
<25> Hey guys -- I am attempting to create a simple mysql based search engine. I would like to be able to search a database -- what command could complete this? (IE: Search for the word "test") How can I search columns for this word, but the columns dont have to just include that word.
<22> you shouldnt ever take what the user gives you to put into a query. parse it first
<14> !m ***yKen fulltext
Return to
#mysql
or
Go to some related
logs:
#css
xcompmngr
#css
wmctrl fluxbox menu
ubuntu upgrading to dapper draker
#lisp
wx.python OGL demo
ubuntu sharutil
#perl
ssh_exchange_identification libc6
|
|