| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<daMaestro> how do i get a date with the time?
<daMaestro> CURRENT_DATE() does not seem to do that
<shabbs> daMaestro: NOW()
<daMaestro> sweet
<daMaestro> thenks
<daMaestro> just read that tool.
<shabbs> s/tool/function/
<gniretar_work> hi all
<gniretar_work> i'm at the mysql page for alter table
<gniretar_work> but i cant figuer out how to add a primarykey
<gniretar_work> ui'm trying this
<gniretar_work> alter table staff add primary key spid;
<gniretar_work> whats wrong with that?
<shabbs> what does it tell you is wrong with it?
<gniretar_work> check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
<gniretar_work> uselessness
<shabbs> !man alter table
<SQL> (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<shabbs> add primary key (spid); try that
<gniretar_work> i'm at that webpage
<shabbs> well, what you had, just with ()
<gniretar_work> it works
<gniretar_work> error though
<gniretar_work> cuz i just created the column and its a bunch of 0's
<gniretar_work> how do i set the auto incrament bit?
<shabbs> drop the column and readd it as 'spid bigint not null auto_increment'
<gniretar_work> k
<shabbs> could even add unsigned onto that if you really wanted to
<gniretar_work> yes, should be unsigned
<murdoc> I got a quesiton
<murdoc> lets say I setup a table with 3 columns ... Column 1) id 2) username 3) p***word
<murdoc> how can I manipulate it so that when someone tries to login from a browser, the php file would check for the username and p***word from the able to see if it matches with any user on the list?
<tesz111> is it posible to get not the first 10 query results? i make a query, it returns me alot of results... but i need results that gues after first 5 ones.
<tesz111> i mean after 10
<sean_micken> i killed this "check table" on a table i do not care about and the processlist shows it as Killed, but it's taking forever to release and let me kill it
<sean_micken> the next thing imma do is drop it, so.. ;p
<daMaestro> what field type do i have to use to be able to use NOW()?
<tesz111> so is there a way to get query results that goes after first 10 query results that i simply need to skip? :/
<sean_micken> LIMIT
<sean_micken> tesz111: pull the first 10 or skip the first 10?
<tesz111> ty
<tesz111> skip
<woozy> )
<tesz111> to get like queries from 10 to 20 while there can be about 40
<tesz111> results
<tesz111> ;]
<tesz111> ty for info - google next ;]
<daMaestro> if i set the function of a field to be now()... what does this do?
<daMaestro> do i then not need to send a date when i make changes?
<tesz111> and one more thing... is it posible to make the result be sorted by something? (like numbers)
<slid3r> hiya, I am wondering ...I am trying to get back comments from a table now ... if multiple comments are made on the same image, well the table has 3 columns imageID, imageName, and comment ... I want to do something like: select * from comments where imageName='$image'";
<slid3r> but I am almost certain that will throw an error
<sean_micken> is innodb data stored in ibdata1 ? i dropped the only innodb table i had, yet that file is still really big...
<slid3r> so basicaly, theres an image, you can comment on it, the db will take in a new commentID (auto increment key), the name of the image, and the comment
<slid3r> if I want to return all the comments for that image
<slid3r> whats the best way to do it
<slid3r> thats a better way to ask my question I guess
<daMaestro> DATETIME not DATE
<Cvbge> slid3r: why would the select you posted throw error?
<tesz111> slid3r: i think your query is ok
<slid3r> ok
<slid3r> so
<slid3r> its just gonna return all the comments anywhere the imageName matches?
<tesz111> should
<slid3r> hmmm, how will I know where one ends and another begins
<tesz111> u get them by one
<Cvbge> You will get multiple rows
<slid3r> oh
<slid3r> nice
<slid3r> that solves my php question
<slid3r> thank you
<tesz111> how do i make my results be sorted before getting them returned?
<tesz111> select results
<slid3r> good ol mysql_fetch_row
<Cvbge> Using ORDER BY
<tesz111> how does it act with case sensetivity?"
<tesz111> and numbers
<tesz111> with numbers i gues okey..
<tesz111> but with letters
<tesz111> i mean aa, AA, Aa, aA
<tesz111> can i make it return (AA, Aa, aA, aa) or (aa, aA, Aa, AA, bb, bB, Ba, BB..)
<FreeOne3000> It's case sensitive...
<Garf> http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
<Garf> The string pointed to by from must be length bytes long.
<Garf> would that be including the terminating zero or without
<Garf> also, can I cheat and just send the size of the buffer (and ignore fact that the string may actually be a lot smaller)
<jooshu> when installing the 5.0 in linux without rpms how do i specify that i want the data directory in /var?
<jooshu> everything defaults to /usr/local?
<Stork> hi, i keep getting errors while trying to connect to mysql using the jdbc mysql drivers. my error is this on connection: Data source rejected establishment of connection, message from server: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
<Stork> i'm running out of ideas
<runnerke> Anyone know why MySQL crashes when using cluster mode and just typing 'use mysql' ?
<Stork> bleh
<tesz111> Stork: try launching mysqld_safe
<sean_micken> how do you complete delete an innodb table?
<sean_micken> *completely
<Stork> tesz111, mysqld_safe[6472]: A mysqld process already exists
<tesz111> stop mysqld and then try mysqld_safe
<tesz111> couse for some reasons i get to connect to mysql server only when i launch through mysqld_safe... no clue why, but it works :)
<tesz111> in my case: /etc/rc.d/./rc.mysqld stop && mysqld_safe
<tesz111> so i just chmod -x /etc/rc.d/./rc.mysqld && echo "mysqld_safe" | /etc/rc.d/rc.local
<Stork> erm
<Stork> alex@ubuntu2:~$ sudo mysql
<Stork> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<tesz111> check if your mysqld.sock is there
<Stork> it isn;t
<tesz111> then find where it is
<Stork> i don't know
<tesz111> and edit your /etc/my.cnf by setting the correct patch
<Stork> i'm guessing there isn't one
<tesz111> what config file you use?
<anoeromos> hello.can someon tell me how can i skip columns with load data infile?My file has itemID,itemGroupID,ItamCategoryID,IsPrivate and table itamID,ItemGroup,IsPrivate.Is there any way to skip iscategoryID ? :}
<tesz111> and how did you set your mysql
<tesz111> anoeromos: can't you select only those columns that you need?
<Stork> nevermind i fixed it
<Stork> but i still can't get my mysql to work with my program :*
<anoeromos> you can select columns if the columns in table are more from the columns of the file
<tesz111> Stork: what was wrong? and no ":*" to me ;)
<Stork> :p sorry
<anoeromos> now it will load itemcategoryID in ISprivateLabel place
<Stork> well, the error it gives me is: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
<anoeromos> the 3rd one with the 3rd :(
<Stork> so i open phpmyadmin, look at mysql, look at the table users
<tesz111> oh... got it
<Stork> then change the hostname of root
<Stork> to %
<Stork> do i need to restart mysql after doing that?
<tesz111> nop
<Stork> or am i doing something wrong?
<tesz111> no needed to restart
<Stork> so that's it?
<Stork> it didn't work though
<Stork> i still can't access it
<tesz111> i'm off to bed... try the following: setting/unsetting p***words in users table, connecting with mysql -u root -p, stoping mysqld and launching mysqld_safe, good luck
<ctrl-alt-suppr> hi
<ctrl-alt-suppr> anybody could help me about regexp in mysql?
<GaryKing> How do I make it so that I can type 'mysql' anywhere in bash and it will know that I am referring to the mysql program?
<GaryKing> I get: "-bash: mysql: command not found" when I type a mysql command.
<tesz111> what OS GaryKing ?
<tziku> help: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" ; in /etc/init.d/ is no mysql . Help me (Debian 3.1)
<NeoThermic> !perror 2
<SQL> System error: 2 = No such file or directory
<Stork> so confused.
<Stork> !error
<tziku> invoke-rc.d: unknown initscript, /etc/init.d/mysql not found.
<GaryKing> tesz111: Mac OS X
<tesz111> want ubuntu cd formac os x for free? ^^ :D
<GaryKing> tesz111: Eh? :S
<GaryKing> oh wai tI think I got it
<Darien> tziku: you should install the server probably
Return to
#mysql
or
Go to some related
logs:
#math
#physics
xchats ubuntu
#debian
#linuxhelp
unsupported compression method 99 ubuntu
#linux
structure of ibubrophen
#centos
mplayer libGL.so.1 gentoo xorg 7
|
|
