Re: load data into temporary table

1 row in set (0.00 sec) > > Best Regards, > -Janek, CMDEV 5.0. > StudyLink. Helping People Realise Their Potential. > http://studylink.com > > > On Tue, 2009-05-19 at 02:57 +0100, Alex K wrote: >> Hello, >> >> Would anyone know how to load data infile into a te

load data into temporary table

Hello, Would anyone know how to load data infile into a temporary table? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: slow "in" statement?

L PROTECTED]>: > can u please show me the explain plan for this sql and also the table > structure > > explain select statement > > desc table_name > > > On 11/10/08, Alex K <[EMAIL PROTECTED]> wrote: >> >> Hi Ananda, >> >> Indexes are pr

Re: slow "in" statement?

Hi Ananda, Indexes are present. I'm passing no more 10 values. Alex 2008/11/10 Ananda Kumar <[EMAIL PROTECTED]>: > it should not cause any issues, unless your passing too many values in "id > in(1,2,...n). > Are the indexes present. > > > On 11/10/08

slow "in" statement?

Hello, It seems to me that the statement "id in (id1, id2 ... idn)" is much slower than "id=id1 or id=id2 ... or id=idn" or I am doing something wrong? Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: simple design choice

That seems like a nice trick. I suppose the flag would just be an int and not an enum in this case. 2008/10/3 Mr. Shawn H. Corey <[EMAIL PROTECTED]>: > On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote: >> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]&

Re: simple design choice

2) is probably cleaner but a hassle as well because one needs to make sure all user_ids are also in this new table. 2008/10/3 Alex K <[EMAIL PROTECTED]>: > Hello, > > I have a table of a 1 million users. I want to add a flag called > delete if a user wants to delete his accou

simple design choice

Hello, I have a table of a 1 million users. I want to add a flag called delete if a user wants to delete his account. Note that this situation does not happen a lot. 1) Should I alter my users table and add a delete flag to the users table. >> it's easy to update however it uses a lot of unnecess

backup questions

Hi guys, Is it safe to perform a backup of a database by copying its mysql files if the database is: 1) MyISAM and the database is not being used (mysql server turned off)? 2) InnoDB and and the database is not being used? 3) MyISAM and the database is being used? 4) InnoDB and and the databas

Re: performance of heterogeneous joins

Cool it's good to know thank you. On 25/01/2008, Jay Pipes <[EMAIL PROTECTED]> wrote: > Nope, no difference, AFAIK. > > Alex K wrote: > > Any ideas pertaining this newbie question? > > > > Thank you so much, > > > >> Hi Guys, > >>

Re: performance of heterogeneous joins

Any ideas pertaining this newbie question? Thank you so much, > Hi Guys, > > Is there a performance hit when joining across multiple databases as > opposed to joining multiples tables in one database? Suppose the same > tables are available across all databases. > > Thank you, > > Alex > -- MyS

Re: select from otherdb.table question?

t; to specify the db name you are working with. So to answer your > question, no, a new connection is not established. > > Brent > > > On Jan 19, 2008, at 10:19 AM, Alex K wrote: > > > Hi Guys, > > > > What does the statement "select * from otherdb.tab

select from otherdb.table question?

Hi Guys, What does the statement "select * from otherdb.table" do if I haven't explicitly connected to otherdb previously? I would assume it connects to otherdb and does the select on table but does it create a new connection each time? Is it as efficient as explicitly connecting to otherdb and th

performance of heterogeneous joins

Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all databases. Thank you, Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: basic style shema question

1:44a -0500 on 18 Jan 2008, Alex K wrote: > > To summarize one table vs. many tables with one to one relations? > > As per usual, it depends on your needs. For most flexibility, and to > give the DB the best chance to give the best plan for the possible > requests I might make

basic style shema question

Hi Guys, Let's suppose I have the following table: create table companies ( id int(11) not null auto_increment primary key, # user's login and password email varchar(100), passwordvarchar(100), # basic information company_namevarchar(10