>-Original Message-
>From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com]
>Sent: Friday, December 17, 2010 10:35 AM
>To: Jerry Schwartz
>Cc: j...@consultorweb.cnt.br; mysql@lists.mysql.com
>Subject: Re: Access to MySQL
>
>Hi Jerry,
>
>On 12/17/20
Hi Jerry,
On 12/17/2010 09:34, Jerry Schwartz wrote:
-Original Message-
From: Jo�o C�ndido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, December 17, 2010 6:11 AM
To: mysql@lists.mysql.com
Subject: Re: Access to MySQL
What about this?
date_format(now(), "%Y/
>-Original Message-
>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
>Sent: Friday, December 17, 2010 6:11 AM
>To: mysql@lists.mysql.com
>Subject: Re: Access to MySQL
>
>What about this?
>
>date_format(now(), "%Y/%m/%d")
>
[JS]
>-Original Message-
>From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk]
>Sent: Friday, December 17, 2010 6:07 AM
>To: Jerry Schwartz
>Cc: 'MySQL'
>Subject: Re: Access to MySQL
>
>On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
>
>> I have to mo
What about this?
date_format(now(), "%Y/%m/%d")
--
João Cândido de Souza Neto
""Jerry Schwartz"" escreveu na mensagem
news:011201cb9d6c$eccc1e60$c6645b...@co.jp...
I have to move the back-end of an Access application to MySQL, and I've run
into one issue that I haven't been able to solve y
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
> I have to move the back-end of an Access application to MySQL, and Iâve run
> into one issue that I havenât been able to solve yet.
>
> The Access database stores dates as text in a â/mm/ddâ format. The
> problem is that the default
You ought to conect on localhost and create a new user with the specific ip
in the Host field.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> what I have to do to be able to access to mysql on my web server from
> other computer?
> e.g., I want to access to web server using My
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net <[EMAIL PROTECTED]> wrote:
> Hi Adam.
>
> I need to get all the data.
>
> Andrew
>
>
> Adam wrote:
>
> >Drew,
> >
> >That's vague. Specifically what do you want from th
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access database (e.g.
schema, data, etc.)?
A-
Hello.
It is a frequently asked question. Search in the list. For example see
thread:
http://lists.mysql.com/mysql/160391
Sebastian Luque <[EMAIL PROTECTED]> wrote:
> Dear List members,
>
> Having relatively recently moved to GNU/Debian Linux from Windows, I'd
> like to move my M
I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
> I'm coverting an Acc
PM
To: 'Charles Mabbott'; [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL
There are many tools. Use a gui. mysql front (free), premium soft (my
pick
but has a 29 day trial). There are also many small window applications
to do
this. Do a search at one of the famou
]]
Sent: Monday, December 16, 2002 1:45 PM
To: [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL
Yves,
I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.
In Access exported as .txt make sure tab sequential.
Back in M
Yves,
I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.
In Access exported as .txt make sure tab sequential.
Back in MySql I made database active that had 'member'
And did a:
>mysql load data infile "c:\\mysql\\tmp.txt" into member;
it actually
Search the archive!
Short answer:
export to .txt and import in mysql or use ODBC
B.
At 13:20 16-12-2002 -0400, Yves Arsenault wrote:
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
-
Take a look at MyODBC...
.mark
> -Original Message-
> From: Oladejo, Tokunboh [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 10:48 AM
> To: [EMAIL PROTECTED]
> Subject: Access to MySQL
>
>
> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting
> Microsoft
If your table(s) are already set to comply with MySQL's much stricter
formatting standards (e.g., spaces in field names, etc), then you can simply
create an ODBC connection and "export" your table to the MySQL database.
That does not always work, and does not always work well. But it is pretty
sim
This solution worked really well for me:
www.cynergi.net/exportsql/
Donna
On Friday 16 August 2002 6:48 pm, Oladejo, Tokunboh wrote:
> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting Microsoft access
> tables into MySql database.
>
> Thanx
> All
>
>
SELECT * INTO mysql_table IN ""
[ODBC;DSN=mysql_dsn;SERVER=localhost;UID=root;PWD=]
FROM access_table
You need myODBC and execute this in Access. Respect the double empty quotes.
- Original Message -
From: "Oladejo, Tokunboh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, Augu
look for a program called DBTools, best in it's category for this kinda
thing.
- Original Message -
From: "Ahmed Farouk" <[EMAIL PROTECTED]>
To: "César Aracena" <[EMAIL PROTECTED]>; "'MySQL General'"
<[EMAIL PROTECTED]>
Sen
just connect to Access using the odbc driver, then pull data from Access and
through it into MySQL, that's it :)
Ahmed
- Original Message -
From: "César Aracena" <[EMAIL PROTECTED]>
To: "'MySQL General'" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 10:04 PM
Subject: ACCESS to MySQL
Has anyone tried before to import data from an Access Table to a MySQL
Table? Actually, I just need to insert some of the columns and doing it
by hand seems quite a long thing to do?
I followed these instructions and it worked to a T
http://www.sbu.ac.uk/authoring/mysql/convert.shtml
Thank Yo
> cleopatra:/usr/bin # mysql -h localhost -u root -p
> Enter password:
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
> cleopatra:/usr/bin # mysql -h localhost -u root -p
> Enter password:
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Tr
Hello all,
I just installed a Suse 7.2 Linux, with MySql..
MySQL runs, but when i try to access it, i get the following message:
cleopatra:/usr/bin # mysql -h localhost -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
cleopatra:/usr/bin # mysq
The last time I checked, the windows version of PHP had MySQL support
built in.
Curtis
On Tue, 13 Nov 2001, mweb wrote:
> Hello,
>
> apart from performance issues, is it possible in PHP to read/write a
> MYSQL DB not directly, but via ODBC? The reason (as states in my other
> message "MS AC
Look for unixODBC on http://www.sourceforge.com
Peter
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 7:23 AM
To: phplist; mysqllist
Subject: Access to MYSQL via ODBC?
Hello,
apart from performance issues, is it possible in PHP to read/write
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:52 AM
> To: '[EMAIL PROTECTED]'
> Subject: Access to MySQL Column Type Error
>
>
> I'm trying to do an append query in A
Well I did the trace and it's about 2.81MBs. What exactly do you need out of
it? I didn't notice much help from it but then again I'm not very knowledge
in that area. Considering the size do you still want me to directly e-mail
it to you?
One other thing I forgot to mention was the data in the Fa
30 matches
Mail list logo
