Hello list
I'm trying
mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; -
-lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt
but i get an
Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using
table: programs
What I'm doing wrong?
RH-9 - APACHE
I just encountered this yesterday on my Macintosh, and it turned out that
user mysql did not have permission to write to the destination folder. I
simply had to change the permissions on that folder to include Read Write
access to user mysql.
-John
on 6/1/04 8:09 PM, [EMAIL PROTECTED] at
Hi All!
May be anyone can help in this situation:
Version: 4.1.2-alpha-nightly-20040523-log
OS : Linux
Show create table TEST:
CREATE TABLE `TEST` (
`ID` int(10) unsigned NOT NULL auto_increment,
`saturs` char(255) default NULL,
PRIMARY KEY (`ID`),
FULLTEXT KEY `sat` (`saturs`)
) ENGINE=MyISAM
Gidday. Is there anyway to convert an Advanced Revelations/Open Insight
database into a mySQL database.
Cheers,
Glenn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
There's got ot be something else wrong. I've got the exact same problem and
I have done a chmod 666 on the directory I am trying to write to with no
luck. I am running v4.0.15
/T
on 6/1/04 7:06, Egor Egorov at [EMAIL PROTECTED] wrote:
John Mistler [EMAIL PROTECTED] wrote:
Would there be any
Greg Willits [EMAIL PROTECTED] wrote:
I'm trying to force 4.1.2 to use the old short passwords for now during
some experimental stages.
The discussion here (specifically the fourth set of bullets):
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
and, this paragraph:
Mailing List Receiver [EMAIL PROTECTED] wrote:
mysql select bademail.email from bademail,noemail where bademail.email
noemail.email;
bademail has about 30,000 rows and noemail has 13,000.
This, by the way, does a good job of bringing your system to its knees!
You need something like:
Hello,
If the db has an ODBC driver then you can try SQLyog
from www.webyog.com
Karam
--- Glenn McCord [EMAIL PROTECTED] wrote:
Gidday. Is there anyway to convert an Advanced
Revelations/Open Insight
database into a mySQL database.
Cheers,
Glenn
--
MySQL General Mailing List
For
paqogomez [EMAIL PROTECTED] wrote:
I am trying to build a stored procedure in v. 5.
This is what I have so far.
delimiter |
create procedure get_id(out oid int)
begin
insert into mercury.merchant (name) values(null);
select last_insert_id() into @mid;
insert into
I don't see how you can possibly hope to satisfy two mutually dependent
constraints at the exact same time. It's a chicken-and-egg scenario. If you
can't create your vacancy record first (to get its PK value) you won't be
able to create the new record in your supervision table.
Most people solve
Dear my friends...
I don#t understand why subquery on my MySQL 4.0.18-Mas
does not valid.
Here what I have done.
[EMAIL PROTECTED]:~ mysql -h 192.168.23.1 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 354744 to server version:
I don#t understand why subquery on my MySQL 4.0.18-Mas
does not valid.
Simple reason: v. 4.0.18 does not support subqueries yet. Use 4.1 or later.
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Test it on 4.1.2 and let me know if these queries will crash
MySQL server.
Yes, the query
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
I have some code that's been in production for a few years and now is
presenting a problem. The following is on a mysql 3.23.38 server:
SELECT b.denewbs, b.dewrbtr, b.dekostl, b.desgtxt, b.deprojk,
b.degeber, b.de_heid, c.acdesdc, c.acfund
FROM headers a, details b, acctref c
WHERE
[EMAIL PROTECTED] wrote:
I don't see how you can possibly hope to satisfy two mutually dependent
constraints at the exact same time. It's a chicken-and-egg scenario. If you
can't create your vacancy record first (to get its PK value) you won't be
able to create the new record in your supervision
Hi All,
I have a problem. I have 2 tables:
mysql SELECT int_traffic.day, sum(int_traffic.deliveries) as deliveries
- FROM int_traffic
- WHERE int_traffic.day between '2004-05-01' and '2004-05-31'
- GROUP BY int_traffic.day
- ORDER BY int_traffic.day;
+++
nikos [EMAIL PROTECTED] wrote:
I'm trying
mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; -
-lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt
but i get an
Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using
table: programs
What
Dear Friends,
Considering what a backup is done with the method following:
1. One master server replicate to one slave server.
2. The master server handle all manipulations and transactions of
data (all tables are InnoDB type).
3. The slave server is exclusively used for
Have you tried using the IN operator?
SELECT denewbs, dewrbtr, dekostl, desgtxt, deprojk,
degeber, de_heid, acdesc, acfund
FROM (details INNER JOIN headers ON details.de_heid = headers.heid)
LEFT JOIN acctref ON acctref.acfund IN
(details.dekostl,details.deprojk,details.degeber)
WHERE
I've been studying MySQL for a few weeks now and am
about ready to publish some databases online. But I'm
confused about usernames and passwords. I understand
you can create usernames and passwords on three or
four different levels, like root, database, etc. As I
understand it, localhost is the
You have to look at the intermediate results of this to understand why your
sums are doubling up:
FROM daily_traffic
LEFT JOIN yell_int_traffic
ON daily_traffic.day = yell_int_traffic.day
WHERE daily_traffic.day BETWEEN '2004-05-01' AND '2004-05-31' and
daily_traffic.client in
CONTACT_X_CUSTOMER.ID_ADDRESS
CUSTOMER.ID_ADDRESS_SHIPTO
CUSTOMER.ID_ADDRESS_MAIN
What I would like is to be able to JOIN conditionally based on the absence/presence of
reference
SELECT ADDRESS.ID FROM CONTACT_X_CUSTOMER LEFT JOIN CUSTOMER ON
CONTACT_X_CUSTOMER.ID_CUSTOMER = CUSTOMER.ID
David,
Think of users as the concatenation of the user and the host from which the
user is connecting. That's why in your GRANT statement, you will see the
'user'@'host' semantic employed.
When you say 'localhost' you're telling MySQL that the user you are
specifying is connecting from the
At 7:22 -0700 6/2/04, David Blomstrom wrote:
I've been studying MySQL for a few weeks now and am
about ready to publish some databases online. But I'm
confused about usernames and passwords. I understand
you can create usernames and passwords on three or
four different levels, like root, database,
Ok, I got a result here, still trying to determine if its correct or not :)
LEFT JOIN ADDRESS ON IF(CONTACT_X_CUSTOMER.ID_ADDRESS 0,
CONTACT_X_CUSTOMER.ID_ADDRESS = ADDRESS.ID, IF(CUSTOMER.ID_ADDRESS_SHIPTO 0,
CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID))
Shawn, thank you - that did the trick.
-Mike
At 10:18 AM 6/2/2004, [EMAIL PROTECTED] wrote:
Have you tried using the IN operator?
SELECT denewbs, dewrbtr, dekostl, desgtxt, deprojk,
degeber, de_heid, acdesc, acfund
FROM (details INNER JOIN headers ON details.de_heid = headers.heid)
LEFT
Luc,
This looks like you want a list of all Customers with Contacts (because you
are basing it on the CONTACT_X_CUSTOMER table) and you want to show the
Address (if it exists) or the Shipping Address (if it exists) instead of
the Address? Am I close?
If I want to get one of two or more result
Sorry to reply to myslef but I just saw my own typo. Here is a better
example statement:
SELECT x.ID_ADDRESS, c.customerName, COALESCE(s.address, a.address,
'none') as address
FROM Customer c
INNER JOIN CONTACT_X_CUSTOMER x
ON c.ID = x.CUSTOMER_ID
LEFT JOIN Address a
ON a.ID =
Hello:
After an all nighter, and reading and trying as much as I can, I'm
completely stumped.
I'm running RedHat 9, Apache 2.0, SSL, mySQL 3.23, PHP-4.2.2
I can create and insert tables on the server command line.
I can run php coded pages residing on the server from a remote browser.
I can open
I remember something setting mine up. The phpMyAdmin.ini (I think) had to
have the correct IP address of the machine/database it was running on.
My machines internal address was 192.168.2.100, but the INI setting had to
be the outside resolved IP 24.16.xx.xx if running it from outside.
Hello:
hi
Have you changed the auth bits in config.inc.php in the phpMyAdmin
directory?? You need to tell phpMyAdmin how and who to connect to mysql
as. I can't remember the exact lines but there are 3 lines in the
'servers' section containing (I think) auth_type, user and password.
These need to be
--
Searchable archives for this list are available at
http://www.listsearch.com/mysql.lasso
--
Hello,
Maybe a solution to not allow a vacancy to be added without a supervisor
being assigned:
1. Create an atribute of the identification in the supervision table as
Primary Key (e.g. id_supervision).
2. Create column id_supervision in vacancy table as not null.
3. Create index in vacancy table
MySQL Server: 4.1.1 alpha
MySQL Control Center: 0.9.4 beta
I am not sure whether this is a Control Center or MySQL Server problem, but here it
goes:
I have a database with MyISAM tables created using character set UTF-8. I have
installed support for Chinese on my machine, and using MySQL
I saw the same problem with 5.0 alpha and Java/JDBC. The text was Chinese
characters in Java; the tables were created with default character set UTF8.
Seems only questions marks are stored.
Wondering if far-east characters in UTF8 are support by MySQL's UTF8
support?
-James
From: Silvio Lopes
Hi,
I am new to mysql and having some trouble with replication. Simple stuff like,
1. How to restart the stopped resplication,
2. How to check if the replication is working,
3. How to bring the slave into master status when master crashes,
4. How to restore master and re-enable
Can you display properly handle the Chinese characters? I would try to
verify that the correct unicode code is being stored.
-Original Message-
From: James Huang
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 6/2/04 11:45 AM
Subject: RE: Unicode characters become question marks
I saw
Yes. The source data were \u escaped in Java, and the data read out of
mysql were HTML-escaped into #12345; and set to browser; the browser does
display Chinese characters correctly.
From: Victor Pendleton [EMAIL PROTECTED]
To: 'James Huang ' [EMAIL PROTECTED],'[EMAIL PROTECTED] '
[EMAIL
i've read the ORDER BY optimization page in the manual but i'm stumped
by my inability to get this query to avoid the filesort.
the table structure is:
CREATE TABLE story (
id int(11) NOT NULL auto_increment,
headline text,
deck text,
free_override tinyint(1) NOT NULL default '0',
Yes, my display can handle the Chinese characters. I have also changed the application
font of MySQL Control Center to SimSun, which supports all the Chinese characters I am
using. When I type the characters in MySQL Control Center, I see the Chinese
characters. I edit a varchar field in an
-Original Message-
From: Ravi T
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:49 AM
Subject: Is there any good soul out there who can help me with mysql 4.0.17
replication.
Hi,
I am new to mysql and having some trouble with replication. Simple
stuff like,
1. How to restart the stopped
If you can type the character into the keyboard try this.
SELECT IF(col1=chinese-character, 1, 0)
Else try this from a java program
if (rset.getString(col1).equals(chinese-character))
{
System.out.println(match);
}
else
{System.out.println(invalid);
}
-Original Message-
From: Silvio
Victor,
I'm positive the database is storing ?'s. You may test with these steps:
1) insert \u7247\u4EEE\u540D into a UTF8 table;
2) Query and get it back into string s;
3) for each char c in s: System.out.println((int)c);
Thanks,
-James
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Silvio Lopes de
Hi,I would appreciate help with the following. I would like to be ableto initiate a
perl script that is residing on a linux server from anExcel workbook. I am working on
the Excel workbook in Windows. Iwould appreciate any pointers, sample code for
accomplishing this inVBA or some other
Okay, I tried the SELECT IF idea, but the results are a little ambiguous. Here is what
I typed:
SELECT IF(networkname=chinese-char, 1, 0) from networktable;
where networkname is a varchar column, and networktable is my table. The result of
this query is 1, which means it matched.
I also have an MFC app which reads data from this table, and displays it as '?'. Using
the debugger and its watch pane, I can see the app is reading '?' from the db. The app
handles strings in Chinese without problems elsewhere in the code, this issue only
comes up when reading from the db.
S
What does the explain plan look like? It sounds like the query is using the
fulltext index. Remember that only one index per table can be used when
performing a query.
-Original Message-
From: Jon Drukman
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:57 AM
Subject: avoiding Using filesort
i've
Annie Law wrote:
Hi,I would appreciate help with the following. I would like to be ableto initiate a
perl script that is residing on a linux server from anExcel workbook. I am working on
the Excel workbook in Windows. Iwould appreciate any pointers, sample code for
accomplishing this inVBA or
Victor Pendleton wrote:
What does the explain plan look like? It sounds like the query is using the
fulltext index. Remember that only one index per table can be used when
performing a query.
explain select id, headline, date_format(s.post_date,'%Y/%m/%d')
directory, post_date sort_date
from
I need some help connecting to my database remotely, I would really
appreciate any input.
Setup:
MySQL Server:
OS: Linux - Debian
MySQL version: 4.0.18
Internal IP: 192.168.1.101
Remote Access PC:
OS: Windows XP
MySQL: 4.0.20
Internal IP: 192.168.1.100
I am trying to connect from 192.168.1.100
Lou Olsten wrote, You do not have to put a user into
the system for every location from
which
you want to connect. Instead, you can use wildcards
like:
GRANT ON *.* to 'Newbie'@'196.168.168.%'
or maybe 'Newbie'@'%.yourdomain.com'
I don't know how to work with wildcards, but are you
Is each machine behind a firewall or are both machines behind the same
firewall? If the firewalls are different you will need to connect to the
firewall address and not the lan address. You will also need to ensure that
Port 3306 is open in the firewall.
-Original Message-
From: Fred
After spending days trying to make a PHP form for
editing my tables that actually works, I discovered a
wonderful script from www.dadabik.org. I haven't used
it online yet but I got it up and running on my
computer in about five minutes, and it appears to work
flawlessly.
There's just one catch.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
Victor,
I'm positive the database is storing ?'s. You may test with these steps:
1) insert \u7247\u4EEE\u540D into a UTF8 table;
James,
Have you set your JDBC driver's character set to be UTF-8 using the
characterEncoding
As horible as it looks, this is what I came out with...
SELECT CONTACT_X_CUSTOMER.ID, CONTACT.LastName AS 'Last Name', CONTACT.FirstName AS
'First Name', CONTACT_X_CUSTOMER.Email AS 'Email', CONTACT_X_CUSTOMER.Active AS
'Active', CONCAT(IF(CONTACT_X_CUSTOMER.ID_ADDRESS 0,
Hello ,
I'm working on a project with MySql 4.0.12-log.
I have a problem with insert .. select:
To describe the program of some touristic tours I create two tables:
TOUR that contains the data
TAPPE that contains the program of the tour.
(relation 1:n).
To keep track of each tour i create two
Thanks, Mark. This instills great confidence in me.
I used this URL:
jdbc:mysql://localhost/mydb?useUnicode=truecharacterEncoding=utf8
(should I use utf-8 perhaps?) Would this work, too?
What is
Connection utf8Conn = getConnectionWithProps(props);
in your test code? That doesn't look like a
Oops, that LEFT JOIN ADDRESS ON IF(etc...) shouldn't be in the big long select
statement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table where the date a record was added is recorded in the date
column. I can get count of how many records were entered on each day by
doing this
SELECT COUNT(*)
FROM table
GROUP BY date;
I can get a total number of records by doing
SELECT COUNT(*)
FROM table
but how do I find the
Fred Aswad wrote:
I need some help connecting to my database remotely, I would really
appreciate any input.
Setup:
MySQL Server:
OS: Linux - Debian
MySQL version: 4.0.18
Internal IP: 192.168.1.101
Remote Access PC:
OS: Windows XP
MySQL: 4.0.20
Internal IP: 192.168.1.100
I am trying to connect
I personally haven't tested with a Java app, but I experience this problem with both
MySQL Control Center and my C++ MFC app using ODBC Connector. Using the Visual C++
debugger, I can inspect the contents of the variables which receive the through the
debugger, and I only see question marks. If
After spending days trying to make a PHP form for
editing my tables that actually works, I discovered a
wonderful script from www.dadabik.org. I haven't used
it online yet but I got it up and running on my
computer in about five minutes, and it appears to work
flawlessly.
There's just one
This is probably something simple that I am just not seeing, but I
would appreciate your help.
As root, I have created a schema named test, along with several
tables.
I then created a template user named SysAdmin for test using the
following syntax.
GRANT SELECT, INSERT, UPDATE, DELETE
ON TEST
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Huang wrote:
Thanks, Mark. This instills great confidence in me.
I used this URL:
jdbc:mysql://localhost/mydb?useUnicode=truecharacterEncoding=utf8
(should I use utf-8 perhaps?) Would this work, too?
James,
Either should work, if you're
Hi! My name is Nicolas Pace, and i´m quite new in mysql.
This is the situation:
I have One table with 4 inverted-index fields.
I want to query the table which stores the inverted-index keywords.
I don´t know if it even exist, but i hope so!!
If doesn´t, is there another way to do this?
Thanks
--
I am trying to pull cst_SiteID from a query result to use in another query:
SELECT cst_Name,cst_SiteID FROM customers WHERE cst_Name LIKE 'st%'
+--++
| cst_Name | cst_SiteID |
SysAdmin only has rights to the TEST database. This user will need to be
able to update the mysql database tables and therefore will need access to
the mysql database.
-Original Message-
From: Robert Frame
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:15 AM
Subject: Granting privileges to other
At 9:15 -0700 6/2/04, Robert Frame wrote:
This is probably something simple that I am just not seeing, but I
would appreciate your help.
As root, I have created a schema named test, along with several
tables.
I then created a template user named SysAdmin for test using the
following syntax.
GRANT
How about
SELECT @total:=COUNT(*) FROM table;
SELECT date, COUNT(*)/@total AS average
FROM table GROUP BY date;
Michael
Chris W wrote:
I have a table where the date a record was added is recorded in the date
column. I can get count of how many records were entered on each day by
doing
Chris Dietzler wrote:
I am trying to pull cst_SiteID from a query result to use in another query:
SELECT cst_Name,cst_SiteID FROM customers WHERE cst_Name LIKE 'st%'
+--++
| cst_Name | cst_SiteID |
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Is it possible to select data from different Databases on Different
servers across the network?
I searched for information on how to do it, but i haven't found any.
thanks in advance
Alejandro
I'm a little out of my realm in asking this on behalf of someone else,
but here goes...
I finally got 4.1.2 working for me on OS X 10.3.4, but have a curious
performance snag.
If I connect to MySQL 4.1 via any one of three different GUI Control
Center type apps, all works fine.
If I connect
Actually, cst_SiteID is tied to assets owned by the customer in another
table. What I need to do is get the cst_SiteID and use it to get a list of
assets from the other table. I have created a successful search page for an
individual site id search, but now want to do a search by name, where
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 02 June 2004 01:57 pm, Oropeza Querejeta, Alejandro wrote:
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Select *
from db1.table
,db2.table blah blah..
Is it possible to
Yes Local.
SELECT databasename.tablename.columnname
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Is it possible to select data from different Databases on Different
servers across the network?
I searched for information on how to do it,
I think you need a join. You didn't provide much info about the second
table, so I'll pretend it's named assets with columns named host, ip, and
cst_SiteID. Something like
SELECT c.cst_Name, c.cst_SiteID, a.host, a.ip
FROM customers c, assets a
WHERE c.cst_SiteID = a.cst_SiteID
AND
You know, now I'm sure that the chars are getting stored as '?' as well. I tried the
test you suggested again, but with a small modification. I typed:
SELECT IF(networkname='?', 1, 0) from networktable;
and it returned 1. Because I used '?' instead of the chinese char and it matched,
You know, now I'm sure that the chars are getting stored as '?' as
well. I tried the test
you suggested again, but with a small modification. I typed:
SELECT IF(networkname='?', 1, 0) from networktable;
and it returned 1. Because I used '?' instead of the chinese char and
it
I'm trying to figure out how to get my MySQL databases
online. Someone told me to EXPORT my databases as SQL
files, then go into my online websites's phpMyAdmin
program and import it, and everything else would fall
into place.
At first, I was confused and exported just a single
table. I was able
I tried SELECT HEX(your_column) FROM your_table and indeed, only '?' is being stored
(3F hex, 63 decimal). Thanks for the hint regarding Unicode support in MyODBC, I'll
try to read more on it tomorrow. I've had enough frustrations for the day... :)
Thanks.
S Lopes
-Original Message-
Hi,
I am trying to get MsSQL working. I can't get the server to start.
I tried typing in mysql_install_db and got the following response:
linux:/home/nick # mysql_install_db
Installing all prepared tables
040602 5:54:02 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD
Have you tried this: bin/safe_mysqld --user=mysql ?
Or there is a script inside supporting called mysql.server, you can
start it up by typing mysql.server start
Hope this help!
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 .
I have a big database focusing on U.S. counties. I'd
like to assign each county a code for use as a key.
I'm thinking of simply using the state postal code,
followed by numerals.
For example, Arizona's counties would be arranged
alphabetically, beginning with az1, az2, az3, etc.
I just wondered
Using phpmyadmin, when I select Export, and click the checkbox Save as File, it
prompts where for where and what file name.
I'm trying to figure out how to get my MySQL databases
online. Someone told me to EXPORT my databases as SQL
files, then go into my online websites's phpMyAdmin
program
--- Daniel Clark [EMAIL PROTECTED] wrote:
Using phpmyadmin, when I select Export, and click
the checkbox Save as File, it prompts where for
where and what file name.
Aha - you nailed it. I wasn't checking the Save As
box because the SQL box above was already checked. I
tried it again, checking
I just got my first MySQL database online, but I have
some questions.
First, if I want to import a database named, say
username_jack, do I have to create a database named
username_jack online first? In other words, could I
access an online MySQL account that's empty, with no
databases, then just
Hi All,
I'm attempting to generate a report of page hits from both internal and
external IP addresses, from one table, using self join.
Some sample data:
++-+++
| hit_no | page_name | ip | hit_time |
At 1:22 + 6/3/04, Nick Mudge wrote:
Hi,
I am trying to get MsSQL working. I can't get the server to start.
I tried typing in mysql_install_db and got the following response:
linux:/home/nick # mysql_install_db
Installing all prepared tables
040602 5:54:02 /usr/sbin/mysqld: Shutdown
At 13:57 -0500 6/2/04, Oropeza Querejeta, Alejandro wrote:
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Yes. You can qualify table and column names with the database name
to specify which database you mean.
At 21:12 -0700 6/1/04, Greg Willits wrote:
I'm trying to force 4.1.2 to use the old short passwords for now
during some experimental stages.
The discussion here (specifically the fourth set of bullets):
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
and, this paragraph:
The
David Blomstrom wrote:
I just wondered if anyone on this list has worked with
counties in databases and is aware of a pre-existing
code system that's in fairly wide use. It would be
nice to make a database that's compatible with other
databases, if they share a common code for counties.
I don't
At 5:18 -0500 6/2/04, [EMAIL PROTECTED] wrote:
There's got ot be something else wrong. I've got the exact same problem and
I have done a chmod 666 on the directory I am trying to write to with no
luck. I am running v4.0.15
Mode is not enough, you must consider ownership.
Remember, *you* are not
Jigal van Hemert wrote:
I don#t understand why subquery on my MySQL 4.0.18-Mas
does not valid.
select * from salesreport where custid in
(select custid from appointment where done='N');
Simple reason: v. 4.0.18 does not support subqueries yet. Use 4.1 or later.
Regards, Jigal.
Or, rewrite the
--- P. Hill [EMAIL PROTECTED] wrote:
David Blomstrom wrote:
I just wondered if anyone on this list has worked
with
counties in databases and is aware of a
pre-existing
code system that's in fairly wide use. It would be
nice to make a database that's compatible with
other
At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about
Exporting/Importing Databases:
Third, my practice database includes half a dozen
tables, but only one made it online, followed by this
error message:
Database USERNAME running on localhost
Error
SQL-query :
CREATE TABLE `counties` (
--- Robert A. Rosenberg [EMAIL PROTECTED] wrote:
At 20:36 -0700 on 06/02/2004, David Blomstrom wrote
about
Exporting/Importing Databases:
Third, my practice database includes half a dozen
tables, but only one made it online, followed by
this
error message:
Database USERNAME running
At 20:13 -0700 on 06/02/2004, David Blomstrom wrote about Re: Where
do exported SQL files go?:
(I'm using Mozilla Firefox, which downloads
everything to the desktop, though I don't understand
why it considers this a download when it's a database
on my computer.)
Might it be doing this due to
This test code works, with both mysql-connector-j 3.0.14 and 3.0.11, against
mysql 5.0-alpha. I'll look more and report anything if interesting.
Thanks,
-James
From: Mark Matthews [EMAIL PROTECTED]
To: James Huang [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
--- Robert A. Rosenberg [EMAIL PROTECTED] wrote:
At 20:13 -0700 on 06/02/2004, David Blomstrom wrote
about Re: Where
do exported SQL files go?:
(I'm using Mozilla Firefox, which downloads
everything to the desktop, though I don't
understand
why it considers this a download when it's a
You can change the download options so that it will ask you where you want
to put the file rather than default to the desktop.
Tools/Options/Downloads/Ask me where to put every file.
Dave
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 03, 2004
1 - 100 of 102 matches
Mail list logo