to us,
the kapper.net::administration ;-)
[EMAIL PROTECTED]
[...deutsche version am beginn...]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi everyone,
This is my first project in MySql database. I use VB.Net and OleDb to connect
to MySql(5.0.1 alpha-max). When I call the stored produce, I get the error
message:
ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-max]You have an error
in your SQL syntax. Check th
Hi Guys,
Firstly, this is the only time I have ever encountered this problem and
searching archives or google shed no luck since yesterday so here I am .
I have a table described below:
mysql> describe containers;
+++--+-+-+
mation about this in the MySQL Reference Manual:
>
> http://www.mysql.com/doc/en/Upgrading-from-4.0.html
> http://www.mysql.com/doc/en/Upgrading-grant-tables.html
> http://www.mysql.com/doc/en/Password_hashing.html
>
> --
> Paul DuBois, Senior Technical Writer
> Madis
Hi groups,
does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new
passwords?
When I create a password using PASSWORD( ), I can only login using the MySQL client
(the one that comes with MySQL).
But if I create the password using OLD_PASSWORD( ), I can login from both my
Hi group,
I have a problem that I think is not very serious.
All the MySQL 4.1 binaries I downloaded from the MySQL website appear to be
max versions!!!
Ok, their names are mysqld-nt, mysqld, ... but when I do
SELECT version() I always get something containing a MAX thing.
I remember
/www.artshoptoolbox.com/
>
> We create content management systems for
> the rest of us, starting at $25.00 a month,
> includes domain registration, web hosting,
> email and webmail. Great for Yoga Teachers,
> Massage Therapists, Lawyers, Doctors,
> and any profess
hing in DB table and restart.
Hope this helps.
Thanks
Emery
- Original Message -
From: "m i l e s" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Saturday, November 29, 2003 02:26
Subject: Re: MySQL users.
> Emeyr
>
l.exe will login without any problem.
I think it's a compatibility issue.
Thanks
Emery
- Original Message -
From: abaid al-mutairy
To: Director General: NEFACOMP
Sent: Saturday, November 29, 2003 08:30
Subject: Re: MyODBC and MySQL 4.1
To create a new user use
Hi group,
This is not a problem as such but a limitation.
I have a problem with downloading MySQL due to its download size.
Can someone tell me where I can get MySQL in separate files?
For example I am interested in only the standard MySQL binary for WinNT (mysqld-nt.exe)
But, I cannot find where
I have found the issue.
It is talked about at the URL
http://www.mysql.com/doc/en/Password_hashing.html
The question now is When Will MyODBC support that new hashing?
Thanks
Emery
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "abai
Hi group,
I want to do a LEFT JOIN that takes no condition.
For example I have the following tables:
table_1table_2
--- -
1A
2
4.1 on Linux. The "mysql_fix _privilege_tables" is the
> problem, I think. What can I do??
>
> Fernando Gomes Bernardino
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL
For those who are interested like me:
MySQL 4.1.1 is released.
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTECTED]
http://www.nef
gt; Does anybody know what's happening?
>
> Reserved word?
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
> --
> MySQL Gen
uent in Access, you would
> probably be better off using that for your GUI. You connect to the data
> via ODBC or OleDB, and then use the data normally. And if you ever
> move away from the world of Windows development, there are several
> choices on Linux and OS X that I'm sure others
KEY `ID` (`ID`)
> )
>
> And code to input data into the table:
>
> INSERT INTO cart (
> Field1,
> Field2,
> Field3 )
> VALUES ( '1', '1', '2')
>
>
> How do I make "Field3" a calculation, which equals 2 if fiel
function mysql_real_connect(). Please guide me to URL which will give
values for using mysql_real_function.
>
>
>
> I am have installed mysql as follows :
>
> MySQL-client-4.1.1-0.i386.rpm
> MySQL-server-4.1.1-1.i386.rpm
>
> Help appreciated.
>
>
>
>
>
>
>
>
> I don't know what should be values
>
>
>
>
>
>
>
>
>
>
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Photos - Get your photo on the big screen in Times Square
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
09 (server2)
> Programmer accesses server1 okay from his location, but cannot access
> server2. He will be moving data from server1 to the new server2.
> Error msg: error no. Can't conect to mysql server at '192.168.0.15'
> (10061).
>
>
> Thanks
> --
>
Just to wish you a prosperous new Year.
My wishes go to the special guys of the MySQL and related software development team[s].
May the coming year bring you happiness and more innovative and productive ideas.
May your families be the happiest on this earth!
May this year protect you against homo
x27;m not the only one here.
> It would've been easier with underscored or different colours here... I
> guess ;-)
>
> _____
> Hitta rätt köpare på MSN Köp & Sälj http://www.msn.se/koposalj
>
>
>
in the environment
> > remain fixed.
> >
> > What does everyone else think?
>
> I fully agree with the part about performance and the number of
> files. :-)
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQ
Hi group,
Does anyone know of a simple way of knowing the real size of a column.
Currently I am interested in knowing the size of data stored in a BLOB column.
I have tried BIT_LENGTH() but this one does not seem to return the real size.
Thanks,
__
NZEYIMANA Emery
ent: Thursday, January 08, 2004 18:06
Subject: Re: Knowing the real size of a column
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> > Does anyone know of a simple way of knowing the real size of a column.
> > Currently I am interested in knowing the s
: "robert_rowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 19:29
Subject: Re: Knowing the real size of a column
>
> If you are using ADO then the field object has an actualsize property that
should give you your value.
>
> --
ses.
I don't think odbc is available via the hosted webspace so I may have to
export the data periodically to the MS Access database using
cron/scheduling.
Any recommendations?
Matthew McNicol
-
yellowmarker.co.uk
[information technology]
--
MyS
I think there is a bug in LPAD() function.
Just try to run this query:
SELECT LPAD(12, 3, '0');
This will correctly return 012 as expected.
But when I run
SELECT LPAD(512, 3, '0');
It doesn't return 512, instead it returns special characters.
With that situation I
> be sure that it did in fact update the tables?
> --
> -
> Scott HanedaTel: 415.898.2602
> http://www.newgeo.com Fax: 313.557.5052
> [EMAIL PROTECTED]
CTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 12:36
Subject: Re: Problem with LPAD() function
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> > I think there is a bug in LPAD() function.
> >
> > Just try to run this quer
Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1
When the SUB-SELECT contains more than one field, it does not work (this works very
well with 4.1.0 )
For example:
SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2)
The above quer
Hi group?
What do you recommend someone who wants to install MySQL on RedHat?
Using RPMs or installing from SOURCE?
What are the main differences and/or benefits?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone:
Hi group,
Is there anything I need to set in MySQL in order to use USER variables?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTE
Will someone tell me the real difference between FLOAT numbers and DECIMAL numbers?
What are the implications when I use either of those types?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office
change the character set?
Thanks
Emery
- Original Message -
From: "Petr Vileta" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Tuesday, September 23, 2003 01:45
Subject: Re: Using SQL variables
> > Can someone tell me w
luck
>
> "SELECT Max(id) FROM (select id from myTable where infoId in
> ( 3 ) AND id > 100 order by id ASC LIMIT 50) AS t1 "
>
>
> Thanx in advance
>
> Best Regards
> Wajih
>
>
> --
> MySQL General Mailing List
> For list archives: http://l
thinks ``:='' is a NULL character. Maybe it's a problem with the
character set.
Thanks
Emery
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Cc: "Petr Vileta" <[EMAI
, AnotherField FROM
any_table_with_records;
Thanks
Emery
- Original Message -
From: "Petr Vileta" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Tuesday, September 23, 2003 18:55
Subject: Re: Using SQL variables
> > Can you
from table where ...
> so doing this char by char I get the entire string.
> But the problem is that I haven't found the way to execute that
> ascii(mid(...)) function on the result of "desc table" or "show tables"
etc
>
> Anyone sees something ?
>
> Phi
://www.westernunion.com)
Thanks
Emery
- Original Message -
From: "Petr Vileta" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 03:47
Subject: Re: Using SQL variables
In mysql.exe type query and Enter
Hi groups,
I need some experienced users to guide me on this issue.
I am developping an Application that will be accessing a MySQL database through MyODBC.
The application is developped using Visual Basic.
Since my application will be used simultaneously by more than 200 users, I want to
know th
1?
Thanks
Emery
- Original Message -
From: "Dan Greene" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 18:17
Subject: RE: Ideas on creatin
I never use DAO.
Is there any benefit over ADO?
Thanks
Emery
- Original Message -
From: "Roger Davis" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, Se
Just wanted to know if anyone knows the status of the MySQL powered Mailserver found
at http://www.mysql.com/portal/software/item-239.html
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax:
rienced
> in the past. Your experience may vary. Void where prohibited.
>
> Roger
>
> > -Original Message-
> > From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, September 25, 2003 12:48 PM
> > To: Roger Davis; [EMAIL PROTECTED]; [EM
compiler, and learn how to use them to get an
OBCD driver that will work with our server?
Thanks
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: h
und
> Your message does not contain a valid command for this mail server
> to process. No action has been taken.
>
> Message-Id: <[EMAIL PROTECTED]>
> From: [EMAIL PROTECTED]
> Time-Stamp: Thu, 25 Sep 2003 19:40:58 +0200
>
> : Message contains [1] file attachments
&
It seems the developpers are no longer doing any work on this server. Their
website is empty: http://www.halvar.com/
Thanks
Emery
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PR
select...
> It looks like i can only excecut one single SQL statement... does any one
> know how to fix that?
>
> I can run the code with out problems using MySQL Control Center.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you very much.
Emery
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 21:28
Subject: Re: MySQL powered MailServer
>
hown in the book, but I get an
error. I took a screenshot (I thought that would be easier) and posted it
here:
http://hostultra.org/brewer/mysql.jpg
Any help would be very much so appreciated, thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
The problem is not when sending FLOTs to the server, but it when RECEIVING
floats FROM the server.
Thanks
Emery
- Original Message -
From: "Mike R. Duncan" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]&g
ically I need to be able to produce a list of all the players that
> appear in the first query ($teamqry) EXCEPT those that appear in the
> second ($squadqry).
>
> Help!?!?!??!
>
> Thanks very much,
> Matt
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
so curious why people need more databases while they can
> create as many tables as they need in 1 database?
>
>
> cheers,
>
> feng
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysq
Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQ
e more package i should install,can you please
> > tell the name and where can i find it?
> >
> >redhat8.0
> >mysql 4.0.15
> > thanks
> >
> > __
> > D
> the tables in a database without having to exit just like what I did
above?
>
> Thanks for your time.
>
>
>
> cheers,
>
> feng
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
advance
> Luiz
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03
>
>
> --
> MySQL General Mailing List
> For list archives: http://lis
c)
>
> mysql> insert into foo.bar select id from foo.bar;
> ERROR 1066: Not unique table/alias: 'bar'
> mysql>
>
> --
>Being normal is vastly over rated : Ted Leung
>
> --
> MySQL General Mailing List
> For list arch
Hi group?
Suppose I run a query by mistake that for example deletes my records.
Is there a way to go back to a previous state?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 1
te
> > the table names so it doesn't treat them as sql commands?
> >
> > /local_a/servers/mysql/bin/mysqldump: Got error: 1064: You have an error
in your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near 'order READ
; > mysql>
>
> This error seems to support that idea - although its not a particularly
> friendly way of saying it. Try creating another table, and do the
> select from that.
>
> Hope this helps!
>
> David P
>
>
> --
> MySQL General Mailing List
ust like the
old
> days on windows box.
>
> Or is there anyway to add user/password for that particular database so
that
> only that single user can access to that db ?
>
>
> Thanks
>
>
>
>
>
>
--
eady have value 'foo' in the column
'product' which is defined as primary key.
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__ ___ ___ __
>
From: "Antony Dovgal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 13:28
Subject: Re: 'IF NOT EXISTS' ignored?
> On Mon, 29 Sep 2003 12:30:28 +0200
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> &g
From: "Antony Dovgal" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 15:23
Subject: Re: 'IF NOT EXISTS' ignored?
> On Mon, 29 Sep 2003 15:16:57 +0200
> "
__
> Add MSN 8 Internet Software to your existing Internet access and enjoy
> patented spam protection and more. Sign up now!
> http://join.msn.com/?page=dept/byoa
>
>
> --
> MySQL General Mailing List
> For list arch
I am sorry, the instruction I sent doesn't work in MySQL:
You should use: INSERT INTO your_table (field1, field2, field3)
VALUES(CURDATE(), "value2", CURTIME())
Note the CUR (I think it stands for CURrent)
Thanks
Emery
- Original Message -
From: "Director Genera
Hi group,
I have two questions about error messages in MySQL.
1. Section 4.6.2 talks about Non-English error messages. It says that for recompiling
the errmsg.sys file, one will issue a comp_err command at the SHELL prompt.
Does such a utility exist for Windows? I mean can someone tell me when t
Hi Group,
I want to use a UNION in order to SELECT columns from several tables but I wish MySQL
could use the following syntax:
SELECT {several fields} FROM (Table1 UNION Table2 UNION Table3 . ) WHERE condition
Currently I think MySQL only supports the following:
(SELECT {several fields} F
oo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing
nd out if there are any rows with the
> date that I am searching for in the 'date' column. Would the fastest way
> be to use
> $date=2003-02-16;
> SELECT COUNT(*) FROM `games` WHERE `date`='$date'
> or is there a faster way?
>
>
> --
> MySQL Gen
Hi group,
I have read in the MySQL manual that the client/Server Compression protocol adds some
security to the application.
Does anyone have more information on this?
Thanks,
__
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 11:21
Subject: Re: error messages in different languages
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> >
> > I have two questions about error messages in MySQL.
> >
> > 1.
mmar :-( but you guys understand what i'm saying, right? :-)
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I use 4.0.14 and 4.1.0-Alpha
Thanks
Emery
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 07, 2003 16:45
Subject: Re: error messages in different languages
> "Director General: NEFAC
ool in that client.
Are you familiar with MS Access? If yes, you can use Access to work with
MySQL data.
If you have Access installed, just let me know and I will send you Step by
Step Instructions.
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To
hat is the correct syntax for using a Exponentiation operator in MySQL?
>
> BTW is this even posible?
>
> bye, Bob
>
>
>
>
>
>
>
> http://www.beheervisie.nl/disclaimer.
>
>
>
>
> --
> MySQL General Mailing List
> For list archive
Hi group,
I recently asked about Compression and security and got nice answers.
Now I have got a different question:
What are the disadvantage of using that client/server Compression protocol?
Does it increase speed? Does it decrease speed? Does it overload the server? The
client?
Any ideas
Thank you for the ideas. Very helpful.
Thanks
Emery
- Original Message -
From: "Danny Haworth" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 12:01
Subject: Re: Ideas on Compression Protocol
&g
- Original Message -
From: "Danny Haworth" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 14:41
Subject: Re: BLOB images in Crystal Reports
> I've had no problems with MySQL, crystal reports
ful (if this helps you, please let me know)
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 1
gt; > I have a select statement with a left join that will tell me the rows
that
> are in system A but not in system B (the target). Question is how to I
write
> a SQL statement to also insert these rows?
> >
> > System information.
> >
> > Windows NT4 (System A), W
gt; > This email is sponsored by Ensita.net http://www.ensita.net/
> >__ ___ ___ __
> > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> ><
your fstab. Remount (reboot to make
> sure it comes up mounted properly).
>
>
> -OR-
> you can change your datadir indicated in you're /etc/my.cnf file to let
> mysql know where your new data is on the new drive.
>
> -OR-
> you can use a simple symlink
>
&g
Hi Group,
I am wondering whether MySQL is planning to implement Group based privileges.
To make my question clear, consider a database where some users are not allowed to
update data and other are allowed to update. Will it be possible to create a group
that has got some privileges and whenever
hts are to change,
we will only change the GROUP rights instead of manually changing for every
user.
If I am not clear, I will rephrase the question again!
Thanks
Emery
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Des articles de Mike Hillyer peuvent t'aider.
Son site est http://www.vbmysql.com
Vous aurez besoin d'un Connecteur ODBC pour utiliser Visual Basic. MyODBC est tres
simple a utiliser. Il peut se telecharger depuis le site de MySQL
(http://www.mysql.com)
Mais le site est en Anglais.
I can ask and
ld=table2.field
>
> thanks
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
ssage -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 11:19
Subject: creating a new table from a SELECT
> how can i create a new table from a SELECT...WHERE... ?
>
> thanks
>
>
>
> --
> MySQL General Mailing List
> For list
Also check the [EMAIL PROTECTED] list.
It is very helpful
Thanks
Emery
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "scr informatiques" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 11:07
Hi group,
I just read the first news item on the MySQL website and thought some of you might
need to read about it as it is very interesting for those who use MySQL for hi end
transactions.
This gave me more powers in choosing MySQL as my favorite DBMS.
Just go to http://www.mysql.com or
http:
help me with this problem, i would greatly appreciate it.
>thanks in advance!
>
>
>---
>eric smith
>http:/m00q.tk - [EMAIL PROTECTED]
--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel
much on your own... Unless any documentation was included with the
> > > download, the only other thing around is the blurb on mysql.com
> >
> > In the MySQL 5.0 tree, the file Docs/sp-implemented.txt details the
> > current state of the stored procedures implementation.
om/doc/en/Miscellaneous_functions.html
> >
> > PASSWORD() should not be used for your own applications.
> >
> > --
> > Paul DuBois, Senior Technical Writer
> > Madison, Wisconsin, USA
> > MySQL AB, www.mysql.com
> >
> > Are you MySQL certified? http:
ot getting the result. please help me.
> > > >what's going wrong ?
> > > >
> > > >Thanks in advance
> > > >Manisha
> > >
> > > Please consider using something other than PASSWORD(), as noted in the
> > > description for
e question
>
>
> > I would like to know the circumstances in which a temporary table would
be
> > used. What is the rationale behind temporary tables? I have searched the
> > manual and the 'net but only find out information about creating or
> > manipulating them.
ger
> Global NAPs
> 10 Merrymount Rd
> Quincy, MA 02169
> Desk 617-507-5150
> VoIP 617-507-3550
> [EMAIL PROTECTED]
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com
smission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
entities
> other than the intended recipient is prohibited. If you received this in
> error, please contact the sender immediately and delete the material from
any
> compu
row | blah | blew |
> > +---+---+---+
> > | 1 | blah | blew |
> > | 2 | blah | blew |
> > | 3 | blah | blew |
> > | 4 | blah | blew |
> > +---+---+---+
>
> You can do:
>
> SELECT @a:=0;
> SELECT @a:[EMA
Hi group,
Someone asked a question about how he could change a column name and have his old
application continue using the same table while he is updating the client.
This means:
He has a table with columns: ColA, ColB and he is forced to change the columns names
into ColX, ColB and possibly the
1 - 100 of 123 matches
Mail list logo
