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

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

Store MySQL data files and log files (log bin) separated!!!

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()

of this program :( Thanks. Marcos

Reading oracle table

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

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

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

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

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

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

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

changing some tables

. 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

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?

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!