| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> Hum, it says I have an syntax error in this query:
<0> SELECT * FROM inv_admin_logs LIMIT 5 ORDER BY Date
<1> wooooooo
<1> IT WORKED!!!!!!!!!
<1> IT WORKED
<2> stuff usually does if you don't mess up
<0> lol
<2> so no need to get excited
<1> looooooook
<1> doesn't work again
<1> but it worked!!
<0> What is wrong with the syntax on my query: SELECT * FROM inv_admin_logs LIMIT 5 ORDER BY Date
<2> domas: the star*keylogger thing is basically a DoS attack, and thence I wouldn't be surprised if it was illegal
<3> Apachez, thanks for your help
<4> Alex_C: not sure, but I think your LIMIT clause needs to be the last thing in your statement
<4> s/statement/query/
<1> look:
<1> mysql> select * from b;
<1> +-------+-------+
<1> | x | y |
<1> +-------+-------+
<1> | mysql | rocks |
<1> +-------+-------+
<1> 1 row in set (0.00 sec)
<1> it's so amazing!!!!
<2> uuh
<2> righto
<2> nothing to get excited about
<1> SpComb: why not? :)
<1> now I wonder why it worked
<2> because it was designed to work?
<1> it was not ;-)
<1> ok, I can show you how I created this table
<2> how silly
<2> oh, something more interesting?
<1> CREATE TABLE b (x VARCHAR(255), y VARCHAR(255)) ENGINE=FIFO;
<2> hmm, some twisted stuff
<2> tell me more :o
<1> SpComb: cp ha_example.cc ha_fifo.cc ;-)
<1> I insert in one thread, read in another
<1> woooooo
<1> now I have to find why it doesn't work at the beginning... that is... what do I need to initialize
<1> doesn't work too properly ;-)
<4> domas: race condition perhaps? (one thread tries to read before the other can finish INSERTing?)
<1> codergeek42: naaah
<1> codergeek42: seconds p*** ;-)
<1> and it is in-memory
<5> mysql rocks in-memory ?
<1> sure it does
<6> will, happen to be around? :)
<7> Not anymore
<7> It's the weekend! You want me to work on a weekend?
<0> is it possible to store a $var in memory? So if I set $Var1 = 'hello' on Page1.php, then I redirect to Page2.php and do echo $Var1 it will return 'Hello' ?
<2> sessions are a nescesary evil
<8> hi all - can someone please tell me how I could discover the number of rows that would be returned by a query without actually returning the data?
<8> I need row counts only on m***ive tables.
<9> !man sql_calc_found_rows
<10> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<9> there ya go
<8> thank you :)
<11> hello everyone
<11> can someone please help me? my newly installed apache and php work but I don't know how to get mysql to run
<11> I have a simple script that pulls information from a mysql database that works on my installation of LAMP on windows
<11> sorry... it's not LAMP on windows but I'm sure you know what I mean :)
<12> WAMP?
<11> yeah... WAMP
<11> how do I add the mysql module to apache in linux?
<8> if your php is working - open php.ini and make sure its extensions dir / root points to the php extensions (usually php/ext or php/extensions depending on version) then find the lines that say extension *mysql* (where * is wild) and uncomment them. (a google for "php apache mysql wamp" should find a more detailed how-to)
<11> I think that's my only problem
<12> !google php apache mysql wamp
<10> php apache mysql wamp: http://www.en.wampserver.com/
<11> it's not for windows though...
<11> it's for linux
<11> my php is working
<8> infact I was reading one only yesterday - bookmark =
<8> http://www.thesitewizard.com/archive/php4install.shtml
<11> <?php
<11> phpinfo();
<11> ?> works just fine
<11> cool I will go check it out
<11> I noticed though in my folder with the .so modules that mysql isn't there
<8> then look at the "configuring php" part of the how-to - it should have what you need to connect php to mysql.
<8> did you use the windows installer for php ?
<11> *this is not for windows*
<11> it's for ubuntu linux
<8> Get the zip version and simply extract it over your existing php installation - for some reason the installer doesn't seem to have the right libs.
<8> (oh - then my appologies *blushes* I was sure I read windows up there somewhere)
<13> i'm trying to access my db which i install some time ago and don't remember my root pw, i have root, but ... mysqladmin -u root p***wd can't connect, what should i do?
<11> I said that I could get it working just fine in windows but having a tough time in linux :)
<8> :-) Well I wish I could offer the same help for linux, but I've only ever used distro's where all three were pretty much pre-configured.
<11> I appreciate the help regardless though... :)
<11> Tzuriel, reinstall or bruteforce?
<11> yeah... I wished that it was that easy :)
<12> I installed php 5 once, maybe it was beginner's luck but I got it right the first time
<13> isolate: wow, i'm sure there's a better way than that ... but might be a good time to put 5 on, if only emerge offered it
<11> but it's not :)
<11> using linux?
<12> yes, linux
<8> omg - my sql_calc_found_rows ran out of memory.
<11> bobfield, which version of linux are you using?
<12> slackware 10.2
<11> Tzuriel, there is probably a better way.... :)
<12> 2.4.31 kernel
<11> is that based on debian?
<12> not that I'm aware of
<11> bobfield, did you install everything manually or did you have something like yum, apt-get, or some other "auto" installer install everything?
<12> I install things manually
<12> well I did use the apache that was preinstalled
<11> that's probably my downfall with my current install.
<11> I used apt-get
<11> it installed apache and php beautifully but mysql does seem to want to play
<12> I downloaded php from php.net
<11> do you have any idea what would need to be done in order to get the mysql module recognized by apache? I have gone through the manual but can't seem to find how I would add a module
<12> Just like I downloaded mysql from mysql.com
<12> to my knowledge apache doesn't interact with mysql directly
<12> I only enable php in apache
<12> configured/built php with mysql support
<12> worked like a charm except I forgot to enable mysqli functions
<11> that's what the manual told me to do. this is what it said: " This means that your PHP version isn't compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This is described in detail in the PHP manual."
<11> oh... load it into php
<11> not apache
<12> apache -> php -> mysql
<11> so I need to tell php where mysql is
<11> but how do I do that? :S
<7> php.net/mysql
<12> [php] configure --with-mysql[=dir] --with-mysql-sock[=dir] --with-mysqli[=file]
<12> I got a warning and threw in one other option, I can't remember it
<1> php-config....
<1> ergh, mysql-config
<12> I'm just quoting the help
<12> like I said I forget the mysqli part
<12> I let the dirs default too
<7> You don't want to, actually.
<12> must be beginners luck then
<7> Because there is no default directory. Not specifying a directory tells PHP (in the case of the mysql extension) to use the built in library, which is old.
<11> will, thanks... it looks like I will have to uninstall php and reinstall with mysql support
<7> How did you install PHP?
<7> There are usually packages you can download/install that comes with what you need./
<11> I used Synaptic package installer in ubuntu
<12> gunzip, tar, configure, make
<12> working like a charm so not messing with it
<11> I think synaptic uses apt-get
<11> the down side to using auto-installers is that you can p*** any configuration switches or anything like that
<14> hey guys is it good to start an ID at 0 or 1 ??
<14> if i just want to have it be my index
<11> *can't
<7> minDscrm, What do you ask?
<14> will, i want to have an index for my data... is it good to start the index at 0 or at 1 ?
Return to
#mysql
or
Go to some related
logs:
Philosophae Naturalis Principia Mathematica
No rule to make target * infiniband
#egghelp
super grub img to floppy kubuntu how
selectall_hashref not working
osdev rtc
how to install nerolinux
#linux
rhel4 mysql5
configure-trackpoint deb
|
|