| |
| |
| |
|
Page: 1 2
Comments:
<0> can I just update a record and set the previous record value plus my own new value? like Update table set column=column&'new added own value of text'
<0> ciao bella noca
<0> If i update number field and want to add +15 to the existing number i use: UPDATE TABLE SET number=number+15 , i don't know the syntax for adding more text in a longtext column to the existing text in that column ?
<1> hello.. i have some relational databases. i need content from several different tables when i'm displaying pages in the browser.
<1> is it BAD to have 3-4 SELECT's for ever page generated?
<1> or is it no prob?
<2> JOIN / UNION
<3> This may be a beginners question. I have purchased a software and it is asking me to run database.sql script on MySQL server to create necessary tables. How do I run MySQL server of my hosting company to create tables?
<3> May be this is a stupid question, that's why no one is answering???:'(
<4> is you sql file creating the database also?
<4> or just the tables?
<3> No
<3> Just tables
<4> know about the command line tool "mysql" ?
<3> Yes on my local computer
<3> But not on my host server
<4> why not?
<3> How do I access the host computer's command line?
<4> use -h HostName
<4> as an argument to mysql
<4> as well as -u username -p and so on
<3> For example if the site name is example.com
<3> I can only access the cpanel of the host site
<4> then you'd use "mysql -u username -p -h example.com DBName < database.sql
<3> My question is, where do I type them? May be a very foolish question
<4> same place as you type then for your local computer's MySQL server?
<4> ***uming you have access to it..
<3> But the remote computer is sitting miles away, How do I type the command line on that?
<4> what kind of access do you have to that computer ?
<3> ftp
<3> cpanel
<4> any command line ?
<5> phpadmin
<3> let me look one minute
<5> betsy .thats also my problem
<3> user/local
<3> user/local/zend
<3> something like that
<3> Is that the one
<3> There is mysql socket path
<3> mysql_includepath
<3> Does that tell you something SiMmM-
<3> wocarlo, so we are in this together
<3> SiMmM-, anything that I can do??
<5> betsy_r http://www.navicat.com/index.html you can try this ..
<5> for gui interface of mysql
<3> I have already lost money on this software
<3> Now buy another software to run this software???
<5> no
<5> i thought cpanel also had it...why buy
<3> Navicat ? No
<5> forget navicat
<5> cpanel already had its gui to administer mysql
<5> am i right..
<3> Yes I can create database and tables using cpanel
<3> Also I know how to create database and tables using php
<3> But this software instruction reads as follows
<3> Upload the files to root html folder
<3> Execute database.sql script on MySQL server to create necessary tables
<5> ok
<5> then
<5> what
<3> How do I do that
<3> *OPEN THE FILE AND ENTER YOUR DATABASE NAME FIRST!
<3> Modify config.php file and set the following variables:
<5> i guess we need to create a file database.sql
<3> I have it already
<3> Does it mean that I run config.php?
<3> The instruction language ****s
<5> brb
<3> May be that is what they want, create a database and then run config.php
<6> I have a bit field and when I try to insert a value of 1 or '1' for it it gives me an error '[MySQL][ODBC 3.51 Driver][mysqld-5.0.17-nt]Data too long for column 'active' at row 1'
<6> anyone??
<7> access denied to user@host using p***word yes even if user@localhost is already in mysql db users table. what gives?
<7> anyone?
<8> is there anyway to get the "AM PM" to the lowercase "am pm" in mysql without having to use the "%r" for the seconds, i checked, http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html doesn't have anything, You can do it in lowercase but you need the %r
<8> right now i am useing the %p, which makes them uppercase
<9> look at the string functions
<8> according to this it say "none" http://www.eltcalendar.com/stuff/datemysqlphp.html
<8> meaning, can't be done, i guess without the second increments
<10> how can i cancel a query written on multiple lines in mysql monitor ? (CTRL+C exits mysql monitor)
<11> \c
<11> itworks u can to LOWER(FUNC())
<11> as K_F said
<8> i need a coffee with a shot of scotch in it
<11> s/can/can try/;
<8> LOWER(FUNC()) ? how?
<8> wont that bring everything to lowercase?
<11> like LOWER(DATE('somestuff', `Field`))
<11> yes it will
<8> i don't want that
<8> just the am/pm
<11> you can concat the am/pm lowercase'd
<11> or if you use php just i.e. str_replace
<8> concat
<11> yes, CONCAT(DATE('everythingelse'), LOWER(DATE('pmformat')), DATE('everythingelsemore'))
<11> thou it'll slow you a bit
<8> ahh, i will just use .php
<12> could do a replace as well..
<12> not that I really see any point to all this
<11> oh, yeah, damn
<12> but yeah $string = str_replace(array("AM","PM),array("am","pm"),$string); should do
<12> so, who want to learn about OpenPGP?
<11> this reminds me, i haven't read the site you gave me yet
<12> which one was that?
<12> hmm, if it is OpenPGP related I guess it is http://www.secure-my-email.com
<11> yeap
<12> send me an email at the uid of 0x6b0b9508 if you want to test it out :)
<11> okay, will do that :)
<11> when my launch break comes
<9> English.
<13> some online?
<13> could someone hlep me repair a mysql database?
<14> hi
<13> hy
<14> anyone got any experience of mysql/radius?
<9> what is that?
<14> authentication server... freeradius is the most popular OS version
<9> never heard of either mysql nor radius
<9> please inform me
<14> errr... this is the mysql channel?
<9> I don't know. is it?
<14> I reakon... :-)
<9> ASK A GOD DAMN REAL QUESTIOn
<14> Has anyone here setup mysql to be used as the backend for a radius server?
<13> K_F could you pls help me?
<13> !!!
<14> before I bore you all with the error messages I just want to acertain of anyone is familliar with using mysql as a backen to free radius.
<13> I'm not...
<14> thanks... well thats that question answered... :-)
<13> jono_ could you help me?
<14> whats up?
<14> K_F; you still pondering the meaning of a channel?
<13> I have mysql database
<9> ask a god damn mysql question and you might get an answer
<9> and gh0stsplace , imbecile, we heard that already
<14> Did you get out of bed the wrong side this morning?
<9> not really,no, I'm in a particulary good mood
<14> yes... it shows :-)
<13> K_F oh.. your a hard motherfucer behing you computer..
<14> yes....
<14> spose I'll check on "freeradius" instead then...
<9> you still haven't asked a real question
Return to
#mysql
or
Go to some related
logs:
#AllNiteCafe
#php
fannyrider
#MissKitten
#c++
lc3 most significant 8-bits.
failed to initialize glx gentoo
use mysql_pconnect on php 5
#chatzone
colatapins
|
|