SELECT with 1,000,000 ROWS

ed more RAM ?). Thanks in advance. -- Arno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT with 1,000,000 ROWS

r. > > http://www.mysql.com/doc/en/MySQL_indexes.html > Thanks for the link, I go to see it immediately. PS: For information, I had forgotten to say that I used MySQL 4.1.0-alpha on Linux Slackware 9.0 -- Arno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT with 1,000,000 ROWS

Un beau jour, Victoria Reznichenko a écrit: > "Arno" <[EMAIL PROTECTED]> wrote: >> >> I have aproximately 1,000,000 rows and I would like to do some >> query. The >> first one is to get the number of row so I do : >> >> mysql

Re: Best practices for deleting and restoring records - moving vs flagging

is that you might sacrifice some speed(depends on the number of records in the table.) If the table does not grow that fast most def just flag the records as deleted. my2c worth -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing

Re: Best practices for deleting and restoring records - moving vs flagging

hi bastian just a thought. rather stay away from auto_increment PK's and rather generate your own PK. i have run into trouble a couple of times using auto_increment when i made backups and restored the data again. The PK changed and i had records in other tables referencing the old PK

Re: Query Help

entID = sj.studentID and sj.Grade = 'A' and (sj.Subject = 'Maths' or sj.Subject = 'Chem') -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Query Help

as sj where s.studentID = sj.studentID and sj.Grade = 'A' and (sj.Subject = 'Maths' or sj.Subject = 'Chem') I think your query will return student 3 as well My apologies. Misunderstood the question... -- Arno Coetzee Developer Flash Media Group Office : 2

Re: Order By Question

n. /Johan or maybe a datetime field and order by the datetime. i was never a big fan of auto-increment. ;-) -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Data sync offline

the daily process. -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: backup and restore a database in a query ？

shuming wang wrote: Hi, Could we do a database dump/backup in a query like below ? mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u root -p -C mydb>mydbfile or restore a database in a query like below ? mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup a

Re: Error in Update Command Text - What am I missing

-- --- UPDATE Clients_Master SET Label='', Title='Mrs', FName='Jane', MName='', SName='Doe', Building='', Unit='', STNumber='', STName='', STType='', STSuburb='', STSta

Re: I forgot the admin password

good luck Luis -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 7595 Mobile : +27 82 693 6180 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql no series

To: Sent: 04/10/2005 2:19 PM Subject: Re: [Fwd: MySQL in C - I need help!] is this fields datatype varchar? does it have to be a text field? change the datatype to int , double etc. depending on your needs -- Arno Coetzee Developer Flash Media Group Office : 2712 342 7595 Mobile : 2782 693

Re: Find username password on tables

root user. Thanks, Scott use the mysql database and look in the user table .. you will be able to see all the users there , as well as the privileges. you will have to reset the password for the user you want to use... use the 'grant' statement to reset the password. hope

Re: alter table

rver version for the right \ syntax to use near 'varchar(160)' at line 2 The field exists, but I'd like it to accept more chars. Debian/Gnu Linux Testing/Etch, MySQL 4.0 http://dev.mysql.com/doc/mysql/en/alter-table.html -- Arno Coetzee Developer Flash Media Group Office :

Re: alter table

s. keeling wrote: Incoming from Arno Coetzee: s. keeling wrote: Grr. Please, what's wrong with this?!? alter table MEMBERS alter MEMBER_INFO varchar(160); ERROR 1064: You have an error in your SQL syntax. Check the manual \ that corresponds to your MySQL server version fo

Re: Restore using mysqldump (MySQL 4.1.12)

option. Can someone please help? Thanks you all. Wayne. J. Wayne Doneker BAE Systems York Pa. 717 225 8109 Email: [EMAIL PROTECTED] try this wayne mysql 'databasename' <'filename' -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobil

Re: Counting total results from a table

27;) i don't know what the ID field in the select clause is for , so i omitted it. i suspect the ID field in the select clause caused the prob. shout if you need more help. -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobile : +27 82 693 6180 Fax : + 27 12

Re: Help with an SQL query

? Thanks. select VBS_ID , max(Date) from weight -- Arno Coetzee Developer Flash Media Group Office : +27 12 342 3490 Mobile : +27 82 693 6180 Fax : + 27 12 430 4269 www.flashmedia.co.za <http://www.flashmedia.co.za/tms.php >> -- MySQL General Mailing List For list archives: http://lists.

Re: LOAD DATA INFILE (url)

currently have something like this running... i make a dump file on the remote server runing a script with crontab. i gzip that file just to make the file transfer faster . the local server then fetches the file (wget) and gunzips it and then i load the file. works pretty good. -- Arno Co

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

MySQL Conference & Expo Early Registration closes today

Dear MySQL Users, The early registration of the MySQL Conference & Expo 23-26 April 2007 closes today, 14 March 2007. So if you want to cut your attendance costs by 200 US dollars, register now! Registration: http://www.mysqlconf.com/pub/w/54/register.html Here is a quick compilation of some we

copying tables between databases in mySQL 3.22.32

anything definite in the manual about this, so any suggestions are welcome! Thanks, Arno -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Arno Schoenmakers System Scientist ASTRON P.O. Box 2 tel: +31-521-595100 7990-AA Dwingeloofax: +31-521-597332