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