| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> how do i get a date with the time?
<0> CURRENT_DATE() does not seem to do that
<1> daMaestro: NOW()
<0> sweet
<0> thenks
<0> just read that tool.
<1> s/tool/function/
<2> hi all
<2> i'm at the mysql page for alter table
<2> but i cant figuer out how to add a primarykey
<2> ui'm trying this
<2> alter table staff add primary key spid;
<2> whats wrong with that?
<1> what does it tell you is wrong with it?
<2> check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
<2> uselessness
<1> !man alter table
<3> (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<1> add primary key (spid); try that
<2> i'm at that webpage
<1> well, what you had, just with ()
<2> it works
<2> error though
<2> cuz i just created the column and its a bunch of 0's
<2> how do i set the auto incrament bit?
<1> drop the column and readd it as 'spid bigint not null auto_increment'
<2> k
<1> could even add unsigned onto that if you really wanted to
<2> yes, should be unsigned
<4> I got a quesiton
<4> lets say I setup a table with 3 columns ... Column 1) id 2) username 3) p***word
<4> 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?
<5> 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.
<5> i mean after 10
<6> 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
<6> the next thing imma do is drop it, so.. ;p
<0> what field type do i have to use to be able to use NOW()?
<5> so is there a way to get query results that goes after first 10 query results that i simply need to skip? :/
<6> LIMIT
<6> tesz111: pull the first 10 or skip the first 10?
<5> ty
<5> skip
<7> )
<5> to get like queries from 10 to 20 while there can be about 40
<5> results
<5> ;]
<5> ty for info - google next ;]
<0> if i set the function of a field to be now()... what does this do?
<0> do i then not need to send a date when i make changes?
<5> and one more thing... is it posible to make the result be sorted by something? (like numbers)
<8> 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'";
<8> but I am almost certain that will throw an error
<6> is innodb data stored in ibdata1 ? i dropped the only innodb table i had, yet that file is still really big...
<8> 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
<8> if I want to return all the comments for that image
<8> whats the best way to do it
<8> thats a better way to ask my question I guess
<0> DATETIME not DATE
<9> slid3r: why would the select you posted throw error?
<5> slid3r: i think your query is ok
<8> ok
<8> so
<8> its just gonna return all the comments anywhere the imageName matches?
<5> should
<8> hmmm, how will I know where one ends and another begins
<5> u get them by one
<9> You will get multiple rows
<8> oh
<8> nice
<8> that solves my php question
<8> thank you
<5> how do i make my results be sorted before getting them returned?
<5> select results
<8> good ol mysql_fetch_row
<9> Using ORDER BY
<5> how does it act with case sensetivity?"
<5> and numbers
<5> with numbers i gues okey..
<5> but with letters
<5> i mean aa, AA, Aa, aA
<5> can i make it return (AA, Aa, aA, aa) or (aa, aA, Aa, AA, bb, bB, Ba, BB..)
<10> It's case sensitive...
<11> http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
<11> The string pointed to by from must be length bytes long.
<11> would that be including the terminating zero or without
<11> also, can I cheat and just send the size of the buffer (and ignore fact that the string may actually be a lot smaller)
<12> when installing the 5.0 in linux without rpms how do i specify that i want the data directory in /var?
<12> everything defaults to /usr/local?
<13> 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"
<13> i'm running out of ideas
<14> Anyone know why MySQL crashes when using cluster mode and just typing 'use mysql' ?
<13> bleh
<5> Stork: try launching mysqld_safe
<6> how do you complete delete an innodb table?
<6> *completely
<13> tesz111, mysqld_safe[6472]: A mysqld process already exists
<5> stop mysqld and then try mysqld_safe
<5> couse for some reasons i get to connect to mysql server only when i launch through mysqld_safe... no clue why, but it works :)
<5> in my case: /etc/rc.d/./rc.mysqld stop && mysqld_safe
<5> so i just chmod -x /etc/rc.d/./rc.mysqld && echo "mysqld_safe" | /etc/rc.d/rc.local
<13> erm
<13> alex@ubuntu2:~$ sudo mysql
<13> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<5> check if your mysqld.sock is there
<13> it isn;t
<5> then find where it is
<13> i don't know
<5> and edit your /etc/my.cnf by setting the correct patch
<13> i'm guessing there isn't one
<5> what config file you use?
<15> 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 ? :}
<5> and how did you set your mysql
<5> anoeromos: can't you select only those columns that you need?
<13> nevermind i fixed it
<13> but i still can't get my mysql to work with my program :*
<15> you can select columns if the columns in table are more from the columns of the file
<5> Stork: what was wrong? and no ":*" to me ;)
<13> :p sorry
<15> now it will load itemcategoryID in ISprivateLabel place
<13> well, the error it gives me is: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
<15> the 3rd one with the 3rd :(
<13> so i open phpmyadmin, look at mysql, look at the table users
<5> oh... got it
<13> then change the hostname of root
<13> to %
<13> do i need to restart mysql after doing that?
<5> nop
<13> or am i doing something wrong?
<5> no needed to restart
<13> so that's it?
<13> it didn't work though
<13> i still can't access it
<5> 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
<16> hi
<16> anybody could help me about regexp in mysql?
<17> 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?
<17> I get: "-bash: mysql: command not found" when I type a mysql command.
<5> what OS GaryKing ?
<18> 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)
<19> !perror 2
<3> System error: 2 = No such file or directory
<13> so confused.
<13> !error
<18> invoke-rc.d: unknown initscript, /etc/init.d/mysql not found.
<17> tesz111: Mac OS X
<5> want ubuntu cd formac os x for free? ^^ :D
<17> tesz111: Eh? :S
<17> oh wai tI think I got it
<20> 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
|
|