#mysql
04 October 2007
Total 23 pages. You are browsing page 2/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:36 <****> even myisam?
01:37 <****> then it doesn't matter, because if it's not all the way written it's not all the way valid and it's not technically inserted. besides you'd have bigger problems requiring fsck or chkdisk or the like if something like that really happened
01:37 <****> so knows what to backout
01:37 <****> not myisam
01:37 <****> we used to get it a lot.. we were using a openvz kernel.. it used to crash about 1 to 2 times a fday and there would always be database corruption when it started up
01:38 <****> so innodb might solve tht problem?
01:38 <****> yes
01:38 <****> cool :)
01:39 <****> which do you use?
01:39 <****> depends
01:39 <****> :) good answer
01:40 * arthas242 googles
01:41 <****> Xgc, not really a design mistake, more of a restriction on what each table's used for
01:43 <****> Mrdini, if they have the same data and a similar/same job then one table could easily be better
01:44 <****> whats wrong with this: select from_unixtime(custdate) from custtable where custid=19;
01:44 <****> Mrdini: Notice the word "possible". Try describing the model.
01:45 <****> archivist, well, didn't want to go off on a tangent - but basically, we have 2 tables.. one contains registration info, the other table contains similar info, but is ONLY used for "contact us" purposes
01:45 <****> i.e. some people don't want to register
01:45 <****> oooh falcon :)
01:46 <****> that's why I said earlier - data isn't replicated... it's in one or the other table
01:46 <****> same purpose really just add a flag registered or not
01:46 <****> idd
01:46 <****> Mrdini: At worst, you have a design mistake. At best, you probably are just not thinking properly when you describe the SQL problem in procedural terms.
01:47 <****> Mrdini: Usea foreign key and outer join to obtain that information. Do not use a procedural if/then construct.
01:48 <****> fkey? hmmm, explain? (last I looked, MySQL didn't have the concept of foreign keys)
01:48 <****> anyone any suggestions at all/
01:48 <****> innodb seems fastest too ... http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/
01:48 <****> Mrdini: The lack of an entry in the contact us table will result in null columns in the result set. You won't need to explicitly perform an IF/THEN operation.
01:49 <****> Mrdini: See InnoDB.
01:49 <****> Mrdini: Look into foreign key constraints.
01:49 <****> Xgc, oh hey, about time :P
01:49 <****> Mrdini, fks have been around for years
01:50 <****> Mrdini: Sometimes if you just humor me, you'll get the answer you want, but much sooner.
01:50 <****> Xgc, :) it's just that there's a lot of stuff "surrrounding" this database so :(
01:51 <****> like data!
01:51 <****> yeah!
01:52 <****> actually, I might as well dump the structure... sec
01:52 <****> whats wrong with this: select custid, (UNIX_TIMESTAMP(custdate) as date where custid=19; i get an error near as date
01:53 <****> anyone familiar with .out data files
01:53 <****> wanderingii, reserved word
01:53 <****> Does anyone know how I can output a SQL query in Mssql to a file??
01:54 <****> the as date bit?
01:54 <****> date
01:54 <****> wanderingii you cant alias a column with a reserved word like date.
01:54 <****> Xgc, http://pastebin.ca/724950
01:54 <****> rite cause i changed it to as date123 and still didnt wwork
01:54 <****> the other table - the "main" table is broadly very similar
01:55 <****> if public_users_id is a non-zero value, then it should retrieve from the public_users table
01:56 <****> otherwise, pull from public_users_contact
01:56 <****> wanderingii, and missmatched ( remove
01:57 <****> hm that enabled the query to run but just produced a zero value
01:57 <****> hi guys! i'm back!
01:57 <****> anyone could see why this function doesn't work? http://www.paste2.org/p/7868
01:58 <****> Yamm, yay! "doesn't work"!!!! if I could have a cent for every time I hear that :P
01:58 <****> :)
01:58 <****> Does anyone know how I can output a SQL query in Mssql to a file??
01:58 <****> i put the error code too
01:59 <****> what is an OUT file
01:59 <****> Yamm, oh so you did, my bad
01:59 <****> =^^=
01:59 <****> Grandiej, MSSQL != MySQL
02:00 <****> anyone knwo why its not producing a value?
02:00 <****> the error is not very clarifying indeed :(
02:00 <****> is there a way to return a list of matching items into a row ? Example: | id | user | list, of, many, items, created, by, aggregate, function |
02:00 <****> tators an executable program
02:00 <****> how do I execute it
02:00 <****> I'm on windows
02:00 <****> it is befuddling me
02:00 <****> YammYgirlcoding, in is reserved
02:01 <****> tators not a mysql problem really
02:01 <****> k what channel do I go to
02:01 <****> archivist hmm what is the right syntax then?
02:01 <****> #out?
02:01 <****> ..
02:02 <****> tators try #mssql ?
02:02 <****> no one there
02:02 <****> maybe #sqlserver ?
02:02 <****> keep in mind I am using mysql
02:02 <****> but I'm trying to put this into a mysql server
02:02 <****> ah
02:03 <****> is it a text file
02:03 <****> is there a way to make a auto increment field start with like Aand then auto increment numbers after it like A1 A2 A3 A4 ?
02:03 <****> I don't know
02:03 <****> it is .out
02:03 <****> look in it
02:03 <****> I can't open it
02:03 <****> hey does anyone know how can I print a cursor in sqlplus?
02:03 <****> http://www.elections.state.ny.us/portal/page?_pageid=35,1,35_8361:35_8374&_dad=portal&_schema=PORTAL
02:04 <****> download any of the data files on the new york website
02:04 <****> so. Anyone could tell me how to fix it? http://www.paste2.org/p/7868
02:04 <****> I have no idea how to handle them
02:04 <****> (it's a function)
02:04 <****> tators, tried opening in a text editor?
02:04 <****> I need some help to begin to use the connector for c#, is this the right place to ask for help?
02:05 <****> YammYgirlcoding, in() is a function itself
02:05 <****> mguezuraga, typically speaking, not really - as it's language-specific help you probably need
02:05 <****> Mrdini: ok, no problem
02:06 <****> you can try asking :P
02:06 * Mrdini doesn't do C# thou'
02:06 <****> archivist how come? What should I put instead?
Total 23 pages. You are browsing page 2/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last