Re: Max columns in a tabel in MyISAM storage engine

Fabian Köhler wrote: Hello, i have table with answers to questions. Every answer is a column in the table. i.e. id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 another option to save it would be sth like this: id|field|value 1|q1|answer1 1|q2|answer2 1|q3|answer5 2|q1|answer3

Re: Max columns in a tabel in MyISAM storage engine

Fabian Köhler wrote: Hello, i have table with answers to questions. Every answer is a column in the table. i.e. id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 another option to save it would be sth like this: id|field|value 1|q1|answer1 1|q2|answer2 1|q3|answer5 2|q1|answer3

Re: Max columns in a tabel in MyISAM storage engine

Hi, Might be column indexing have restriction over number of columns to be indexed, but for number of columns, hope you can overrider with the variables "avg_row_length" and "max_rows" during create/alter table. The length/size of the table depends on the file system(maximum file size defin

Re: more than 10000 fields in the OR clause

Arun Kumar PG wrote: Guys, I know this is a stupid thing but I wanted to know if we have an index on a column "X" and if i have a query having 1 OR conditions on the field e.g. where X=10 OR x=12 OR x=13 OR x=15.. so on then will it give any benefits in terms of speed? Yes the inde

Re: more than 10000 fields in the OR clause

Hi Arun, Instead of doing x=10 or x=10, use the IN condition where X in (10,20,30..etc), it would work better. But i guess there is a limit on the number of values specified in IN clause, I am not sure, need to check on that. regards anandkl On 4/17/07, Arun Kumar PG <[EMAIL PROTECTED]> wrote:

more than 10000 fields in the OR clause

Guys, I know this is a stupid thing but I wanted to know if we have an index on a column "X" and if i have a query having 1 OR conditions on the field e.g. where X=10 OR x=12 OR x=13 OR x=15.. so on then will it give any benefits in terms of speed? thx - A

Re: state=sending data for too long

can u please tell us on which all columns in this table have indexes On 4/16/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, For the following query: select unix_timestamp(beginTime) as bTime,myTable.* from myTable Where nodeID=2 AND flavor In('sim','ofl') AND (deactive= 0 OR deacti

Max columns in a tabel in MyISAM storage engine

Hello, i have table with answers to questions. Every answer is a column in the table. i.e. id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 another option to save it would be sth like this: id|field|value 1|q1|answer1 1|q2|answer2 1|q3|answer5 2|q1|answer3 ... The last one is n

Re: Query Question

Hi Aaron, Aaron Clausen wrote: I have a couple of very simple tables to handle a client signin site: The client table has the following fields: client_id int(11) primary key auto_increment first_name char(90) last_name char(90) The signin table has the following fields record_id int primar

Query Question

I have a couple of very simple tables to handle a client signin site: The client table has the following fields: client_id int(11) primary key auto_increment first_name char(90) last_name char(90) The signin table has the following fields record_id int primary key auto_increment client_id i

Connector J 5.1.0 is Production ?

In my Connector/J Costumer Page the 5.1.0 is a Production release... and the dev.mysql.com is ALPHA... really ? JDBC 4.0 is ready to use in production enviroments ? -- - ++ Dyego Souza Dantas Leal ++ Dep. D

Re: Setting a field to NULL (default value)

On Monday 16 April 2007 07:56, Tim Johnson wrote: > Hi: > I have a table with a column of type char(120). > default is NULL > How do I a set a 'cell' back to NULL? > Example: > alter customers set all_colslist=NULL where ID=57; > returns a syntax error. > Mysql version 4.0.20 > thanks This is embar

Setting a field to NULL (default value)

Hi: I have a table with a column of type char(120). default is NULL How do I a set a 'cell' back to NULL? Example: alter customers set all_colslist=NULL where ID=57; returns a syntax error. Mysql version 4.0.20 thanks -- Tim Johnson <[EMAIL PROTECTED]> Palmer, Alaska, USA -- MySQL General Mailin

MySQL IPv6 Support?

Hello, I have searched every corner of the internet for info on MySQL's IPv6 support, but have not found much information. I have a Linux box with an IPv6 address. It can be pinged from other machines (Linux and Windows) by its IPv6 address. However, I cannot get this command to work: mysql -

RE: how to tell if something hasn't happened yet - SOLVED

[snip] [snip] select s.* from store s where s.id not in (select t.storeid from trans t where t.created=date(now())); [/snip] This is close, but it does not exclude previous days. I only want to see those that have not logged in today. [/snip] select store.storeid, store.stname from store

RE: how to tell if something hasn't happened yet

[snip] select s.* from store s where s.id not in (select t.storeid from trans t where t.created=date(now())); [/snip] This is close, but it does not exclude previous days. I only want to see those that have not logged in today. -- MySQL General Mailing List For list archives: http://lists.

Re: Problem with mysqldump and local-infile

Mark van Herpen <[EMAIL PROTECTED]> writes: > Hi, > > I want to backup my databases with mysqldump, but mysqldump won't run > because I use the 'local-infile=1' option in the my.cnf file: > > [client] > port= 3306 > socket = /tmp/mysql.sock > local-infile= 1 > > This is be

Duplication in sles9 for my.cnf

Hi, I have noticed in the man page for mysql from MySQL-client-community-5.0.37-0.sles9.i586.rpm there is a repetition in the my.cnf files read by mysql. I am wondering if this is at all significant. This is what "man mysql" shows for the MySQL-client-community-5.0.37-0.sles9.i586.rpm install,

Re: Problem with mysqldump and local-infile

It looks to me that local-infile is a command-line parameter to mysql client mysql --local-infile -u user dbname I've not been able to find this option elsewhere. -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 On Mon, April 16, 2007 12:14, Mark van Herpen wrote: > Hi, > > I want to

Problem with mysqldump and local-infile

Hi, I want to backup my databases with mysqldump, but mysqldump won't run because I use the 'local-infile=1' option in the my.cnf file: [client] port= 3306 socket = /tmp/mysql.sock local-infile= 1 This is because I want php and other clients to use local-infile. This

Database with a lot of views

In our application, each user has an won set of tables. We're migrating to a shared table set, with an extra field in each table, identifying the user a particular rows belongs to. In order to keep database changes minimal, we're thinking of using an own set of views for each user. Is there huge

Error 1111 (Weird.)

Ok the Query i am trying to run is very long with many joins it is only run a couple of times every two weeks for payroll. It worked well on 4.1alpha and we have now upgraded to 5.0.24a-log Running on 64 Bit AMD Linux Each section of the query works correctly and if i run only a two or 3 day s

Re: How to overwrite existing file with SELECT .. INTO?

At 08:14 AM 4/13/2007, Amer Neely wrote: I'm using MySQL 5.0.21 and am trying to find out if it is possible to overwrite an existing file when using a 'SELECT ... INTO' command from the command line. Is there another parameter that can do this? I've looked through the online reference manual,

Re: MySQL slave error when creating view

Yes we faced the same prbs with 5.0.24, pls upgrade to 5.0.37 community / Darshan - Original Message - From: "Baron Schwartz" <[EMAIL PROTECTED]> To: "Tim Lucia" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED], mysql@lists.mysql.com Sent: Saturday, April 14, 2007 6:53:17 PM (GMT+0530) Asia/Cal