Parameters in MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Recently, I began using a different MySQL verver (i.e. different machine as
well as different version#, going from 4.12a to 4.1.9 max).

The following query used to work:

select firstname, lastname, from associates where username like 'nancianne'

but now fails with:
"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 'from associates
where username like 'nancianne'' at line 1"

Is there some  kind of setting that I need to adjust on my new server (4.1.9
max) ? Can someone please point me on how to get this simple query to run
again? Thanks, my new server variables are given below. -Ike

back log     50    50
basedir  C:\InstantRails\mysql\  C:\InstantRails\mysql\
bdb cache size  8388600  8388600
bdb home  C:\InstantRails\mysql\data\  C:\InstantRails\mysql\data\
bdb log buffer size  32768  32768
bdb logdir
bdb max lock  10000  10000
bdb shared data  OFF  OFF
bdb tmpdir  C:\DOCUME~1\HP_ADM~1\LOCALS~1\Temp\
binlog cache size  32768  32768
bulk insert buffer size  8388608  8388608
character set client  utf8  latin1
character set connection  utf8  latin1
character set database  latin1  latin1
character set results  utf8  latin1
character set server  latin1  latin1
character set system  utf8  utf8
character sets dir  C:\InstantRails\mysql\share\charsets/
collation connection  utf8_general_ci  latin1_swedish_ci
collation database  latin1_swedish_ci  latin1_swedish_ci
collation server  latin1_swedish_ci  latin1_swedish_ci
concurrent insert  ON  ON
connect timeout  5  5
datadir  C:\InstantRails\mysql\data\  C:\InstantRails\mysql\data\
date format  %Y-%m-%d  %Y-%m-%d
datetime format  %Y-%m-%d %H:%i:%s  %Y-%m-%d %H:%i:%s
default week format  0  0
delay key write  ON  ON
delayed insert limit  100  100
delayed insert timeout  300  300
delayed queue size  1000  1000
expire logs days  0  0
flush  OFF  OFF
flush time  1800  1800
ft boolean syntax  + -><()~*:""&|  + -><()~*:""&|
ft max word len  84  84
ft min word len  4  4
ft query expansion limit  20  20
ft stopword file  (built-in)  (built-in)
group concat max len  1024  1024
have archive  NO  NO
have bdb  YES  YES
have compress  YES  YES
have crypt  NO  NO
have csv  NO  NO
have example engine  NO  NO
have geometry  YES  YES
have innodb  YES  YES
have isam  NO  NO
have ndbcluster  NO  NO
have openssl  NO  NO
have query cache  YES  YES
have raid  NO  NO
have rtree keys  YES  YES
have symlink  YES  YES
init connect
init file
init slave
innodb additional mem pool size  1048576  1048576
innodb autoextend increment  8  8
innodb buffer pool awe mem mb  0  0
innodb buffer pool size  8388608  8388608
innodb data file path  ibdata1:10M:autoextend  ibdata1:10M:autoextend
innodb data home dir
innodb fast shutdown  ON  ON
innodb file io threads  4  4
innodb file per table  OFF  OFF
innodb flush log at trx commit  1  1
innodb flush method
innodb force recovery  0  0
innodb lock wait timeout  50  50
innodb locks unsafe for binlog  OFF  OFF
innodb log arch dir
innodb log archive  OFF  OFF
innodb log buffer size  1048576  1048576
innodb log file size  5242880  5242880
innodb log files in group  2  2
innodb log group home dir  .\  .\
innodb max dirty pages pct  90  90
innodb max purge lag  0  0
innodb mirrored log groups  1  1
innodb open files  300  300
innodb table locks  ON  ON
innodb thread concurrency  8  8
interactive timeout  28800  28800
join buffer size  131072  131072
key buffer size  8388600  8388600
key cache age threshold  300  300
key cache block size  1024  1024
key cache division limit  100  100
language  C:\InstantRails\mysql\share\english\
large files support  ON  ON
license  GPL  GPL
local infile  ON  ON
log  OFF  OFF
log bin  OFF  OFF
log error  .\GGRIP1.err  .\GGRIP1.err
log slave updates  OFF  OFF
log slow queries  OFF  OFF
log update  OFF  OFF
log warnings  1  1
long query time  10  10
low priority updates  OFF  OFF
lower case file system  OFF  OFF
lower case table names  1  1
max allowed packet  1048576  1048576
max binlog cache size  4294967295  4294967295
max binlog size  1073741824  1073741824
max connect errors  10  10
max connections  100  100
max delayed threads  20  20
max error count  64  64
max heap table size  16777216  16777216
max insert delayed threads  20  20
max join size  4294967295  4294967295
max length for sort data  1024  1024
max relay log size  0  0
max seeks for key  4294967295  4294967295
max sort length  1024  1024
max tmp tables  32  32
max user connections  0  0
max write lock count  4294967295  4294967295
myisam data pointer size  4  4
myisam max extra sort file size  2147483648  2147483648
myisam max sort file size  2147483647  2147483647
myisam recover options  OFF  OFF
myisam repair threads  1  1
myisam sort buffer size  8388608  8388608
net buffer length  16384  16384
net read timeout  30  30
net retry count  10  10
net write timeout  60  60
new  OFF  OFF
old passwords  ON  ON
open files limit  510  510
pid file  C:\InstantRails\mysql\data\
port  3306  3306
preload buffer size  32768  32768
protocol version  10  10
query alloc block size  8192  8192
query cache limit  1048576  1048576
query cache min res unit  4096  4096
query cache size  0  0
query cache type  ON  ON
query cache wlock invalidate  OFF  OFF
query prealloc size  8192  8192
range alloc block size  2048  2048
read buffer size  131072  131072
read only  OFF  OFF
read rnd buffer size  262144  262144
relay log purge  ON  ON
rpl recovery rank  0  0
secure auth  OFF  OFF
shared memory  OFF  OFF
shared memory base name  MYSQL  MYSQL
server id  0  0
skip external locking  ON  ON
skip networking  OFF  OFF
skip show database  OFF  OFF
slave net timeout  3600  3600
slow launch time  2  2
sort buffer size  2097144  2097144
sql mode
storage engine  MyISAM  MyISAM
sync binlog  0  0
sync frm  ON  ON
system time zone  Eastern Standard Time  Eastern Standard Time
table cache  64  64
table type  MyISAM  MyISAM
thread cache size  0  0
thread stack  196608  196608
time format  %H:%i:%s  %H:%i:%s
time zone  SYSTEM  SYSTEM
tmp table size  33554432  33554432
transaction alloc block size  8192  8192
transaction prealloc size  4096  4096
version  4.1.9-max  4.1.9-max
version bdb  Sleepycat Software: Berkeley DB 4.1.24: (January 11, 2005)
Sleepycat Software: Berkeley DB 4.1.24: (January 11, 2005)
version comment  Source distribution  Source distribution
version compile machine  i32  i32
version compile os  Win95/Win98  Win95/Win98
wait timeout  28800  28800

Re: Parameters in MySQL

Quoted text here. Click to load it

Im a dope, evidently. There should be no comma after lastname! -Ike

Site Timeline