"hard" sort table order

Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure? -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

is this proper use of BACKUP command?

osedir($handle); } And another question: The created backup files, do they have to be restored to a database with the very same name, or could they be restored to another database? Are there any differences between backing up this way, and using mysqldump? And finally: Does mysqldump have a cou

is this proper use of mysql BACKUP?

osedir($handle); } And another question: The created backup files, do they have to be restored to a database with the very same name, or could they be restored to another database? Are there any differences between backing up this way, and using mysqldump? And finally: Does mysqldump have a co

need help combining these two queries to one.

WHERE un_section.s_id = un_article.a_section AND un_article.a_deadline = '-00-00' AND un_article.a_issue = '-00-00' ORDER BY un_section.s_name ASC, un_article.a_header ASC How are they combined to one? -- anders thoresson -- MySQL General Mailing List For list archive

query help needed.

un_article_writer.a_id AND un_section.s_id = un_article.a_section AND un_article.a_deadline = '-00-00' AND un_article.a_issue = '-00-00' ORDER BY un_section.s_name ASC, un_article.a_header ASC" Help appreciated! :) -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

table creation problems

i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL, i_date DATE NOT NULL UNIQUE, i_number INT NOT NULL, i_editor INT, UNIQUE (i_date, i_number) ); For local development I'm using MySQL 3.23.55-NT on a Windows 2000 server. My ISP uses 3.22.25 on a SunOS 5.7 server. Any s