| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> iMacGyver: ok, i'll give that a shot. The query isn't crucial right now to the proper operation of my application, i was just messing around with the feature that uses it, so i probably won't bother with it for a while
<0> but i'll try that
<0> thanks for the advice
<1> np
<1> brohism: also your delete looks strange, are you trying to delete rows?
<0> iMacGyver: yes
<0> i did it according to what i thought the docs on mysql.com said to do
<1> all those tables (employee_list, employee_employment_data, etc...)
<1> usually is follows 'DELETE FROM table WHERE field=something'
<0> iMacGyver: even when you're deleting rows from multiple tables?
<1> brohism: well then i'd image you'd do a join on it...i usually use ref integrity and cascade delete
<0> iMacGyver: I changed my query to read like this: "delete from employee_list, employee_employment_data, employee_pay_cycle, employee_permissions, employee_timesheet where employeeid='$employeeid'";
<1> i ***ume this $employeeid gets filled in with a string from somewhere?
<0> yes
<1> and all those tables have a field called empoyeeid?
<0> iMacGyver: here's the error i got when i ran it: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where employeeid='000030'' at line 1
<1> i think you need to be more specific in your join...i've never personally done a joinned delete so i'm not sure of the syntax
<0> ok
<2> Hi. Is there a kind of case studio for constructing database schemas for mysql on Linux?
<1> brohism: DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;
<1> for example...you need to specify how each table is joined/limitted
<0> ok
<3> I'm trying to setup mysql to log everything for debugging purposes. Ive set log=/var/log/mysqld.log but it doesnt seem to be logging anything.
<4> hey guys
<4> I'm looking for a MySQL equivalent to the strtotime() C and PHP function. I've tried STR_TO_DATE() and EXTRACT() but they don't do what I need...
<4> does any one know an altnernative I could use? the problem is that I don't know the format of the String containing the date (I'm getting the dates from a 3rd party source and don't control them), so the solution needs the flexibility that the strtotime() function has (that function can take about any date as input)
<5> as far as mysql optimization goes.. what is faster.. GROUP BY or making two different tables and JOIN ing?
<5> dewaard, look at the docs?:) hold on I'll find it
<4> D2DChat2: yes, I'm looking at the docs but I can't seem to find the right function
<5> dewaard, check DATE_FORMAT
<5> dewaard, are you trying to format the date or grab a formatted date?
<5> and turn it into a mysql readable date
<4> D2DChat2: I'm afraid SELECT DATE_FORMAT("Fri, 10 Feb 2006 23:41:51 GMT", "%W %M %Y") AS df; return null
<5> cuz you did it wrong
<4> D2DChat2: I'm trying to convert a data in an unknown format to DATETIME so I can store it in my database. In PHP or C I could do this with strtotime(), but I don't have that function at hand so I need to do it in SQL
<4> D2DChat2: what did I do wrong?
<5> dewaard, hold on a tick
<6> wondering if I can get some help
<5> dewaard, STR_TO_DATE exists
<5> dewaard, I think that's what you want
<4> D2DChat2: I know, but it returns null on that String as well
<5> dewaard, well we gotta find the right %vars :)
<6> I created a new MySQL user and gave this user a p***word. Whenever I try to connect to the db with this user, using the p***word, I get connection errors, but if I remove the need for this user to enter a p***word (no p***wd) this user can connect to the db, YES I thought of spelling errors, so I have tried numerous different p***words.... ANY Help Please???
<6> oh... & it is MySQL4.1.13
<5> dewaard, hold on, I'll build it
<4> D2DChat2: SELECT STR_TO_DATE('Fri, 10 Feb 2006 23:41:51 GMT', '%Y-%m-%d %H:%i:%s'); returns null :-(
<5> dewaard, are the days formatted like 01, 02, 10, 27? or 1, 2, 10?
<5> dewaard, that's not the idea of the function
<6> anyone?
<4> D2DChat2: I don't know :-( I'm writing an RSS reader so the dates come from external RSS feeds I don't control. The sample date was taken from my own RSS feed (http://www.filipdewaard.com/feeds/index.rss2)
<5> SELECT STR_TO_DATE("Fri, 10 Feb 2006 23:41:51 GMT", "%a, %d %b %Y %h:%i:%s") <- like that
<5> that will return a mysql formatted date
<5> I believe anyway, if it doesn't that is the firs step:)
<4> D2DChat2: it returns null as well "(
<7> Someone can help me, I have a Linux with my BD on MySQL and I have an aplication under windows, and I need to make a OBDC connection, so already download the connector and I set the IP and user on the connecter but I don't get both machines talk.. any idea what could be?
<5> dewaard, consider the timezone as well:)
<7> Someone know how to make the OBDC connection?
<8> How do I delete all tables in a database? DROP TABLE *
<9> hello. is it possible to have two masters in a replication setup? i.e. server B gets replicated db1,db2 from server A and server C gets db3 from server A
<9> crap. i said that wrong. server slave gets db1 from server A and db2 from server B
<10> gza: Just drop and recreate the database.
<8> yeah, wanted to avoid doing that but I guess I have to do that.
<8> thanks
<10> gza: Avoid taking the easy approach? :)
<9> I can lookup how if it's possible.. just have not found anything to indicate that it is, yet.
<11> http://hastur.ext.fi:8000/friend-fan.txt - is this even possible with SQL?
<9> hello. is it possible to have two masters in a replication setup that is NOT two way? i.e. server A gets db1 from B, but db2 from C ? THank you
<12> hi
<12> Just wandering where I can get 3.5.1.111
<12> anyone ehre can givem e a hand
<12> I need to turn on allow legacy p***words
<12> I'm looking for a n option allowold p***words
<12> or allowlegacyp***words or something like that in my.cnf /my.ini
<13> I've got two tables, artists and shows. Shows has the artist primary key as a foreign key and has another column containing a date. Is it possible to run a query that returns artists.* and shows.* for the latest show per artist?
<13> "Latest" being in relation to the aforementioned date column.
<10> Elazar: Sure.
<10> Elazar: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
<13> Xgc: Hm... subqueries are supported in MySQL 4 and up, right?
<10> Elazar: 4.1+
<13> D'oh... then that's not an option, unfortunately. :(
<10> Elazar: Temp tables is your other option.
<13> True, though not a preferable one.
<10> Elazar: Your other option is to upgrade to MySQL 4.1 or better or do all the iteration from some external app.
<10> Elazar: Keeping 4.0 leads to all sorts of options which aren't preferable.
<10> But that's your choice to make.
<13> It's not something I have control over. I'm on a shared hosting server.
<10> Elazar: Then you'll need to choose from the available options if upgrading (the preferable option) isn't an option for you.
<13> Looking into a possible upgrade with my hosting provider... sounds like it may be a possibility.
<10> Miracles can come true.
<13> Heh... indeed. Thanks for the tip, though... may end up being able to use it.
<14> if i run a mysql query using php's MySQLi extension, will the results always be returned as a string?
<14> ie: a int field returning as a string instead of an int
<12> Hi I need myodbc 3.5.1.13
<12> a guy from mysqld told me that versin is what I need to fix my problem
<12> 3.51.13
<12> where can I download this
<15> mwright1night: http://dev.mysql.com/doc/refman/4.1/en/basic-myodbc-application-steps.html
<12> DJViper
<12> it doesn't help
<12> cant' find 3.51.13 there
<12> with the SQL fix
<10> mwright1night: If .13 hasn't been released, grab the latest source and rebuild.
<10> or look for a nightly build.
<16> sorry about that got disconnected
<16> i will let you have a look at my php code if you think you can help me with this problem
<16> so ill take that as a no then
<16> ok bye
<17> Hi, I have a newbie question, I have a Table (Tables) and another (TableUpdates), multiple rows in TableUpdates refer to one row in Tables, and I want to do a select where only the most recent TableUpdate row is returned
<18> SELECT <row names, comma delimited) FROM TableUpdates ORDER BY date DESC LIMIT 1;
<18> ***uming you have a date column...
<17> I should of said "only the most recent TableUpdate row for each table is returned"
<17> I want to list every row in Tables and for each table only the last TableUpdate row
<10> gllen: http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
<10> gllen: You probably want to have MySQL 4.1 or better for this. The alternative is to use temp tables.
<19> Hi!
<17> This looks like what I want.. thanks a lot!
<19> i have problems connecting to my mysql database
<10> You're welcome.
<19> using mysql_connect i get this error
<19> Call to undefined function mysql_pconnect()
<19> but i have installed php4-mysql
<19> so, what is the error?
<19> p***word is ok, user is ok
<17> Wow I spent like 5 hours and had some crazy Group code that worked but it took 5+ minutes to run, now it's instant! Thanks again Xgc
<10> gllen: No problem at all.
<19> Xgc: can you help me?
<10> mysqlMan: That's a php setup issue, most likely.
<19> hummmm
<20> Anyway to rollback from one sql query ago?
<10> daniel`js: You rollback from within a transaction.
<10> daniel`js: You can rollback anything that hasn't yet been committed (in this connection/session), generally.
<10> daniel`js: If you haven't committed. Try rollback;
<20> :(
<20> To late
<20> Damn
<20> Ahh well, nothing big was lossed.
<20> Thanks anyways =)
<20> So yer Xgc, remember how I had that awards placement problem?
<10> Sure.
<20> What was the command
<20> That you sent me to?
<20> Cause I attempted at it the day you gave me it...and I still had trouble with it.
<20> But I want to give it another go. =)
<10> daniel`js: Ask the question again.
<20> Alrighty
<20> I have an awards placement section on my website.
<10> Sorry. I was watching some of the Olympics.
<20> I have different awards for different things
<20> Heh, same. :S
<20> Anyways..
<20> I want to find the rank that YOU'RE (or a specific person) is in.
Return to
#mysql
or
Go to some related
logs:
#gentoo
#suse
denu ubuntu
Check PHP even uneven
setting up mysql Suse 10
#linux
#math
centos heartbeat2
#openzaurus
#ubuntu
|
|