Re: confirm unsubscribe to mysql@lists.mysql.com

UBJECT X-Spam-Check-By: lists.mysql.com > Received-SPF: neutral (lists.mysql.com: local policy) > Received: from smtpout0164.sc1.he.tucows.com (HELO n064.sc1.he.tucows.com) > (64.97.136.164) by lists.mysql.com (qpsmtpd/0.32) with ESMTP; Wed, 18 Jul > 2007 21:35:41 +0200 Received: from [

Question about using select...where f in (xxx)

ree' Is this possible ? I inherited the schema and the data, so I would prefer not having to refactor anything, unless I have to. Thanks in Advance, Neal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

problem with mysqldump, ustf8 with mysql 4.1

rchar(25) NOT NULL default '', PRIMARY KEY (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Any help would be appreciated, Neal Katz

importing after mysqldump --xml

Is there any (easy) way to import the data created by using mysqldump -xml ? I'd like to use the xml feature to export from machine A, massage the data, import into machine B XML works well for my application's needs in terms of massaging the data. Thanks, Neal Katz

using create table with show fields

I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz

Missing mysql.sock file

-- Best Rgds Graham Neal Cozy MK-IV S/N: 874 http://www.cozybuilders.org/ http://www.cozyaircraft.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

MySQL Netware vs Linux

x27;s going? Is it stable? How does stack up against Linux? Would you recommend switching from Linux to Netware? Any Responses would be great. Thanks in advance, Neal Dawson [EMAIL PROTECTED] - Before posting, please

Trigger

such tasks - I am looking for the functional analog on MySQL. Thanks. Neal Cabage - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

mySQL logs on Linux

Could someone tell me where the logs are written to by default, for a 3.23 install of MySQL on Linux? I looked in /usr/share/mysql/english and each directory leading up to it, but I didn't see anything resembling a log file. Thanks.

RE: multi-table select (not a join)

(?): "insert into tmp select userId from iteneraries" I was getting an error 'near insert into'. It seems you're trying to execute a subquery within a query ... can MySQL do this? Thanks. Neal -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Mond

RE: multi-table select (not a join)

queries and recieve back two seperate resultsets. Neal -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:21 AM To: neal; mySQL Subject: RE: multi-table select (not a join) At 0:23 -0700 9/23/02, neal wrote: >Oh man! > >Yeah, you

RE: multi-table select (not a join)

Oh man! Yeah, you're right. That's exactly what I want but apparently it wasn't implemented until v4??!?!?! What did people do prior to version 4 when needing to query multiple tables? Just endure the overhead of multiple connections to the database? Thanks. Neal -O

multi-table select (not a join)

b4 c4 bar Anyone know how to do a query like this? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

tinyInt(7) - not limited to 7 digits???

If Tomcat is installed and pointing to JDK1.3 but one wants to point instead to JDK1.4, is there an easy way to do this? If so, I'm not finding it. Seems like one would need to completely uninstall and reinstall tomcat??? Thanks. Neal [sql,

date field - default value = current date

Is there a wat to have mySQL auto fill in the current date into my dateCreated field? In SQLServer I would simply specify the getDate() method as a default value. I presume I would use the analogous MySQL function curDate() but it does not appear to work for me. Any suggestions? -

determine value of auto-increment field after adding record - @ runtime

ecall there was a function something like @@ID to retrieve this value ... could be written directly into your SQL. What sort of function exists in mySQL for this purpose? Thanks. NEal - Before posting, please check:

Gui admin clients - security concern?

as on an SSL or something? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

primary/foreign key contraints

Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? I can't imagine that this is right. Perhaps I'm just overlooking something Thanks. Neal - Before posting, pl

Remote admin app?

What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? Other? What's most popular and why? Thanks! Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: JDBC - Access denied REVISED = simply won't accept passwords when logging in

newbie. Is there some place in mySQL that I must specify that it will use the passwords specified, when authenticating users? Thanks. Neal -Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:28 PM To: mySQL Subject: JDBC - Access denied (using

RE: JDBC - Access denied (using password: yes)

27;ve ever put on this machine, and I'm using 3.0 Beta. :) Thanks. Neal -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:03 PM To: neal Cc: suresh; mySQL Subject: Re: JDBC - Access denied (using password: yes) neal wrote: > Tha

users Permission Oddity

o the previous issue wherein I was able to connect using an account bob@% where a password was specified int he account, even though I provided no password while logging in? I should note that I am using MySQL 4.0.1 ... perhaps this explains these issues Thanks.

RE: JDBC - Access denied (using password: yes) - RESOLVED

'localhost' its fine. I don't really understand why but it fixed it... Neal -----Original Message- From: neal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 7:28 PM To: mySQL Subject: JDBC - Access denied (using password: yes) Does anyone know why I would rec

RE: JDBC - Access denied (using password: yes)

this DOES work: Connection myConn = DriverManager.getConnection("jdbc:mysql:///test?user=bob&password="); That's the wierd part. I'll try explicitly naming localhost but I think that is implied(?). Cheers. Neal -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sen

JDBC - Access denied (using password: yes)

. javax.servlet.ServletException: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manua

Connector/J - which version

so be other important new features to consider. Does anyone have any recommendations? FYI - I'm woriking with Tomcat 4.0.3 and will be doing conn pooling via JNDI on tomcat. Thanks. Neal - Before posting, please chec

RE:

statement. These factors plus any positive/negative experience would be valuable in making a decision as to which version of the driver to use. Any thoughts? Thanks. Neal - Before posting, please check: http://www.mysql.com

RE: Saving and re-using SQL statements

Hi Gurhan, Actually, the "source" command is what I was looking for. Thanks. I looked through the documentation but for some reason could not find it. - Neal Gurhan Ozen <[EMAIL PROTECTED]> on 04/16/2002 03:43:42 PM To: Neal Caidin <[EMAIL PROTECTED]>,

Saving and re-using SQL statements

figure out how to restore the query. I use vi's e filename to get the file, but then when I :wq out of vi it restores the previous SQL statement I had input before grabbing the file with the e option. Thanks, Neal ---