| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> worked fine :)
<0> perfect
<0> thanks :)
<0> mysql> select date_format(BillingDate, "%Y-%m-%d") from cf_mvts LIMIT 1;
<0> +--------------------------------------+
<0> | date_format(BillingDate, "%Y-%m-%d") |
<0> +--------------------------------------+
<0> | 2006-01-01 |
<0> +--------------------------------------+
<0> :)
<1> actually, what you really want is just DATE(BillingDate) ...
<0> i forgot how to do a temp table :)
<0> create table abc select col1, col2 from xyz does not seem t work :)
<0> mysql 4.1.12
<1> create temporary table ...
<0> got it :)
<0> i forgot the as
<0> how about non temporary table using selct ?
<1> should work just fine
<0> worked .. i had a typo in the commands
<0> thanks pCarsten and lsmith :)
<2> hi
<2> i have problem
<2> http://pastebin.com/568296 can you tell me why i cannot create table users_groups
<2> #1005 - Can't create table '.\moja\users_groups.frm' (errno: 150)
<2> help\\
<2> :(
<3> kibibyte: using navicat?
<2> navicat?
<2> what is it
<3> kibibyte: navicat is mysql frontend, check this out: http://support.navicat.com/?_a=knowledgebase&_j=questiondetails&_i=67
<2> no its pproblem with foregein keys
<2> help
<3> kibibyte: try googling for: mysql Can't create table errno: 150
<2> i tried
<4> hi
<4> i'm trying to log mysql
<5> i am having a problem seding a test email with errors
<4> all request ... "SELECT, INSERT, ... "
<5> http://www.nomorepasting.com/paste.php?pasteID=58142
<4> i'm using: log=/var/log/mysql_full.log
<4> but mysql doesn't create this file :(
<4> what could happend ?
<1> the user running mysqld doesn't have the necessary permissions to write into /var/log ?
<1> doesn't the error log give you any hints?
<6> !perror 150
<7> MySQL error: 150 = Foreign key constraint is incorrectly formed
<2> archive help
<5> connect to mysql server 127.0.0.1: Host 'clggroup.plus.com' is not allowed to connect to this MySQL server
<8> Hello, I have a tricky question. I've got 4 tables: user, member, cl*** (cl***_id, name) and cl***_user (user_id, cl***_id). Now, a user can belong to many cl***es (cl***_user). If a user belongs to the cl*** "member" (lets say cl***_id=1), I want to fetch all fields from member where member.user_id=user.id. Is this possible in one query, and would it be possible to add more cl***es and "cl*** tables"?
<9> hi all. trying to produce the sql to generate a month / year archive list
<9> tried SELECT id,post_date from posts group by MONTH('post_date') ORDER BY YEAR('post_date') desc, MONTH('post_date') desc --- however, i only get one row returned with that query. post_date is a datetime field
<10> all rows of post_date is of the same month?
<9> no
<9> three separate months
<10> 3 separate months or 3 separate years?
<9> separate months
<10> what are the months?
<9> 2006-03-23 08:12:00 ; 2006-02-21 15:47:00; 2006-01-21 13:33:00
<9> those are the post_date values
<10> the nthe result cannot be 1 row only
<9> well. that's what i'm getting.
<10> you sure, how many rows in your table?
<9> post_date is a datetime field. don't know if that matters
<9> 3
<9> 3 rows. 3 separate months
<11> in the table field i have single quotes as just that, single quotes
<12> Jax: Should this work too: <p><input type="hidden" name="ip" value="<?php $_SERVER['REMOTE_ADDR'] ?>" /></p>
<13> root404 that depends on the server ip.. if the server's ip is in ipv6 format, this will not work so well.
<11> i am also running it thru textilize and truncate
<13> UncleMantis ah and it turns in to a ? when you fetch it from the db ?
<12> I ask because it's not being put into the db.
<13> root404 echo $sql;
<11> yup
<13> UncleMantis how you fetching it ? php?
<11> ooooppps
<11> sorry wrong channel
<11> i thought i was in rubyonrails LOL
<13> haha
<11> ignore the question
<13> that will cost you mate
<13> ! ;)
<12> lol
<12> Jax can I PM you?
<14> rubyonrails was in arears in their rent ... mysql took over the channel
<13> root404 no need to probly?
<12> http://pastebin.com/568616
<12> Should I ask this in PHP?
<12> That's what I have that puts the form submissions into the DB.
<13> well what's the problem?
<13> i mean, any error, or what's happening that shouldn't be
<12> The ip isn't being put it ib.
<12> in*
<12> http://pastebin.com/568626
<12> That's the form
<13> do a echo $SQL;
<13> before the query
<13> so you can see what the actual query is
<12> Nothing is echoing
<15> hello, I need to dump data like name, firstname, email, p***word from one database to another, who can i do that?
<15> how can i do that i wanted to say?
<16> I was in the middle of running a large delete statement, when mysql threw up this error:
<16> 1217: Cannot delete or update a parent row: a foreign key constraint fails
<12> Do you have access to phpmyadmin?
<16> it then took me back to the prompt
<16> but sho processes tells me that the delete is still running
<13> root404 well that's probly the biggest issue ;)
<12> But, it still gets put into the DB!
<12> The other stuff does.
<12> Just not the ip.
<13> if it's not performing the query...
<13> i think i see your problem though.. you wrote: name="url" instead of name="URL"
<13> the php script is checking for $URL
<13> not $url
<17> how would I alter a table to set columns unique?
<15> no one any hint, how to or smth concerning my question?
<12> Jax: add_url($_POST['url'],$_POST['title'],$_POST['notes'],$_POST['ip']);
<13> you are p***ing 4 args to a function that only supports 3
<18> ratschnowski: what does "database" mean in this case?
<13> try adding $IP to the function declaration ;)
<18> INSERT INTO db2.table (firstname, email, pw) SELECT firstname, email, pw FROM db1.table
<12> Duh!
<12> :p
<15> flupps, thx thats what i was looking for, try to work it out
<12> Jax: Hmm.. still didn't add it.
<12> Jax: http://pastebin.com/568650
<15> and how to do a backup of a single table? mysqladmin -pP***wd database.tablname > backup_table.sql ?
<19> is there a way to have punctuacion in a database name? I have tried "create database time_slip;" and "create database time.slip;" but mysql doesn't like those names
<12> Heh, Jax, I had to echo it!!
<20> !man names
<7> (User Variables) : http://dev.mysql.com/doc/mysql/en/Variables.html
<20> !man database names
<7> (MySQL Extensions to Standard SQL) : http://dev.mysql.com/doc/mysql/en/Extensions_to_ANSI.html
<20> !kick SQL
<13> root404 does it work now?
<20> martianlobster: http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
<13> Therion! >;/
<19> Therion: thanks :)
<20> Jax: Let me see!
<12> Jax: Yup.
<13> good
<13> see what Therion
<13> Therion you ever hear anything back from the evils?
<12> Jax: Mind giving me some input on http://insertdomainhere.org?
<12> Without the ?. :p
<19> Database 64 Any character that is allowed in a directory name, except /, \, or . <---- so "time_slip" should be a valid database name?
<13> root404 not sure about the vertical stripes :D
<12> Heh
<13> martianlobster yes it's valid
<12> I'm not sure either
Return to
#mysql
or
Go to some related
logs:
__imp__boxRGBA
#linux
top absolute css ie doesn't work
ubuntu connlimit
#debian
mupe related work
#php
splitp soup
java6 systray kde
suse cpufreq-set
|
|