| |
| |
| |
|
Comments:
<0> K_F if youre storing user details for them to login to a website, would you make id primary key, or username?
<1> an auto-incremental id
<0> ive got that yea
<0> id int(6) NOT NULL auto_increment primary key
<1> NOT NULL is implied
<0> but everything is going to be based on username within the site
<1> Advocated: that is a bad idea for several reasons
<1> 1) storage
<1> <1> Advocated: that is a bad idea for several reasons<1> 1) storage
<2> ahh, so best to keep id as pri?
<3> hello, a simple question: how can i pause with a command line a long table in mysql?
<1> ?
<1> pause?
<1> http://www.catb.org/~esr/faqs/smart-questions.html might increase your chance of getting a, in your perspective, positive response.
<3> thanks, Mr K
<3> the problem is that I type "Describe" a table, but the PC shows a long table... in DOS you can use DIR/W/P... but it does not work in mysql
<1> rofl
<1> you my be really stupid
<1> and it is dir /w /p
<1> the /p does what you describe, pagination
<1> not that it has anything AT ALL to do with mysql
<3> thanks, i will do it...
<1> do what?
<1> load it in DOS?
<1> and that is the solution you know
<1> tee the output to a file
<3> eh... ok, i will learn how to output...
<3> thanks
<4> wow he probley thinks that for a flat tire he need to get the road re-surfaed
<1> Eldritch: jup
<1> this machine is fun right now
<1> running GNU/Linux as host and Windows XP and Windows 98 as virtual machines
<4> for a broken leg, vist your accountatn
<4> win98 is my os, im mad
<1> ?
<1> top - 23:35:57 up 11:34, 1 user, load average: 4.69, 2.26, 1.38
<1> seen worse thoug
<1> though*
<5> there is a way to know how is connected to a database ?
<5> who*
<4> SHOW PROCESSLIST
<1> and you find it in the manual
<1> damn you Eldritch
<4> ha!
<4> i just like to prove i know *something* now and again
<4> K_F how do i ping a specific port
<1> ping a port?
<1> that is a first
<3> thanks for your help folks!
<1> sure, you're welcome
<1> ping uses the ICMP protocol's mandatory ECHO_REQUEST datagram to elicit
<1> an ICMP ECHO_RESPONSE from a host or gateway. ECHO_REQUEST datagrams
<1> (``pings'') have an IP and ICMP header, followed by a struct timeval
<1> and then an arbitrary number of ``pad'' bytes used to fill out the
<1> packet.
<3> now i have learned TEE...
<1> good for you
<4> ok so i cant
<1> Eldritch: that would be the general interprentation
<3> haha, thanks and pls help again if necessary to a newbie... Thanks a bye!
<4> so how can i spank the port in to responding to me
<6> how can i install mysql on linux debian based distro "ubuntu"?
<7> hello
<7> need help to move web site to new server
<7> mysql database
<7> There is another database on my virtual dedicated sever that has the same name as the one that I am trying to migrate.
<7> anyone there?
<8> hello
<8> can anyone help me, ive been running a mysql server on my pc here for local development. i need to back up the data as im reloading the server, does anyone know how i can go about backing up the data
<8> so i can import back when ive reloaded
<8> this is on win32 btw
<0> i use the command prompt for entering mysql etc, and creating tables and such, is there any such programs, or a way to do it with mysql, that it logs everything ive ever typed in?
<0> and is there a way to find out what way the date is set in mysql? as i know its different for some, is it yyyy-mm-dd ?
<9> show variables like 'date_format';
<0> has mysql got a timeout? ie if you dont enter a command into the mysql command prompt after a certain time, it crashes/doesnt allow any more information to be inserted?
<0> as ive left mine for a bit, done a query, and its just hanging there
<10> can someone help me with schema indicies please
<10> should one be created for every forign key ?
<10> anyone ?
<4> K_F - awake?
<11> evening
<1> Eldritch: yeah
<11> K_F evening
<1> heya
<11> sup
<1> trying to get the new server to work
<1> having problems with the email
<11> llinux?
<1> yeah
<1> qmail && vpopmail with a mysql backend
<1> the problem is getting spam******in and clamav to work
<1> permission problems.
<4> oh hwy i was going to ask for a better way than this: http://paste.sqlwhores.com/?425 but im not fussed if your busy
<1> it is the replacement of the server that crashed last week
Return to
#mysql
or
Go to some related
logs:
MIRC deatils
#javascript
#chatzone
#php
#c++
microsoft typeof c++ decltype auto
kurdscript
Hot Angelia Jollie
#php
#linux
|
|