 | | | MySQL General | | Asif Lodhi wrote
> Hi
>
> I am replying back to my own post. Sorry I forgot to mention that I
> am using mysql client on WinXP Pro SP2 and MySQL-5.0.22 is installed
> on the same machine.
>
> AnIs this list still working ?
Mickalo
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)
If you 're using Myphpadmin you can turn this option off when generating the
dump file.
-----Original Message-----
From Chris White [mailto chriswhite@(protected)]
Sent Friday August 04 2006 1Hi Chris
what you can do is
SELECT [fields]
FROM [table]
WHERE id IN (id1 id2 id3...)
ORDER BY FIELD([field] value1 value2 value3 ...)
/Johan
Chris Sansom skrev
> Yes I have looked at the docsRatheesh K J wrote
> Hello all
>
> I have a doubt on Index Merge.
>
> We are currently using MySQL server 4.1.11. As a part of DB management I am currently doing an analysis on all the Tables.
> It depends on the data not the situation. How 's that?
FLD_4 is doubtful that you would want/need and index on it. This assumes an even distribution of both values (ie. male/female).
Since you wouldRatheesh K J wrote
> Helo all
>
> Just wanted to know when should a Table be considered for partitioning ( or should it be archiving ).
>
> Almost all of our tables are of Innodb type. I am lookinI posted this as a comment on the page too but I?m curious as to why the
top solution is off by a day or so... Is this a bug or a rounding issue or
what? Is there a way to "fix " the top one to work tHello all
Need an explanation for this
I did the following -
SELECT DISTINCT COLUMN1 FROM TBL_XXX
I got the foll result
nayak_ratnadeep wrote
>
> Hello
> I have downloaded a code on c++ to talk to MySQL database from net which
> included a file "sqlplus.hh " where may I find the file?Please help me
> soon.
WhyGreg 'groggy ' Lehey wrote
> > I have downloaded a code on c++ to talk to MySQL database from net which
> > included a file "sqlplus.hh " where may I find the file?Please help me
> > soon.
That 's the Daevid Vincent wrote
> I have a SQL challenge I 'm not sure how to solve. But it 's so common I feel
> kind of stupid asking this...
>
> I have a 'user ' table with 'login_date ' which is an auto updatHello
I have downloaded a code on c++ to talk to MySQL database from net which
included a file "sqlplus.hh " where may I find the file?Please help me
soon.
With Regards.
Ratnadeep Nayak.
I use a VMware for LAMP development work.
I just looked in my /var/lib/mysql dir and there are 972 of these
vmware-bin.000001 ... vmware-bin.000972 files! Yipes!
Do I need them? Can I delete them? HArias Gonzalez Javier wrote
> Assuming we have the following table
>
>
>
> CREATE TABLE test (
>
> id INT NOT NULL
>
> last_name CHAR(30) NOT NULL
>
> first_name CHAR(SELECT DISTINCT username time download
FROM table
ORDER BY time DESC
GROUP BY username
Andr? H?nsel wrote
> Hi Dan hi Obed
>
> of course I have no specific username I want the last 5 downloadbruce wrote
> hi...
>
> i have FC3/4 systems. i 'm going to need to have mysql-5.0.22 but there
> appears to be numerous dependencies that yum can 't easily resolve from the
> RPM i 've found.
>
> caMaybe
$query "UPDATE profile SET acct_type '%at ' ..... genre '$g ' WHERE
id $userid "
/Peter
-----Original Message-----
From Nicholas Vettese [mailto nvettese@(protected)]
Sent ThursdayVittorio Zuccal? wrote
> Hello
> i 'm installing an open source program based on mysql because i want to
> try it.
> It controls mysql 's version and it wants 4.1.16 but i 've 4.1.11...
>
> Is it posHi
> WHERE
> col1 > <something > AND col2 > <something > etc...
> AND PRIMARYKEY > 0
[...skip...]
> I need an explanation of whether what I did is an
> optimization or not? OrAt 06 32 AM 8/3/2006 Ratheesh K J wrote
>Hello all
>
>Just wanted to know how many columns are preferable in table. At present
>we are having nearly 50 - 60 columns in some of the tables. Is thisYou should look at what MySQL is doing start by looking at SHOW STATUS and SHOW VARIABLES. The SHOW STATUS will give you an idea
how your indexes are performing thread management open file managemHi ALL
I have taken backup of http //mydomain.com/?q admin/database through
drupal 4.6.3 by selecting all tables and it asked me to save as
backup.sql.
Now when i run
[root@(protected) root]# mysql -u kaushYou might look into WITH ROLLUP. That could easily give you cumulative totals for the year but off the top of my head I can 't think
of a way to get it for the months.
----- Original Message -----
Forgive the mess I present you this is a strangely done site with a even
stranger structure and methodology that I am trying to work with.
The basic idea is one website has multiple websites in it. It depends what you need and how your data looks.
Say you have a table with 4 columns
col1 has 1000 dictinct values
col2 has 10000 dictinct values
col3 has 100 dictinct values
col4 has 100000 dictiOn 3 Aug 2006 at 10 16 John Trammell wrote
<snip >
> If you hated spam as much as I did you would have terminated this user
> based on the egregious and well-documented abuse of this list.
<sniphi..
i have FC3 with 4.1.13 i also have FC4 with 4.1.20. however i can 't seem
to find 5.0.x RPMs for FC3/4. do i have to go ahead and build this from
source for the FC3/4 boxes that i have...
thaAt 05 27 PM 8/2/2006 you wrote
>Hi!
>
>I 'm getting a lot of pushback on using mysql for full-text searching on
>over 30 000 000 documents. It 's starting to slow down when using more than
>10-15 keBruce
>my question how can i come up with a sql query that will list all the
>children (and children 's children...) of a top level item?
This is an edge list tree model ID being the child node p |
|
|
