| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> well you've at least got the client installed
<1> well i had mysql-common installed
<1> and then i saw i didnt have mysql- client server installed
<1> so i am installing that now
<1> ok i think i got it installed now
<2> Evening
<1> how do you start mysql again :(
<2> Morning, Afternoon, etc...
<0> mysqld_safe&
<1> me@cpe-24-33-228-64:~$ sudo mysqld_safe&
<1> [1] 21437
<1> me@cpe-24-33-228-64:~$ mysqld_safe[21476]: A mysqld process already exists
<2> I have a sql issue i'm not sure how to resolve... i have a query that access two tables, it seems if one them is empty then i always get no results (even though i am using a CASE/OR)
<1> ok ok i got it connected good good
<2> Wizz_kidd1: try sudo killall mysqld
<1> its running now :P
<2> kk :)
<1> this mysql administrator looks like a great program
<2> Wizz_kidd1: what app?
<1> its called MySQL administrator
<1> nicely put together
<2> ... i want to do a (if exists in this table, get this, else get this) but it seems to only work if both tables have data :(
<0> !m Haoshiro join syntax
<3> Haoshiro: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<0> Look into an outer join
<2> will do, thanks
<1> any of you guys ever use Ruby programming
<2> bobfield: off hand do you know if that will let me get data from one table, and then based on the results... get data from 1 of 2 tables?
<2> (looking at docs now)
<0> can't say offhand without a look at the schema
<2> bobfield: okay, thanks anyway
<0> describe your tables, put it in a pastebin and I'll take a look
<1> n00b linux question how can i CHMOD a directory to 777
<1> */var/www/faq
<1> is the dir
<0> chmod -R
<1> so chmod -R /var/www/faq
<1> like that
<0> the whole directory and everything in it?
<1> yes
<0> yes
<1> sorry i havent been using linux too long
<1> like 3 months and im used to guis doing everything for me
<4> um
<4> they do in linux too...
<1> huh?
<1> chmod -R /var/www/faq didntwork
<0> you left out the 777
<1> where do i put that
<0> chmod -R 777 /var/www/faq
<1> chmod -R 777 /var/www/faq
<5> how do I set the default for a temporal column to the current date/time + 1 day?
<1> ok good
<1> thanks again
<0> np
<4> dudewbe: does default dateadd('d', '1', curdate()) not work ?
<4> hiya yock long time no see :P
<6> evenin'
<4> ah
<4> default date_add(curdate(), interval 1 day) is apparently the mysql syntax
<5> is there a reason now() cant be used instead of curdate()?
<4> none at all
<4> well... none of which i am aware
<5> well neither is working for me anyway
<4> hmmm
<4> maybe mysql does not support using a default curdate() type thing
<4> i have not tried it in mysql
<0> no it doesn't, not in a create table
<7> how do i reset my db p***word
<5> if you use now() it sets the default to current_timestamp but if you use any arithmetic on it an error is given
<4> curious
<0> !m jrthegoob resetting p***word
<3> jrthegoob: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<4> is there a reason why you need the arithmetic on the column ?
<4> could you not just insert values in such a way that you have to do the arithmetic when you retrieve the data ?
<5> because I want the default to be 1 day in advance of the date the record is created
<4> although that does not sound like the best database design idea in the history of the universe :P
<4> what version of mysql are you using ?
<5> 4.1 I believe
<4> i would try using the latest version and see if that does it
<8> how can i simulate that two atributes are the primary key?
<5> updating would seem like an even bigger problem at this point
<0> pix_dax, you can create a primary key that spans two columns
<5> andrewbryson, are you able to create a column in a table with a default of now() + 1 day?
<8> can you show me how or derive me to a reference please?
<4> dudewbe: i have no idea
<9> how to create an index that spans two columns?
<9> list multiple columns, comma-delimited
<5> ok thanks for responding
<8> PRIMARY KEY(1,2)
<10> anyone here are good with regex? myfield the values are: 'A123' , 'A45' , 'x67', 'TR-089' my question is: how get only the numbers of each record? thanks
<7> Starting MythTV server: mythbackendSession management error: Could not open network socket
<7> thats the error i now get
<5> in regex to match only numbers is \d
<10> escuse me i have no idea how to apply in a sentence
<10> can you give pelase an example?
<5> are you trying to use regex in a mysql querry?
<10> yes
<5> I think you have to use the select syntax with the LIKE keyword
<11> you can use REGEXP()
<11> jak2005: http://dev.mysql.com/doc/refman/5.0/en/regexp.html
<5> in regex [\d] matches only the numbers in a string
<5> to incorporate that into a mysql statement I suggest reading the documentation on string compare functions
<10> ok, thanks
<10> i see the sample
<10> at bootom of page...
<12> Hi.
<12> Does anyone know of a different mysql ODBC driver for linux other than myodbc?
<12> I've got a buggy situation here and need to get something other than myodbc.
<13> why should there be a different one, when the standard one works perfectly ?
<13> presuming you have ODBC updated, that is.
<12> It doesn't work perfectly.
<13> 'fraid it does
<13> if you are having problems with it, it's not MyODBC
<12> I know, but the situation is in conjunction with somebody's buggy product --maybe they're still using something deprecated that was purged from myODBC like PHarvey said.
<13> well, that's the only MySQL ODBC driver
<13> and there is nothing wrong with it
<13> I don't know what else to tell you
<13> why use a known-to-be-buggy product ?
<12> I'm getting an error here from using this DataDirect socket server: << java.sql.SQLException: [CastIronSystems][Sequelink JDBC Driver][unixODBC][Driver Manager]Invalid string ro buffer length >>
<12> I'm getting an error here from using this DataDirect socket server: << java.sql.SQLException: [CastIronSystems][Sequelink JDBC Driver][unixODBC][Driver Manager]Invalid string or buffer length >>
<14> Speak, or forever hold your peace.
<8> wht to do with curl if u have no submit button
<8> <a href="javascript:send();"><img src="blah" border="0"></a>
<8> only that
<15> in C; using prepared statements; how can I figure out how big a BLOB is before storing it?
<8> <script language="javascript">function send() {frmSend.submit();}</script>
<8> and that
<4> ummm... how would you get it into the variable without knowing how big it is first ? you would need to allocate space...
<8> sory wrong #
<4> why not just <input type=submit value='ugly submit button'> ?
<4> :P
<14> Or
<14> Ask in #web
<4> but if they ask in here they can get answers that are not optimally suited to what they want to do :P
<14> True
<8> im asking php
<8> sorry
<14> Why PHP? It's not even PHP?
<16> because the nice folks in ##PHP like answering silly questions
<14> ahhhhhhhhhhhh
<14> I'm being attacked
<4> you have to wonder why someone would attack freenode of all places :S
<14> Because they hate PHP
<17> sjrussel, no we don't
<15> what is the difference of buffer_length and length for the BLOB data type when using the C API ?
<18> http://pastebin.com/647320 >> my query (using a LEFT JOIN) returns the relevant rows twice. can somebody tell me how I can fix this? When I remove the join, the problem doesn't occur. Your input would be greatly appreciated....
<18> I would also be very happy to know why this is happening, so I can learn from it...
<19> dewaard: what the join does here is to combine all combinations of rows from fcv/feo that match the criteria in your ON clause
Return to
#mysql
or
Go to some related
logs:
+gaim+gtalk+error+not-authorized
#math
queue/mess perms
reiser chkfs
bzip2smp
Error: the sys-apps/pam-login package conflicts with another package.
linux defrag* necessary?
Crystal_Vista_XT_Paolo_Mod
#perl
htop.rpm
|
|