select
Hi all, I would like how to function select working internals. If each select in BD is mono process or various select is processes in same time without lock table? Tks Marcos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How can I export compressed databases in MySQL?
Hello everyone, I have to export my databases and I get large files for my dump. How can I export compressed databases in MySQL? I use: #mysqldump --default-character-set=latin1 -u'name_user' -p'pass' 'database_name' $path/file_name.sql; Thanks, Marcos Santos Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
Store MySQL data files and log files (log bin) separated!!!
Hello everyone, I am compiling mysql source and need stored MySQL data files and log files (log bin) separated. For example: /var/log/mysql /* log files and /sgdb/data /* data files I used --localstatedir in ./configure but both data files and log files was stored together. How do this Thanks Marcos Santos Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
function select now()
Hi, I upgrade my mysql server and machine from Conectiva linux 8 and mysql 3.23.57 to Debian 3.1 and mysql 4.1.11 and my program don't work. This program was made in Delphi with zeos component to conect mysql and the program use function select now(). With conectiva 8 and mysql 3.23.57 this program return -mm-dd and after upgrade to Debian return dd/mm/. I changed in regional settings from win98 to show -mm-dd and worked but when save any data with date from the program, this date not work correctly. My question, why don't work after this upgrade? Ps. I don't have the sources of this program :( Thanks. Marcos
Reading oracle table
Hello all, I am a new user, in fact I've never used any software like Mysql, oracle or sqlserver. But I am very familiar with analysing data, I am a statistician. I've just received an Oracle table, and need just to read it and export it to a new format, like delimited text. The file name has no extension, it is like this: File_nameBKSql Is there a easy way to read it in Mysql? Ho do I proceed? Thanks very much, Marcos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: deleting rows which table1.row=table2.row
yes, sorry. my intention is to delete repeated rows from TABLE1. and since its a bit difficult with mysql the way that i take is create a new table TABLE2 with the repeated rows (but not repeated in TABLE2), and then i want to delete from TABLE1 all the rows which also are in TABLE2. later on, i INSERT again the values from TABLE2 to TABLE1. i have mysql version 3.22 thanks On Tue, 14 Oct 2003, Director General: NEFACOMP wrote: I think the question is not very clear. Do you want to delete from all the tables or you just want to delete from one of the tables? Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?) I saw some replies to your question, did they solve your problem? I am asking this because a DELETE command is one of the most risky operations on data. Thanks Emery - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 13, 2003 17:25 Subject: deleting rows which table1.row=table2.row how to delete rows which table1.field=table2.field -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
deleting rows which table1.row=table2.row
how to delete rows which table1.field=table2.field thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?
Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a DATE type field according to a different format than -mm-dd? I wish to insert a date into a date field but my date format is dd/mm/. If not, is there any workaround using mysql functions? AFAIK mysql reference does not mention this... Thanks, Marc Pomar _ Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu ocio con MSN Entretenimiento. http://entretenimiento.msn.es/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A little problem with SELECT
SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND (b.name='joe' OR b.name='bill'); _ Marcos Henke _ - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Blaster [EMAIL PROTECTED] Sent: Friday, January 17, 2003 7:51 AM Subject: Re: A little problem with SELECT * Blaster [...] main company table id (int) | company name (varchar) | phone (varchar) | .. more fields that doesn't really matter employee table (company.id = employee.cid) id (int) | cid (int) | name (varchar) | age (int) | email (varchar) Now, I want to make a search which can search for 2 names and show me if there are any company that has these names? I tried SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND b.name='joe' OR b.name='bill'; Because you want to check two different names, you must join the employee table twice: SELECT a.* FROM company a, employee b1, employee b2 WHERE a.id=b1.cid AND a.id=b2.cid AND b1.name='joe' AND b2.name='bill'; -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help me, please
Select max(No) from table Marcos Henke - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: mustakim abas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 1:51 PM Subject: Re: help me, please At 8:06 -0800 12/19/02, mustakim abas wrote: Hello, i am new in mysql. I got a problem. I try write my C program with mysql API.I have 5 field in table.No,Name,Phone,Date,Time. How can i take one row where the No is bigger? Thanks for help. Bigger than what? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connection delphi 6 / ADO with the mysql
I am needing to do a connection delphi 6 / ADO with the mysql that is in a linux Freebsd of the qmail. Does anybody know as I can make that? Thankful, Marcos Birro Calixto [EMAIL PROTECTED] Webmaster - WebDeveloper - Delphi UIN: 9151558 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql X Win98
Olá, instalei o mysql no Win98 porém o mesmo não está OK. Alguém tem um passo a passo, porque estou com pressa para procurar na web, mas me parece que tem que ter o perl instalado, isto confere? Marcos P.S.: estou usando Win98 e PWS. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
random select
hi, i would like to show 5 random field from a total of 100. id is my primary key id name -- abmarcos akjohn how can i show 5 of them randomly? thanks in advance, marcos [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing some tables
hi, i have a table like that: CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY KEY(login)); i have lot of info inserted already in that table. And i would like to add some more attributes. how can i do it, in order to maintain older info? drop the table. CREATE TABLE user ( login varchar(50), pass varchar(50), att1 varchar(10), att2 int(4), PRIMARY KEY(login)); mysqldump -u user -p password table table.txt is this right? regards, marcos lloret [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Brain cramp or unsupported SQL?
From what I've read in the docs, this should work, yes? select mcorder.ord_id, project.address, mcuser.last_name from project inner join (mcuser inner join mcorder on mcuser.usr_id = mcorder.usr_id) on project.prj_id = mcorder.prj_id; Or am I just stoopid today? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump core dumping mysql
Hi! I'm having core dumps in mysql 3.23.28 ( BSD 4.2 ) during mysqldump. I've tried different options, now I'm currently running: mysqldump -F -l -q -O max_allowed_packet=16777216 db but sometimes mysql core dumps. Thanks for any idea!