That works, Emery. Thanks a lot.
Dummy me, I was wrong. Seems that Access is just a tool rather than a
Database, then what's the database behind M$ Access?
cheers,
feng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
One of the best things is to listen from diffrent opinions from different
people who have different backgrounds. :-)
cheers,
feng
- Original Message -
From: "DeBug" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
t: Wednesday, October 08, 2003 9:29 PM
Subject: RE: printing reports
> Please take this flame war off list.
> > -Original Message-
> > From: Wang Feng [mailto:[EMAIL PROTECTED]
> > Sent: 08 October 2003 11:31
> > To: Michael Haunzwickl; 'Dire
> So listen guy, this is a big miss understanding:
NO
> 1.) If you want to have an "easy way tool" for creating your reports -
> use MS Access
Hey, man, inserting a record is also ealier in Access. => You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy u
> So listen guy, this is a big miss understanding:
NO
> 1.) If you want to have an "easy way tool" for creating your reports -
> use MS Access
Hey, man, inserting a record is also ealier in Access. => You suggest me to
do everything in Access. You'r bad bad man!!!
-- Tools are for dummy u
cle, since Oracle is definitely not for dummy users, and then you can
laugh at everybody in this mailing list - dummy users.
Look, man, even you know I'm a dummy user, you don't have to say so on the
mailing list :-) Now people around the world know *Wang Feng* is a dummy
user, some of
thanks for your nice advice. *dummy users* --- let's see.
- Original Message -
From: "Michael Haunzwickl" <[EMAIL PROTECTED]>
To: "'Director General: NEFACOMP'" <[EMAIL PROTECTED]>; "'Wang Feng'"
<[EMAIL PROTECTED]&
> Unfortunately, they have not implemented a reporting tool in that client.
that's the problem, as I was trying to find some sql commands to edit the
report, such as report titles.
>Do you know some programming language? Like Visual Basic, C, C++, Java,
PHP,
i know them, but as I mentioned ear
Thanks Dave
That sounds good although I haven't installed them. I don't know if that
works to my OfficeXP or not. Seems better for me to get a RedHat 9.0
somewhere. :-)
cheers,
feng
- Original Message -
From: "Christensen, Dave" <[EMAIL PROTECTED]>
To: &qu
udy
>
>
> -Original Message-
> From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 7 oktober 2003 16:49
> To: Wang Feng; [EMAIL PROTECTED]
> Subject: Re: printing reports
>
> To get data from/into MySQL, you will always need a clie
> In MySQL, how can I create and print reports without the help of neither a
> scripting language(e.g. php) nor a thrid party software tool?
bad grammar :-( but you guys understand what i'm saying, right? :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
Greetings,
In MySQL, how can I create and print reports without the help of neither a
scripting language(e.g. php) nor a thrid party software tool?
I just couldn't find any commands for the printing function in MySQL.
Please advise. And please let me know how you print reports.
cheers,
feng
I guess that's because you don't have the privilege to create a database.
Make sure you're using the *right* account to create the database.
cheers,
feng
- Original Message -
From: "ddonahoe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:17 PM
Subject: New
Thanks Paul.
Fully understand!!
cheers,
feng
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 4:38 AM
Subject: Re: mysql account
> At 14:00
Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the
account info to the *user* table of the *mysql* database OR do you grant the
new account by the GRANT query? What are the differences andn which one do
you prefer?
(I got some trouble whe
Paul,
> I am assuming that the 'alan' account that you're planning to use has
> all privileges. Otherwise, you will find after flushing the privileges
> that you'll no longer be able to administer your server without starting
> it with the --skip-grant-tables option...
The *alan* account does h
e -
From: "Thada, Shantalaxmi (NIH/CC/PET)" <[EMAIL PROTECTED]>
To: "'Wang Feng '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 05, 2003 5:57 AM
Subject: RE: mysql account
>
> do u have a .my.cnf in c:\ dir or c:\windows d
Hi, folks.
I use WinXP + MySQL.
I deleted all the rows from the 'user' table of the 'mysql' database except
my own account (host: localhost, user: alan, password:alan). --- I was
hoping only I have the access to the MySQL databases.
The problem is that I still can login to MySQL by the DOS comma
18hrs??? So, the database has been LOCKED for 18hrs
- Original Message -
From: "Peer Reiser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 03, 2003 6:57 PM
Subject: Newbye speed question
> HI
>
> I am having a MYISAM database with 27 million rows and 19 fields
> As long as two databases are on the same disk you can also rename from one
> database to another:
> RENAME TABLE current_db.tbl_name TO other_db.tbl_name;
Works!! :-) But the thing is: by doing this, although the tables have been
*moved* from the old database to the new one, the old database
ySQL technical support from https://order.mysql.com/
>
>
> - Original Message -
> From: ""Wang Feng"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Wednesday, October 01, 2003 8:37 AM
> Subject: Re: can NOT drop the data
Not at all!!
after I typed the 'drop database my_account_database', I got the following
message:
> Query OK, 0 rows affected (0.00sec).
and I do the 'show databases', that one is still there.
cheers,
feng
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: W
Greetings,
I have a database called 'my_account_database' and I tried to drop it by the
command 'drop database my_account_database', it doesn't work. The database
is still there, can not be dropped although the tables contained in the
database have gone.
I subsequently created another 2 database
typo :(
correct: in Oracle, one have to use single quotes to enclose those values
which are going to be inserted. but in MySQL, doubl quotes do the job well.
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]
Folks, this is funny.
I've been using Oracle for several months, and started teaching myself MySQL
since last weekend. I'm currently using the MySQL version 3.23.49
I found something really interesting: In Oracle, I have to create the
Foreign Key in order to join 2 tables. It's quite different wh
It seems I'm on the *right* list. :-)
Thanks, Kelley.
The '\r\n' solves the problem. Yes, Kelly, you are right, I'm using WinXP.
Thanks again for that.
cheers,
feng
- Original Message -
From: "Kelley Lingerfelt" <[EMAIL PROTECTED]>
To: "Wa
cuss MySQL questions?
cheers,
feng
- Original Message -----
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 30, 2003 7:11 PM
Subject: loading data from a textfile into MySQL database table
> Greetings,
>
> I have a dat
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_namesalary
employee_namesalary
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name & salary as the columns;
I use the command
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_namesalary
employee_namesalary
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name & salary as the columns;
I use the command
Greetings,
I use WinXP and MySQL.
I have a customer table, which contains about 200 records.
Now I want to print all the records of the table out. How can I achieve
that?
Can I send them to a .doc OR .txt file before printing?
cheers,
feng
--
MySQL General Mailing List
For list archives:
Hi, folks.
What are the benefits of having several databases rather than just one? The
hosting companies usually charge more bucks if customers asked for more
databases. I'm so curious why people need more databases while they can
create as many tables as they need in 1 database?
cheers,
feng
That's cool, Leonardo. Thanks.
BTW, how can I show the structure of the table without 'changing' to that
database?
cheers,
feng
- Original Message -
From: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]&g
gt; > >c:\mysql\bin\mysql line 1
> > mysql>create database DB1line 2
> mysql>use DB1;
> > mysql>create table TB1(id char(3)); ---line 5
>
>
>
>
> - Original Message -
> From: "Wang Feng" <
Hi, folks.
I use Windows XP Pro, MySQL v.1.4
The following is how I access to MySQL and create a database and a table in
that database:
>c:\mysql\bin\mysql line 1
mysql>create database DB1line 2
mysql>quit -
34 matches
Mail list logo