>
>
> I would like to know regarding the cast and convert functions in
> MySql4.0.1;.
> Can nebody explain the usage(casting of strings to number/integer).
> I was not able to use them properly
>
> Regards
> Harish Varandani
>
--
-- Forwarded message --
Date: Tue, 2 Jul 2002 17:40:24 +0300 (EEST)
From: Nixarlidis Aris <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: selected records retrieve
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice or in wrong p
On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote:
Hi,
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql> UPDATE user SET Password=PASSWORD(testpassword)
> -> WHERE User='root';
> ERROR 1046: No Database Selected
> mysql>
1) select the database with "u
it's in the docs.
use mysql;
or
update databasename.tablename ...
- Original Message -
From: "Page Works Web Solutions" <[EMAIL PROTECTED]>
To: "MySql mailing list (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 1:51 PM
Subject: Root pass
Hi,
any ideas on this one
[admi
Thanks,
So, just to be 100% sure, the BEST to do is to install max, as I can't
see any reason why NOT to...? No performance issues when used as a plain
vanilla model, no stability and no security issues either, only "down"
side to it is that it is a tad bit larger ?
PS,
Oh, and why do I alway
Hi,
any ideas on this one
[admin admin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.37
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> UPDATE user SET Password=PASSWORD(testpassword)
-> WHERE U
where's your execute line?
oconn.execute (sqltext)
all you're doing is putting the sql statement into a variable and nothing
else.
- Original Message -
From: "Defryn, Guy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 12:41 PM
Subject: Insert with ASP into
Hi all,
First, thanks for the patience and the help I've been getting. I'm at
this point.
I think this is where I'm getting stuck at
-p[password], --password[=...]
Password to use when connecting to server
If password is not given it's asked f
Hi there,
I want to insert data in a mysql database. When I submit
I don't get any errors. It takes me to the page that processes everything
However, when I check the database the records are not there.
Selecting data from the website works fine. My code is below
but I don't think anything is
Try
mysql -u root mysql -p
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 11:02 PM
To: MySql mailing list (E-mail)
Subject: root passwords
Hi all,
MySql on linux b
Solved the problem, here's one for the archives.
Upgrade to the latest version of MDAC (currently 2.7).
.. The production server was still running an old version. Downloading
the MDAC2.7 from microsoft and installing it solved the problems.
If anyone wants me I'll be out the back hitting myself
Hi all,
MySql on linux box, I did the following and now I'm stuck.
[admin admin]$ su -l
Password:
*
* *
* NOTICE TO ROOT USER: Changes to system files may affect *
sql,query
At 21:50 -0300 7/2/02, Crercio O. Silva wrote:
>PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables
>with large number of rows (my tables have -+ 30 records each) it take a
>few seconds to get the results.
>This is not a big issue for me, but I'd like to confir
At 20:35 -0700 7/2/02, Martin Scherer wrote:
>I am trying to import a text file that is tab delimited.
>
>I am using the following , but it only returns one line.
>
>LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO
>TABLE Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
At 23:20 -0400 7/2/02, Tac wrote:
>I have a table with a "state" field, and often I want to get only records
>matching those states, ordered. This simple query
>
> Select * from my_table where state='NJ' order by table_id DESC
>
>is relatively slow because of the order by clause (where there
At 21:41 -0400 7/2/02, Bob Bell wrote:
>Pardon my posting as soon as I subscribed to this list, but I have
>a problem that's really annoying me. I just installed MySQL on
>a virtual server account that I have, and for some reason, mysql refuses
>to list my databases or tables, although they seem
At 15:14 -0700 7/2/02, Bill Bernat wrote:
>1.
>If all I want to do is use InnoDB tables for declarative referential
>integrity and nothing else, do I need mysql-max or can I just use the
>standard build of mysql 3.23.51? (Wondering about both Windows and
>Linus, though the answer should be the sa
Right list.
What you want is an outer join. Very simple example:
person
---
personID
===
name
region
===
attendance
---
attendanceID
===
date
personID FK into person
eventid FK into event
===
Select event.date,
person.name,
(attendance.personID is null) as present
from attendanc
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i
I have a table with a "state" field, and often I want to get only records
matching those states, ordered. This simple query
Select * from my_table where state='NJ' order by table_id DESC
is relatively slow because of the order by clause (where there are a lot of
matching records). I've tri
hi Heikki,
i do what u said:
> yourpathtomysqlbindir> mysqld-max-nt --console
cannot initialize innodb as 'innodb_data_file_path' is not set
...
i sword in god that i have set this data file path as:
innodb_data_file_path=c:/mysql/data/ibdata:300M
and this is a valid directory, and some ti
hi Heikki,
i do what u said:
> yourpathtomysqlbindir> mysqld-max-nt --console
cannot initialize innodb as 'innodb_data_file_path' is not set
...
i sword in god that i have set this data file path as:
innodb_data_file_path=c:/mysql/data/ibdata:300M
and this is a valid directory, and some times i ge
You need a LEFT JOIN. Read about it here:
http://www.w3schools.com/sql/sql_join.asp
Go down to the "LEFT JOIN" section.
HTH,
Jed
I liked it when Chris Griffin wrote this to me:
> If this is not the right list for this please direct me to the proper
> list.
>
> I have a table of name/address
If this is not the right list for this please direct me to the proper
list.
I have a table of name/address information. I need to keep track of a
weekly event and if they participated or not. I thought I could have a
table of dates and people record ids with just those that participated.
The
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i
Pardon my posting as soon as I subscribed to this list, but I have
a problem that's really annoying me. I just installed MySQL on
a virtual server account that I have, and for some reason, mysql refuses
to list my databases or tables, although they seem to be there. I've
included a log below, wh
Marvin ...
It is a lot easier than you may be thinking.
Just make sure you download the Win32 binaries, and run the setup wizard. In
most cases, the installer's defaults are fine, but you can put the server on
any drive/partition you like. Check out the MySQL Manual's Win32
installation (http://
Hello all...
I'm new to the list and to MySql and would like to get some advice on approaching my
first mysql install.
I've just installed Apache ver2.0.39 onto my W2K server and I'm currently attempting
to get PHP4 going. Can anyone provide me with some ideas on how to approach the mysql
insta
Crecrio,
- Original Message -
From: ""Crercio O. Silva"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 3:49 AM
Subject: BUG: SHOW TABLE STATUS & InnoDB Tables
> Hi,
>
> I have just noticed that SHOW TABLE STATUS is returning different number
of
>
Hi,
I have just noticed that SHOW TABLE STATUS is returning different number of
rows each time you execute the query. This seams to affect only InnoDB
Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables).
I'm using MySQL 3.23.49Max on WIN2K.
How to repeat the problem:
Execute the
Hytham,
start mysqld-max-nt from the MS-DOS prompt:
yourpathtomysqlbindir> mysqld-max-nt --console
What does InnoDB print?
Regards,
Heikki
- Original Message -
From: ""Hytham Shehab"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 03, 2002 2:24 AM
Subjec
> Yes, but, this advice does *not* go on to describe how you cope with the
> deletion problem.
>
> If you store data in records in the database a DELETE will delete *all* the
> data for the set of rows. If some of the data is lying around in disk files
> these obviously don't get deleted by DELET
hi Paul:
>
> Make sure it's not being started with --skip-innodb.
>
i am sure that the --skip-innodb is not in any of my configuration files.
sql
--
Hytham Shehab
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Dat
> hi guys,
> i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and
> c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be :
> innodb_data_file_path=c:/mysql/data/ibdata:300M
> then, when i restart the server and start the client, i type:
> show variables like "ha
As long as you need to create InnoDB table you have to use MAX binary...
Check out phpmyadmin, it is totally free and operating system-independent
since it runs from the server and can be used through the web browser..
Take a look at it at : http://www.phpmyadmin.net/
Gurhan
- Original Messag
1.
If all I want to do is use InnoDB tables for declarative referential
integrity and nothing else, do I need mysql-max or can I just use the
standard build of mysql 3.23.51? (Wondering about both Windows and
Linus, though the answer should be the same in both places)
2.
What's the best Wind
* Dave Beck
> > ...and some bytes may represent an 'illegal' character, and thus must be
> > escaped by a backslash... this goes for the quote character you
> > use (" or '), the backslash character itself, and null bytes.
>
> Thanks, if I use mysql_real_query is this still the case?
The doc's on
Hi.
I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3.
Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat
387fbff
Ram: 128M
I configured using:
CC=gcc CXX=gcc CXXFLAGS=-O ./configure --prefix=/usr/local/mysql --with-extra-
charsets=complex
and ran "mak
Lou,
I tested this on our SunOS-5.8 Sparc computer with 3.23.49:
bash-2.03$ df
/ (/dev/dsk/c0t0d0s0 ): 7499474 blocks 2033414 files
/proc (/proc ): 0 blocks 5861 files
/dev/fd(fd): 0 blocks0 files
/etc
At 18:54 + 7/2/02, Matthew Hajda wrote:
>Hello,
>
>I am having some issues inserting and updating with mySQL.
You're not testing the result from mysql_query() to see whether not
it succeeds. Do so, and they print the result from mysql_error()
in the event of failure to see what it says.
>
>
At 15:55 -0500 7/2/02, Pushkar Pradhan wrote:
>That's right, I install all other stuff the same way. I also forgot to
>mention I am not an admin, so I install everything in my own disk space on
>the n/w.
>Isn't that okay?
From the error that you're getting, pretty clearly it's not okay the way
y
At 23:52 +0300 7/2/02, Hytham Shehab wrote:
>hi guys,
> i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and
>c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be :
>innodb_data_file_path=c:/mysql/data/ibdata:300M
>then, when i restart the server and start the cl
At 19:31 +0200 7/2/02, Petre Agenbag wrote:
>Thanks,
>So, if you install MySQL MAX, you can use either myisam OR innodb /
>bdb tables, ie, if I install ONE mysql max server, then different
>users on the server can use different types of tables(innodb/myisam)
>as they choose?, also, if you creat
> ...and some bytes may represent an 'illegal' character, and thus must be
> escaped by a backslash... this goes for the quote character you use (" or
> '), the backslash character itself, and null bytes.
Thanks, if I use mysql_real_query is this still the case?
--
David A. C. Beck
[EMAIL PROTEC
That's right, I install all other stuff the same way. I also forgot to
mention I am not an admin, so I install everything in my own disk space on
the n/w.
Isn't that okay?
> It looks like you configured it to install in the source directory.
>
> Pushkar Pradhan wrote:
>
> >I used gnu's make as rec
hi guys,
i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and
c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be :
innodb_data_file_path=c:/mysql/data/ibdata:300M
then, when i restart the server and start the client, i type:
show variables like "have_%";
--
It looks like you configured it to install in the source directory.
Pushkar Pradhan wrote:
>I used gnu's make as recommended, make was successful, however gmake
>install gives the foll. error:
> /usr/local/gnu/bin/install -c copy-db
>/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db
>/usr
> -Original Message-
> From: Kristen J. McFadden [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 02, 2002 10:25 PM
> To: [EMAIL PROTECTED]
> Subject: problems on solaris machine
>
[sql]
> However, the system keeps dying due to an OS error.
> problem with the size of this database. A
We have mySQL running on a Sun Solaris machine and we are starting to have some
problems.
We just put a new 40GB drive into the machine which was expressly for mySQL. We then
tar'd the whole mysql over to this new drive and then checked all the references..
everything looks good and it does i
I used gnu's make as recommended, make was successful, however gmake
install gives the foll. error:
/usr/local/gnu/bin/install -c copy-db
/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db
/usr/local/gnu/bin/install: `copy-db' and
`/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' ar
There are commercial packages that do the conversion quickly and easily.
The best one is obscenely expensive (the price isn't on the website, you
have to write and request a quote, and a sales rep get back. I think it was
around $3000. I don't remember the name of the software, because it was so
chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] wrote:
>>Description:
>>
> When starting safe_mysqld mysqld shutsdown immediately with no error
>message. However looking at /var/lib/mysql/matrix.err gives the following
>error messages:-
>mysqld started
>/usr/libexec/mysqld: can't find
>Description:
When starting safe_mysqld mysqld shutsdown immediately with no error
message. However looking at /var/lib/mysql/matrix.err gives the following
error messages:-
mysqld started
/usr/libexec/mysqld: can't find file: './mysql/host.frm' errno: 13
mysqld ended
/var/lib/mysql/my
I wasn't entirely sure what you wanted - do you want to change the
table's column names? If so, then do what the message below suggests.
And yes, you can do it all in one query:
alter table mytest
change my_1 my_file_1 varchar(5),
change my_2 my_file_2 varchar(5),
...and so on
Hi, Matthew,
Have you tried:
"insert into test (test) values ('work')"
Or
"update test set test='test'"
I liked it when Matthew Hajda wrote this to me:
> Hello,
>
> I am having some issues inserting and updating with mySQL.
>
> Database: asdf
> Table: test
> field: idfield (int, autoincrem
Thanks for the response.
I set LDFLAGS and CCFLAGS for compiles and then it configured OK, I am
out of practice porting compiled software.
./configure --prefix=/export/home/mysql
--with-unix-socket-path=/var/tmp/mysql.sock --enable-thread-safe-client
--with-berkeley-db --enable-local-infile --w
Hello,
I am having some issues inserting and updating with mySQL.
Database: asdf
Table: test
field: idfield (int, autoincrement)
field: test (char)
the query: insert into test set test = 'test' ;
used in mascon or DBvisualizer correctly inserts the record.
however, when
thanx for ur mail, m sorry in dint mention that infact its a big table...
Is there a way i can do it in all the columns using only one query ??
thanx
anil
- Original Message -
From: "nellA hciR" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday,
mysql> create table mytest (
-> my_1 varchar(5)
-> );
Query OK, 0 rows affected (0.32 sec)
mysql> alter table mytest change my_1 my_file_1 varchar(5);
Query OK, 0 rows affected (0.23 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show columns from mytest;
+---++
No response from the first post, so here goes for one more try...
My employer recently acquired an existing web site that uses a MicroSoft
SQL database and I've been directed to get it running on an in-house
server. As we don't have any Windows servers, I need to recreate the
database in MySQL. T
At 12:32 2/7/2002 +0200, =?iso-8859-2?Q?Planka_Tom=E1=B9?= wrote:
Hi,
>Hello,
>can you send me a conntact (e-mail) to author of windows binary
>distribution of mySQL server, please? I have one question to him (about
>charset conversion in czech language, specially in windows distribution)...
>T
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Blue Presley wrote:
| okay, so my tables have to be of type InnoDB. Is there a
configuration file
| somewhere where i can specify that all my tables be InnoDB so I don't have
| to keep manually specifying the type?
|
Add "set-variable= default-t
Hi!
On Jul 02, Thomas Spahni wrote:
> Hi,
>
> I am indexing texts in German, French or Italian
> language. I want to add words from these languages to the
> stopword list and need some more guidance:
>
> - case doesn't matter, right?
yes.
> - what should I do with words containing non ascii c
Thanks,
So, if you install MySQL MAX, you can use either myisam OR innodb / bdb
tables, ie, if I install ONE mysql max server, then different users on
the server can use different types of tables(innodb/myisam) as they
choose?, also, if you create one db, can you have different types of
tables
in my table a column has enties
my_1
my_4
my_5
i wnat to change it to
my_file_1
my_file_4
my_file_5
can someone please tell me the query for that.
thanx
anil
-
Before posting, please check:
http://www.mysql.com/manual
On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote:
> Hi
>
> We have just moved out test server from RedHat to Debian.
>
> We have used the backup tapes to recover the data, and all went well to until
> we tried to connect via a host name.
>
> For example
>
> mysql test -utest_user
> A slave can only have one master.
You obviously don't work around here. :-)
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Subject: Re: Multiple masters to 1 slave??
On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote:
>
> In the my.cnf file on the off-sit
okay, so my tables have to be of type InnoDB. Is there a configuration file
somewhere where i can specify that all my tables be InnoDB so I don't have
to keep manually specifying the type?
blue
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tue
Hi
We have just moved out test server from RedHat to Debian.
We have used the backup tapes to recover the data, and all went well to until
we tried to connect via a host name.
For example
mysql test -utest_user -ptest_passwd
works fine, but
mysql -hserver -utest_user -ptest_passwd
reports
On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote:
>
> In the my.cnf file on the off-site slave, can there be multiple masters
> specified where it will replicate all 3 in-house servers to different
> databases on itself?
No. A slave can only have one master.
Jeremy
--
Jeremy D. Za
In SuSE you should be able to start the MySQL server by:
rcmysql start
or
rcmysql restart
rcmysql is a symlink to the /etc/init.d directory
-Original Message-
From: John Macloy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 2:26 AM
To: [EMAIL PROTECTED]
Subject: AW: AW: mysql
I'm trying to find a way to set up an off-site replication (slave 3). In
house I have several MySQL 4.0 servers that are using replication. They
consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized
web access and 1 slave (slave 2) for the internal database app. Both
slave
select u.userid , c.companyname from
users u left join company c on (u.companyid = c.companyid)
where u.status = 'ACT'
Best regards,
Mikhail.
- Original Message -
From: "Arul" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 5:15 PM
Subject: help me with
Alexander,
Tuesday, July 02, 2002, 5:54:48 PM, you wrote:
AB> I would like to know what does mean the privilege
AB> "References_priv" on the table users??
It's for future features...
If you will grant references_priv, user can create foreign keys.
--
For technical support contracts, goto ht
Blue,
Tuesday, July 02, 2002, 5:54:32 PM, you wrote:
BP> does mysql 3.23 support cascading and referential integrity or is this only
BP> part of 4.01? if so, how do i take advantage of it and where in the
BP> documenation (link) can I read about it?
Yes, MySQL supports foreign key constraints f
At 11:54 -0300 7/2/02, Alexander Burbello wrote:
>I would like to know what does mean the privilege
>"References_priv" on the table users??
It's unused.
>
>Regards
>
>Alexander
>
>
>
>
>sql, query
-
Before posting, please chec
Dear All,
I am stumped on this report.
I just need an idea and help to do this in MySQL.
To simplify my actual database, I am using an example.
Database fields - salesperson,date,visited company industry type
salespersons - a,b,c,d,e (can be 10 salesperson or 20 salesperson)
visited company in
Hi All
I have two tables User and Company
User tables has userid , companyid and status
Company table has companyid and companyname
It's not necessary that all users should have company.There can be users
without company also and for them the companyid is null.
so i need all the users whose st
I would like to know what does mean the privilege
"References_priv" on the table users??
Regards
Alexander
sql, query
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/
does mysql 3.23 support cascading and referential integrity or is this only
part of 4.01? if so, how do i take advantage of it and where in the
documenation (link) can I read about it?
thanks,
blue
-
Before posting, please che
Is it practical to use the builtin MySQL replication to have a MySQL server
on a laptop that syncs to the LAN Database Master when it is connected?
Are there any configuration issues that I should be aware of?
-
Before posting,
Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that
sounds novice or in wrong place.I'm facing the following situation:
For some reason, i had to use a backup of the database.Because of the
difference in time between my backup and the instance i had to use it,i
w
Hi!
I have to correct: if you put
[mysqld]
skip-innodb
skip-bdb
to your my.cnf, then -Max uses only about 1.5 MB more memory than plain
MySQL, because of a larger executable.
MyISAM tables in -Max are as reliable as in plain MySQL. It is the same
source code.
Best regards,
Heikki
Innobase Oy
Page,
Monday, July 01, 2002, 7:48:00 PM, you wrote:
PWWS>anyone know why this error would come up. This is running on a Linux box
PWWS> [admin admin]$ scripts/mysql_install_db
PWWS> bash: scripts/mysql_install_db: No such file or directory
Check where is your mysql_install_db located:
Jason,
Tuesday, July 02, 2002, 1:14:29 AM, you wrote:
J> I ran this on several of my tables... I expected it to give me reccomendations on
how to improve my tables performance...
J> SELECT * FROM `5323` PROCEDURE ANALYSE()
J> It returned no results ever am I doing something wrong? Or, is
Petre,
Monday, July 01, 2002, 9:26:49 AM, you wrote:
PA> Probably a stupid question, but which is best to have on ones server,
PA> the "old" mysql, or max. I.O.W, if you install MAX and never use innodb
PA> or berkeley tables, will it be equivalent to a normal mysql installation
PA> wrt perform
Arul,
Monday, July 01, 2002, 3:58:48 PM, you wrote:
A> Can i use left outer join in MySQL.
A> Like i have one condition in Oracle
A> ex:
A> select * from user,company where u.companyid = c.companyid (+)
A> can i rephrase the query in mysql like this
A> select * from user left outer join compa
Hi!
On Jul 02, Thomas Spahni wrote:
> On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote:
>
> > Download the 4.0.2 source and compile it.
> > Things seem to work a lot better with the 4.0.2. And it won't crash with
> > special combinations of words :)
>
> Hi,
>
> Some things with BOOLEAN MODE s
Hi,
I am indexing texts in German, French or Italian
language. I want to add words from these languages to the
stopword list and need some more guidance:
- case doesn't matter, right?
- what should I do with words containing non ascii characters
'äöüéàè' ? Enter as is?
- is there any perform
The Document at www.mysql.com/manual
is not clear for a Mysql beginner like me...
Any Step by Step procedure...
What should i do with the downloaded tar file ..
I Had installed MySql in Windows..
But installing it in Solaris is not clear...
-Arul
- Original Message -
From: "Arul" <[E
Hi All
Can anyone refer me to any document which speaks about Installing MySQL
3.23.51 on Solaris 2.8 Sparc
-Arul
sql , query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
All: I am re-posting this in case someone may have an answer.
RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support
Has anyone had any specific experience implementing a RAW DEVICE InnoDB
tablespace under Sparc Solaris?
A specific few lines in my.cnf would be very helpful...
As we are using
On Mon, 2002-07-01 at 22:23, Jeremy Zawodny wrote:
> On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote:
> > Hi all,
> >
> >
> > I want to setup (on linux systems) a pair of redundant mysql servers,
> > working this way :
> > * one master and one backup
> > * the master h
>
> There are several reasons why you should consider not storing
> binary data in
> your database:
>
> [snip]
>
> You probably have several reasons why you would want to store
> your images in
> your database, despite all the statements above. Others have,
> before you. And
> they have all return
Cams Ismael writes:
> Hello Sinisa,
>
> this has nothing to do with services. I have also tried this without
> creating a service and the result is the same.
> Normally the services are also stopped automatically when logging of, so I
> don't understand why I should stop it manually. Also I have
> plus are you sure you're reading the latest manual? it is chapter 6.8.
The location was correct for the onlien manual. I first tried my stored PDf
version, since I could not reach http://www.mysql.com
There, it was section 24.2. Now I printed then online section 6.8 and will
go through it.
My
On Tue, 2 Jul 2002, Erlend Hopsø Strømsvik wrote:
> Download the 4.0.2 source and compile it.
> Things seem to work a lot better with the 4.0.2. And it won't crash with
> special combinations of words :)
Hi,
Some things with BOOLEAN MODE seem still broken. Especially the '*'
jokers. I have 4.
Op maandag 1 juli 2002 14:18, schreef andy:
> Hi there,
>
> I am wondering if anybody has experiance in saving images to blob in mysql.
>
> I do save images with 1 K and 4 KB to blob fields while I used to save them
> to file. It seams to me that this is much slower accessing the files. The
> imag
Yea Andreas
I had that idea but i thought that would be a performance issue...
So i thought of avoiding this temp table...
I am looking into an option where i can do it in 1 single query...
-Arul
- Original Message -
From: "Oswald, Andreas" <[EMAIL PROTECTED]>
To: "'Arul'" <[EMAIL PROTEC
Hello,
can you send me a conntact (e-mail) to author of windows binary distribution of mySQL
server, please? I have one question to him (about charset conversion in czech
language, specially in windows distribution)...
Thank you very much!
Tom Planka
1 - 100 of 123 matches
Mail list logo
