Re: Getting mySQL to ignore case sensitivity of field names

On Aug 27, 2009, at 5:11 PM, Adrian Aitken wrote: Hi Scott, it's not the values I have a problem with, it's the fieldnames themselves. As an example the mysql.user table has 'Host' but when I do an update setting 'host' to a value it fails to update. I have to enter 'Host'. The mysql.com

Re: Getting mySQL to ignore case sensitivity of field names

Oops, sorry about that. My understanding is this is OS dependent: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html You may be able to set lowercase tables names, but would always have to use lowercase. I would just stick to entering in the correct case, as the other m

Re: Getting mySQL to ignore case sensitivity of field names

Hi Scott, it's not the values I have a problem with, it's the fieldnames themselves. As an example the mysql.user table has 'Host' but when I do an update setting 'host' to a value it fails to update. I have to enter 'Host'. The mysql.com link seems to only talk about field values. Regards Adri

Re: Getting mySQL to ignore case sensitivity of field names

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html You need to set the field format to a non binary one, and case insensitive will be the default. On Aug 27, 2009, at 2:57 PM, Adrian Aitken wrote: Hi, Google isn't my friend :-( How can I tell mySQL 5.0 to ignore the case of field n

Getting mySQL to ignore case sensitivity of field names

Hi, Google isn't my friend :-( How can I tell mySQL 5.0 to ignore the case of field names i.e. FullName should also be able to be referenced as fullname,fullNAME etc ? I'm running it on a linux box at home but my copy at work (running on Windows 2000 server) has this by default - I certainly set

Re: Fail to change MySQL data directory on ubuntu

Thanks for the tips. Where can I find more details about the ibdata file? After I changed the data dir, hese file did get recreated. So far, I have not noticed any data loss yet. Best, Jia Eric Bergen wrote: That procedure is horribly incorrect. You should simply move the ib_log and ibdata f

Re: Fail to change MySQL data directory on ubuntu

That procedure is horribly incorrect. You should simply move the ib_log and ibdata files with the rest of the datadir. The ibdata1 file contains innodb's system tables and depending on your setting of innodb_file_per_table it also contains your data! On Thu, Aug 27, 2009 at 7:56 AM, Jia Chen wrote

RE: Viable alternatives to SQL?

Isn't that basically the same as pointing phpmyadmin at a read-only copy of the data? There's a reason most searches are limited; when you most people too many options, it's confusing. Good interfaces hide complexity from the end user. -Original Message- From: Jerry Schwartz [mailto:j

RE: Viable alternatives to SQL?

>-Original Message- >From: Kelly Jones [mailto:kelly.terry.jo...@gmail.com] >Sent: Thursday, August 27, 2009 9:44 AM >To: mysql@lists.mysql.com >Subject: Viable alternatives to SQL? > >Many sites let you search databases of information, but the search >queries are very limited. > >I'm creat

Re: Fail to change MySQL data directory on ubuntu

> Chen, Did you really delete ibdata1 ? Yes, I did. Best, Jia Claudio Nanni wrote: 2009/8/26 chen jia mailto:chen.1...@gmail.com>> Hi there, I am using MySQL on ubuntu 8.04. I followed this link http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-lo

Re: Viable alternatives to SQL?

Kelly Jones wrote: Many sites let you search databases of information, but the search queries are very limited. I'm creating a site that'll allow arbitrary SQL queries to my data (I realize I'll need to handle injection attacks). Are there other viable ways to query data? I read a little on "Bu

Viable alternatives to SQL?

Many sites let you search databases of information, but the search queries are very limited. I'm creating a site that'll allow arbitrary SQL queries to my data (I realize I'll need to handle injection attacks). Are there other viable ways to query data? I read a little on "Business System 12" (BS

Re: Using Open Source Database

On Thursday 27 August 2009 03:35:19 am Sameh Attia wrote: > Hi, >Part of our road map is to use an open source database besides > commercial databases (oracle and sql server), we need to select an open > source database to build the necessary skills fo I know this is a mysql mailing list, but

XAMMP and Mysql error

Hi, From yesterday 2009-08-26 i have an error message when my computer start. The mysqld.exe crash blablabla I search on g**gle "006B8853mysqld.exe" and i find somebody in this mailing with this problem!! I don't change anything in my mysql config file, cause i didn't use mysql dur

Re: Fail to change MySQL data directory on ubuntu

2009/8/26 chen jia > Hi there, > > I am using MySQL on ubuntu 8.04. > > I followed this link > > http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive > to change the data directory of MySQL. > > After stopping MySQL: sudo /etc/init.d/mysql sto

Using Open Source Database

Hi, Part of our road map is to use an open source database besides commercial databases (oracle and sql server), we need to select an open source database to build the necessary skills for administration and operation. Then we would put guidelines on which applications should use open source da