| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> its choking on `cycle`
<1> bbtech: what on earth are you trying to do?
<0> and update :)
<0> just incrementing a date
<1> bbtech: by how much? +'interval'? Why would you add a string to a date?
<0> `interval` is a column in the table
<2> inviso : True, but I want to see how many Free POints and how many Non-Free points a single user has.
<1> bbtech: oh, sure. My bad
<1> !man date_add
<3> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<1> bbtech: full error please
<0> Invalid query: 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 'cycle`) WHERE `clientID`='1'' at line 1
<4> you need a comma before hand
<4> that suppose to be 3 columns right?
<1> bbtech: version of mysql?
<0> Tenkawa: no two
<2> inviso : This is what I have though. Table 1 stores a person's points (without debits/credits given by support staff). Table 2 lists the debits credits to that account. So I want to SUM up the debits/credits, and add those to the points from table 1.
<4> ahh ok.. my bad
<0> mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i686)
<2> inviso : SO the end number will inlamans terms be the Total accumulated to date, less debits/credits.
<5> bbtech: not sure the _type_ in INTERVAL can be an expr....
<5> i.e you can do Interval `interval` DAYS
<0> ahh, ok, I'll try that
<6> does mysql store database information anywhere other than the .frm files?
<6> i lost a table due to some weird innodb error, and it wont let me recreate it
<0> oh, wait..
<6> but i was able to create it in a new database name.
<0> it might not be days
<0> could be days,months,years...thats why I was trying to use `cycle`
<1> bbtech: yep, interval is fine as an expression, but cycle is not
<5> bbtech: Well, looking at the grammar, it has to be a _symbol_
<5> So you'll have to dynamically do the query, for example with a CASE statement.
<1> bbtech: and 5.0 doesn't change that requirement
<0> ok, thanks for the help
<2> inviso : So is it not fair to join them then? For each player SUM his points, then minus his debits/credits from another table, so the end number is their current points.
<7> i cant wait to get on mysql5
<7> have their been any major security flaws yet?
<1> somePriest: It still looks like two distinct questions. Without subselects, you're out of luck
<1> winmutt: not afaik
<7> what languages can you write triggers in? plsql pgsql?
<1> pwndsql
<2> inviso : Ok, thank you.
<8> winmutt: sql:2003
<7> lsmith: what is that?
<8> the syntax specified by sql 2003
<9> in a DATETIME field... it defaults to 000000 00:00.00 or whatever it does..... can I just compare that to 0
<9> ?
<9> sorry...
<7> tac: no its null in most cases
<7> not all
<9> well in the field its all those zeros.....
<10> Hi
<4> hi
<10> I've got 2 tables: categories and domains. A category has many domains. I want to select all categories with one randomly choosen corresponding domain for each category. How can I do that?
<11> select categories.name from categories inner join on domainLink=domainID ORDER BY RAND() LIMIT 1
<11> err that wouldn't give you all catagories though
<11> so you might have to do 2 queries or a subquery
<9> I can't get the query to let me select by date=0
<9> :(
<10> yes I though of a subquery but never do that. What would it gives ?
<11> in your subquery you select a random domainID
<11> then in your main one you would pull all catagories from that
<9> wow im an idiot....
<10> is this something like: SELECT c.*, d.name FROM categories c, domains d WHERE domains.id = (SELECT id FROM domains ORDER BY RAND() LIMIT 1)
<12> Is php5-mysqli a superset of php-mysql?
<13> no
<12> oops... Is php5-mysqli a superset of php5-mysql?
<13> but that's a PHP question
<11> YogSothoth: ya
<11> mysqli is another library thats made for 4.1
<10> Jy, thanks I try that
<11> you can either compile in mysql or mysqli
<12> Thanks sjrussel
<12> jy, I've mysql 4.1, php5 and php5-mysqli which seems to be working. I've phpMyAdmin which also seems to be working, although it complains that it cannot load mysql extensions.
<11> you gotta edit the phpmyadmin config to use mysqli
<14> Please help I did't seen this before http://hashphp.org/pastebin.php?pid=6174
<14> but database is copied ok
<10> Jy, MySQL tells me that the domains table does not exists. Which of course is not true. The error is from the subquery. Why?
<14> mysql> select * from STATE;
<14> ERROR 1017: Can't find file: 'STATE.ISM' (errno: 2
<14> what i should do_
<14> i use mysql 3.22
<15> touch STATE.ISM
<15> ok, don't do that.
<1> !perror 2
<15> upgrade, for one. but to solve your immediate problem, I am not sure.
<3> System error: 2 = No such file or directory
<11> YogSothoth: you are matching domains.id against the domains table
<16> !perror 1337
<14> inviso but i copied database
<11> you have to have some kind of foriegn key to link the categories table to the domain table
<16> !perror 500
<1> SpComb: SQL doesn't like you
<16> :(
<1> heh, snubbed by SQL. That's sweet
<10> Jy, sorry that was caused by WHERE domains.id = which should be WHERE d.id =
<11> no
<11> look here is an example from a db i have
<11> select tmax_f FROM forecast WHERE userLink=(SELECT userID FROM users WHERE userLink<6 ORDER BY RAND() LIMIT 1);
<10> Jy, the query is now correct but returns no record
<11> userLink is a col in the forecast table that matches to the users.userID col
<10> ok!
<12> Jy: So the mysql and php levels are ok, I need to look into the configuration of phpMyAdmin, right? I did a quick check didn't see anything. But at least now I know which documentation to search. Thanks much
<11> that will select a all the tmax_f rows from a random user
<11> $cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension
<11> to use ('mysql' or 'mysqli')
<11> thats in the config.inc.php
<14> what should I do
<13> well, first of all you shouldn't be using 3.22
<13> and you shouldn't be using ISAM tables
<14> why>
<12> Jy: I'd scanned it without spotting it... knowing exactly what I'm looking for certainly works real well!!
<12> Jy: Thank you very much for your help
<11> np
<13> because 3.22 is way too old, and ISAM isn't as good as MyISAM
<10> Jy, I tried to follow your example but I can't manage to make it work to my case. Here's my actual code: http://pastebin.com/548830
<13> at least use 3.23, the last stable 3.x release
<13> but, it looks like the table doesn't exist
<13> did you delete it by accident?
<13> or it could be a permissins issue
<17> good night everybody.
<18> guys
<18> brand new install
<18> [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
<18> i did run the install script... what am i missing? :) thanks
<18> trying to go through the steps of running 2 parallel dbs on one server, one mysql 4, other is 5
<18> just installing this on a test box for now
<18> modifying my.cnf and mysql.server startup scripts
<19> hello
<19> I keep receiving this error: ERROR 1045: Access denied for user: 'root@localhost' (Using p***word: YES)
<19> I've tried everything I could find online
<19> To change root p***...etc
<19> Nothing is working
<19> MySQL version 4.0.25-0
<19> Could someone please help?
<20> What is the situation? Did you just install it?
<19> Well, yeah I just ran another install using cpanel
<19> I've had this issue for days and I've been trying to resolve it
<21> I have
<20> i'd suggest re-starting it with --skip-grant-tables and resolving the p***word issue
<19> mysql 9230 0.0 1.0 30648 10660 ? S 14:19 0:00 /usr/sbin/mysqld -u mysql --skip-grant-tables
<19> It isn't working.
<18> any help guys?
<21> I'm trying to setup my table relationships and would like some feedback. I have two entities: client and employees. each employee can have tags (like: "customer service", "***istant", "stupid"). clients can have tags as well: ("good payer", "loyal", ...) more than one tag can be applied to each entity.
<21> http://tinypic.com/view/?pic=ngx8o4
<21> would that work?
<21> i know it would work,but is that the best way to do it
<21> so a client can be a "good payer" and "loyal"
<20> what isn't working?
Return to
#mysql
or
Go to some related
logs:
#linux
#suse
suse-gnome smart repo
bash script in a single line
install madwifi driver just use yum
DRIVER GW905A
sources.list ktorrent
kingpin ebuild
gentoo eth0 billionton
#ldap
|
|