| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> well, best of luck
<1> lol... for real this time? :-p
<1> nite
<1> !m zaydana insert
<2> zaydana: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<3> sneezes
<4> hey all
<4> I have a line on create table : range varchar( 50 ) NOT NULL default '',
<4> but then mysql complain about : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range varchar(50) NOT NULL default '',
<4> percent float(10,2) NOT NULL DEFAULT ' at line 3
<4> anyone have idea why ?
<5> have you tried "DEFAULT '' NOT NULL" ?
<4> trying, wait :)
<4> changed, another error: plan int( 2 ) NOT NULL AUTO_INCREMENT DEFAULT '0',
<4> #1067 - Invalid default value for 'plan'
<4> should I use default null rather than default '0' ?
<5> plan int(2) DEFAULT 0 AUTO_INCREMENT
<5> oh wait
<4> ?
<5> you cannot have a default on an auto_increment column you goose :P
<5> it would make no sense
<5> so
<5> plan int(2) AUTO_INCREMENT
<5> also int(2) might be a bit restricting for an auto_increment column
<4> right, hmm
<5> i would expect that it would need to be an int
<5> also you should use something like tinyint instead of int(2)
<4> heh ?
<4> tinyint() ?
<5> just tinyint i think
<5> ***uming that mysql supports that one :P
<5> which it may not do
<5> i get confused with all the database engines :$
<4> hehehe
<4> you got to hate this
<4> range varchar( 64 ) NOT NULL ,
<4> any problem with this again ?
<4> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range varchar(64) NOT NULL,
<4> percent float(10,2) NOT NULL ,
<4> PRIMARY KEY (' at line 3
<4> any idea ? andrewbryson
<5> is range a valid name for a column ?
<5> what happens if you enclose it in backticks ?
<5> the column name i mean
<5> also is float a valid data type ?
<4> hmmm
<4> is there have a tool that convert all mysql 3.x syntax into 5.x ?
<4> it's anonying to convert it by hand
<5> it should just run mostly
<4> I try 'range' varchar(64) NOT NULL DEFAULT '',
<4> not working
<5> ' is not the same thing as `
<5> ` is a backtick
<5> ' is not
<4> I see
<4> it seems working now,
<5> :P
<5> well there you go then :P
<4> so default can not mix with autoincrement ?
<4> # Host: localhost
<4> # Generation Time: Nov 11, 2003 at 11:56 AM
<4> # Server version: 3.22.27
<4> # PHP Version: 3.0.18
<4> # Database : as2008
<4> that explain more than a ****
<4> andrewbryson: so default '' can not mix up with autoincreament ?
<5> you cannot have a default if you have an auto_increment on the same column
<5> it would make no sense
<4> hey
<4> http://dev.w3.org/cvsweb/perl/modules/W3C/Rdf/bin/RdfObjects.mysql?rev=1.6
<4> id int(10) unsigned DEFAULT '0' NOT NULL auto_increment, <--- how is this happening then ?
<5> it should not be :P
<4> LOL
<4> what is unsigned means ?
<6> DO YOU FIND THAT **** HUMOROUS, BITCH?
<3> later all
<7> with a mysql cluster, is there any reason to not run a management node on the same system as a data node?
<8> Can someone tell my what this script in rc.local is missing? http://livenudefrogs.com/~anubis/servers/apache_perl_mysql_chroot.shtml
<8> the mysqld starts then immediately stops
<9> I got all privileges for db foo. What privileges do i need to create view in that db, but in view i want to use tables from db bar?
<8> chroot'd apache and mysql ****
<10> hi room , can anyone tell me what command i use in SSH to set access level for external access of mysql database
<10> i want to set it so i can access the database through dreamweaver but the currently it doesnt have the right privileges
<10> im not a use of SSH and i havent been able to successfully google it
<10> i currently have a SSH window open and there a curson flashing after the #
<8> ssh is just like you're sitting at the box
<8> although you might have to su to get access to change user rights
<10> im logged in as root
<10> what would i need to type in to grant all priviliges to the user of the database in question
<8> I've got 3 weeks experience and I can't even get mysql to run in chroot apache
<8> lol
<8> you'd have to modify the user table of the mysql db
<8> ;)
<11> chrooted apache should have no bearing on mysql
<11> since connection to mysql is by a well-known socket
<11> have you verified mysql daemon is running ?
<8> yeah, and I've ln the sock to apache chroot/blah/blah and the libraries, and I can access the db through ssh or box, but not through php
<8> php doesn't see it
<11> then php is not configured right
<11> or your application in PHP is not using the proper mysql access information
<11> (IP, Port, User, Pwd, database name)
<8> it's running in safe, not needed
<11> it's needed
<11> "safe or not"
<11> because connection to mysql DB cannot be made without it
<11> if the server is on the same box, then the server address will be "localhost" or "127.0.0.1"
<8> ; Default host for mysql_connect() (doesn't apply in safe mode).
<8> mysql.default_host =
<8> ; Default user for mysql_connect() (doesn't apply in safe mode).
<8> mysql.default_user =
<8> doesn't apply
<11> look man
<11> no user login, no connecton to mysqld
<11> whether the default is being ignored or not
<8> yes, but the php-mysql extension should still register it on phpinfo, right?
<8> it doesn't
<11> give me the url for your PHP test page please
<11> I'll have a look
<8> http://skyblue.mine.nu/phpinfo.php
<11> PHP mysql module is not loaded
<11> without that, PHP is not going to do anything with mysql related statements, it should spew errors when it sees them
<12> hi
<8> it is loaded
<8> bash-3.00# /var/www/usr/local/sbin/phpxs -a mysql
<12> what do i need to do if i insert db *files* (i.e. folder with frm myi myd files) into mysqld 4.1 datadir that were taken from 4.0 ? or mysqld will take care of it by itself on startup ?
<8> Activating extension : mysql
<10> anyone know how i can login to phpmyadmin with a chosen username ie admin
<11> Skyblue: it doesn't show up in phpinfo, so it's not loaded
<11> PERIOD
<8> EXACTLY my problem
<10> currently i get to lhpmyadmin thorugh plesk and it always logs me in as a db user in the list
<11> that's a PHP issue
<10> but i want to logon with admin
<8> how do I ldd mysql? what file do I ldd?
<11> not a mysql issue
<12> Skyblue, join #php and ask there
<8> yeah, #apache says it's #mysql, y'all say it's #php and they say it's #apache, lol
<11> in #apache, you never stated that you didn't have PHP mysql module load problem
<11> else you would have been sent to #php from there.
<8> yes I did so
<11> not in any way anybody understaood
<11> this is not a mysql issue
<12> SkyBlue, basically, you need to add mysql.so (mysql *extension* which is part of php distribution) into your extensions folder and add a line into php.ini to load it.
<8> [02:47:44] <8> yeah, the php stuff, but nothing to do with mysql <--one such statement
<8> poncha, well see, no where on the web does it say that
<11> SkyBlue: you really shouldn't experiment with custom building PHP until you make it work with pre-built
<11> surely there is a PHP with mysql module for BSD already
<8> forget it, I'll just have somebody build a dev with it on there and save me their .profile
<11> well, you *could* try doing it standardly instead of the hard way
<8> no, it's all packages
Return to
#mysql
or
Go to some related
logs:
#web
grub hard disk error raid1
#gentoo
#sdl
host mangling quakenet
gam_server dvips
#gentoo
vlc .8.5 ubuntu install dapper
#web
#openzaurus
|
|