Strange reply
When I send mail to [EMAIL PROTECTED], I get the following reply: From: [EMAIL PROTECTED] Subject: AutoReply Reminding Message: Java Java mysql.list [EMAIL PROTECTED] domain changed as @Cathaybk.com.tw Date: January 09, 2004 17:00:58 MST To: [EMAIL PROTECTED] Original Subject: Re: connecting without a password Thanks for send us email. We've delivered your email to @cathaybk.com.tw! Reminding!! Our Email domain is changed as @cathaybk.com.tw What does this mean. Best wishes, -Clay --- Clayburn W. Juniel, III Effective Software Solutions https://sourceforge.net/projects/database-viewer/ http://members.cox.net/clay1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sql problem
On Wednesday, Oct 23, 2002, at 00:13 America/Phoenix, Mylin Campos wrote: Hi all, I just wanted to know if you guys can help me out with this error. It's actually an sql and jdbc error. I have a class called employeeDBUtil. In this class, it has a method called updateEmployee. I wanted to try if the code would work so I created a main portion in my class. java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'eMName='Fabio', bDay = '03-14- You need to show the entire query to know why it didn't work. This error usually means the query was written correctly. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unknown error code : 1053
On Tuesday, Oct 15, 2002, at 08:30 America/Phoenix, LAFONTAINE Julien - LYO ([EMAIL PROTECTED]) wrote: Hi evryone, I've developed a java program that extract data from C-ISAM files and put it in a MySQL DB. It creates temporary files, load them into temporary tables and then update the db from those temp tables. This application is executed every night. Unfortunatly, once in a while there's some data missing (it's in the temp files but not in the DB) When I checked the log with mysqlbinlog, I found out that an error occur on one of my update query. The error code is 1053. Does anyone know what it means? This is what perror returns: Error code 1053: Error 1053 occurred. Any help would be greatly appreciated Cheers Try perror 1053 and see what it says -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to see whether a field is contained in a string (reverse of LIKE)
On Monday, Oct 14, 2002, at 13:29 America/Phoenix, Tim Kerch wrote: For example, I have a string Administration,Advertising,Direction,Media,Research and I want to see whether a SECTOR field in a row is contained in the above string. so that I can select rows which contain only Advertising in their SECTOR field.. sort of like a reverse LIKE, whether a field is contained in a string I supply to MySQL. Is there a way to do it without splitting the above string and checking for each sector specifically? For each field you could do SELECT field_name from your_table where SECTOR LIKE '%field_name%' . You don't care what the result is. Only that there is a result with at least one row of data. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA INFILE problem
On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote: Hello All: I am attempting to delete a table from a database, then recreate it and load data into the table. The drop and create commands are working properly, here's a screen dump: mysql DROP TABLE IF EXISTS testthis; Query OK, 0 rows affected (0.16 sec) mysql CREATE TABLE testthis(ID INT DEFAULT '0',Reviews CHAR (50),Date DATE,Bookmark CHAR (50), - Title CHAR (90),Web_Page CHAR (50)); Query OK, 0 rows affected (0.16 sec) mysql LOAD DATA INFILE /home/http/run/isak/wmj-new/uploaded/testthis.txt INTO TABLE testthis; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The same error message is generated if I give the filename only, logging in from the working directory of the file. 1)Any ideas of what I may be doing wrong here? 2)Also, can anyone tell me where I can find a list of MySQL error codes? Understanding more of what ERROR 1045 is about might be helpful In Unix systems the mysql user needs file privileges to file to be loaded. It's probably simplest to have the file located on a local disk (not network shared) with privileges for all to read. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql OSX 10.2
On Saturday, Oct 12, 2002, at 04:24 America/Phoenix, Pierre Vaudrey wrote: I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage package but I ran with the following error : [Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql dyld: mysql Undefined symbols: /sw/lib/libreadline.4.2.dylib undefined reference to _tgetent expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetflag expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetnum expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetstr expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tputs expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgoto expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap [Ordinateur-de-Pierre-Vaudrey:~] pierreva% Could you help me to fix it ? There is a separate package for 10.2 from Marc Liyanage. If that doesn't work, you can get a source distribution and compile it your self. When I did that I got a few errors during make and make install. I set the -i flag to ignore errors and it compiled and ran OK. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC Server Connection
On Thursday, Oct 10, 2002, at 01:48 America/Phoenix, James Kavanagh wrote: Hi all, Does anyone know if there's a way, using JDBC, to connect to a mySQL server without specifying a database? Basically I need to connect to n servers but don't always know which databases exist on them. I only want to extract server specific information i.e. process lists etc... I've written a program in Java to access MySQL databases. It is called Database Viewer and can be found at http://members.cox.net/essfiles/MySQL/ . With any method of connecting to an MySQL database if you just leave off the database name you should be able to connect. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Urgent Help! Importing Data from Text File...
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill wrote: Hi fellows, I got one text file of 9816 records (9816 lines) seprated by commas and enclosed by the inverted quotes and seprated by the end of lines. But when I import the file, it only gets half of records in the table using below mentioned command; LOAD DATA INFILE 'user.txt' INTO TABLE userdata FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' (category, fname, lname, adresse, zip, city, telephone, email, homepage); I get the below mentoned message; Query OK, 4908 rows affected (0.91 sec) Records: 4908 Deleted: 0 Skipped: 0 Warnings: 4913 Few records are as follow from the text file; 1,Peter,John,512 Rennes Road,19810,Wilmington,,mailto:[EMAIL PROTECTED],http:// www.mobili nk.com 1,Sandra,Bridget,12th Aveneue No. 301,12548,Broklyn,(212)780 101 10,mailto:[EMAIL PROTECTED],; Note: fields are empty(missing data) i.e.(in some records, one is missing faxnumber and in some records one is missing homepage and in some one is missing telephone as well. That's why I have to use the empty quotes for representing that field. The table structure is as follow; CREATE TABLE userdata ( accno int(10) unsigned NOT NULL auto_increment, category mediumint(6) unsigned zerofill NOT NULL default '0', fname varchar(128) NOT NULL default '', lname varchar(128) NOT NULL default '', add(128) NOT NULL default '', zip varchar(6) NOT NULL default '', city varchar(64) NOT NULL default '', telefone varchar(16) NOT NULL default '', homepage varchar(128) NOT NULL default '', email varchar(128) NOT NULL default '', telefax varchar(16) NOT NULL default '', PRIMARY KEY (accno), KEY category (category), KEY fname (fname), KEY telefone (telefone), KEY zip (zip), KEY city (city), KEY telefax (telefax) ) TYPE=MyISAM; Please advise me that whey I am not getting the whole records in the table from the text file. Your help will be highly appreciated... With Best Regards... Create a table with all the restrictions removed. No Key, or NOT NULL or ENUM or anything else. If All the data can be loaded into that table then you no there is some problems with the restrictions. When loading data from a file, I think it best to always load data into an unrestricted table then move it to the final one. It may take a little longer, but you can then check to see if any records were skipped. Of course you may want some skipped. Or you may find errors in your input file. -- Clayburn W. Juniel, III Phone: (602) 326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create table if not exists from mysqldump?
On Thursday, Oct 3, 2002, at 20:41 America/Phoenix, John Kelly wrote: Hi, I am trying to use mysqldump to dump the structure of a single database and want the output to make create table commands that include the IF NOT EXISTS switch so that when the file is imported into an existing database it does not write over tables with the same name. Does anyone know if this is possible with mysqldump and if so what option achieves this? Thanks. add the option -n or --no-create-db. This will add IF NOT CREATE to the sql. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Create table if not exists from mysqldump?
Begin forwarded message: From: Clayburn W. Juniel, III [EMAIL PROTECTED] Date: Fri Oct 4, 2002 10:24:06 America/Phoenix To: Clayburn W. Juniel, III [EMAIL PROTECTED] Subject: Re: Create table if not exists from mysqldump? On Friday, Oct 4, 2002, at 08:48 America/Phoenix, Clayburn W. Juniel, III wrote: On Thursday, Oct 3, 2002, at 20:41 America/Phoenix, John Kelly wrote: Hi, I am trying to use mysqldump to dump the structure of a single database and want the output to make create table commands that include the IF NOT EXISTS switch so that when the file is imported into an existing database it does not write over tables with the same name. Does anyone know if this is possible with mysqldump and if so what option achieves this? Thanks. add the option -n or --no-create-db. This will add IF NOT CREATE to the sql. Oops! That's not correct. That only works on creating the database not the table. But since this is only a text file, what you can do is use whatever program you have available and change every occurrence of CREATE TABLE to CREATE TABLE IF NOT EXISTS. If someone sees a reason why this won't work, please let me know. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FileMaker Pro Schema Export?
On Tuesday, October 1, 2002, at 10:25 24h, Jan Steinman wrote: From: Chuck Payne [EMAIL PROTECTED] Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. If you export a FileMaker database using 'Merge' you get a delimited text file with the first row being the column names. A program could be created to use this first row as column names to create a table. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
On Tuesday, October 1, 2002, at 10:51 24h, webmaster wrote: Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague Try the Mac OS version 10.2 from http://www.entropy.ch/software/macosx/mysql/ -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help!
On Tuesday, Oct 1, 2002, at 16:39 America/Phoenix, DeNewbie wrote: I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply giving me problems. All I want to do is enter the root and host paswords but I can't get past the root password setup. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' I input this; cords-orj86jfje:/usr/bin # mysqladmin -u root password sqlpass mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! How do I correct this situation. Why am I having such a hard time entering these passwords. I can't even enter the root password. I'm nearly giving up. It sounds like the server isn't running. You need to start it with cd /usr/local ./bin/safe_mysqld --user=mysql You may need to start the server as root. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [NEWBIE] Master Account
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote: I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. With the server running you first need to give root a password by typing: mysqladmin -u root password 'password' Including the single quotes. Then to log in as root: mysql -uroot -p -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting the password for root user in mysql
On Monday, September 30, 2002, at 03:03 24h, Palash Mohanlal Kasodhan wrote: Hi everyone, I am just starting to work with MySql on MAC OS X.When i installed mysql i got the following message : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root -p password 'new-password' /usr/local/bin/mysqladmin -u root -h localhost -p password 'new-password' try: /usr/local/bin/mysqladmin -u root password 'new-password' with the single quotes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating/droping database using mySQL JDBC driver
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote: Hello All, Could anyone help me with this issue? Is it possible to create/drop database using mySQL JDBC driver? Yes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Permission For Column Level Only
On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote: Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. You have to enter data into the tables_priv table, but NOT the db table. I believe all the fields in the tables_priv table need to be filled except Table_priv. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting Permission For Column Level Only
On Sunday, September 29, 2002, at 09:21 24h, Insanely Great wrote: Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. Grant Select (colum_name1), Select (Column_name2) on database_name.table_name to whoever@% identified by 'password' -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not Null
On Thursday, September 26, 2002, at 06:30 AM, Egor Egorov wrote: Clayburn, Thursday, September 26, 2002, 3:58:13 AM, you wrote: CWJI I create a table with a VarChar field set to not null. When I do an CWJI insert into this table with no value for this field it goes through CWJI without a problem. I realize MySQL inserts a empty string into the CWJI field. But what a want is an error when this happens. Is there any CWJI way to force this? Yes, you are right, if you try to insert NULL into NOT NULL column, '' or 0 will be inserted: http://www.mysql.com/doc/en/Bugs.html If you don't want to use default values, configure MySQL with -DDONT_USE_DEFAULT_FIELDS Thanks for the information. I read also that MySQL AB says you should check insertions and updates in your program and not MySQL. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need help with simple problem... I think
On Thursday, September 26, 2002, at 10:46 AM, Darrell A. Sullivan, II wrote: I am sure I am going to feel ignorant when I get the answer to this question because it will be something simple that I have overlooked, but here goes anyhow. I am using MySQL Version 3.23.51-max. I am developing an N-tier application using Java on the server side accessing MySQL through JDBC. On one of my tables whenever someone makes a change to the record, what I actually need to do is create a new record that is an exact copy of the existing record and apply the changes to it and set a deactivation date on the original record so that it can later be viewed and we can see when it was active and when it was deactivated. My problem is that I can't seem to put the SQL together to do this. You can't do an Insert...Into where the destination table also appears in the From clause. What I need is something like insert into t1 select * from t1 where t1.ID=x. I have looked into the Select statement to see if there was a way to do a Select t1.* into t2 temp from t1 where t1.id=x to create a temporary table and then do an insert into t1 select * from t2, but so far I can't see any way of doing this. It could be done in code by doing a select and rounding up all the names of the fields except for the primary key and then creating an insert statement using the field names and values, but if there is a simpler and less convoluted way of going about it I would prefer it. Try this: Create Temporary Table temp_table Select * From t1 Where ID = 'x'; Update temp_table Set ActivationDate = Now() where ID = 'x'; Insert into ti select * from temp_table where ID = 'x'; When I tried this a got a table already exist error on the first line, but the table was created correctly. I also got an error on the third line but again it was entered correctly. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rename database
On Friday, September 27, 2002, at 07:57 AM, Jorge Martinez wrote: Exists any way to rename a database ? Thanks Jorge sql You can create a new database and then: Rename Table old_database.table_name to new_database.table_name. You would have to do this for every table. You could then drop the old database. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql instla
On Friday, September 27, 2002, at 12:28 PM, root wrote: I tried to start it with safe-mysqld --u=mysql when I ran the mysqltest I get cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock' [A Any idea ... Try: safe_mysqld -u=mysql or safe_mysqld --user=mysql -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: one step up ...
On Friday, September 27, 2002, at 12:56 PM, hans schneidhofer wrote: hi list, have a simple newbie-question was looking for a possibility to go back one step after do a use sample_db but cannot find anything in the doc-files. what I mean is this : logging into mysql with using : mysql -u root -p then I get : mysql now I'm using use sample_db and can do some learnings, but how can I get back before use sample_db, so I can do a show databases; and see the mysql database ? You can do a show databases at any location. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not Null
I create a table with a VarChar field set to not null. When I do an insert into this table with no value for this field it goes through without a problem. I realize MySQL inserts a empty string into the field. But what a want is an error when this happens. Is there any way to force this? -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to execute mysql on OS X
On Thursday, September 19, 2002, at 10:22 PM, Jacques-Yves Mac wrote: Hi, MY_system:= macos 10.2 Darwin kernel version:= 6.0 Mysql server version:= 3.23.52 Mysql server is installed and work great except... I can't run the mysql executable localted in the bin directory The terminal returns me: dyld: bin/mysql Undefined symbols: bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap What's the problem, can somebody know something about that? I had the same problem still some one point me to the binary located at http://www.entropy.ch/software/macosx/mysql/. Download the correct one (pre OS 10.2 or after OS 10.2). And follow the instructions. It also seems you need to start the server as root. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connecting to remote MySQL server
On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: Hi, I am on the machine 192.168.0 230, and I am trying to connect to the server on 192.168.0.10. mysql -h 192.168.0.10 -u username -p I get back ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) OK, so I tried to connect to the local server mysql -h 192.168.0.230 -u username -p And I get back ERROR 1130: Host '192.168.0.232' is not allowed to connect to this MySQL mysql -h 192.168.0.230 -u username -p is correct. But when you created the grant for this user, you needed to list the host as 192.168.0.230 or I think % might have worked. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /usr/local/mysql/libexec/mysqld doesn't exist in installation
On Thursday, September 19, 2002, at 07:44 AM, Clayburn W. Juniel, III wrote: On Thursday, September 19, 2002, at 03:19 AM, [EMAIL PROTECTED] wrote: linux:/usr/local/mysql # ./bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. try sudo su linux:/user/local/mysql # .bin/mysqld_safe or just change to root first. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on OS X PROBLEM!
On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. also after a mysqladmin reload! i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there, it accepts them. then also the terminal will list them properly. why is this happening? please advise, phil I assume you started with: whoever% mysql -uroot -p Enter password: xxx mysql You need to add users like this: mysql grant create, delete, drop, insert, select, update on mysql Database_Name to someone@% identified by 'password'; and mysql grant create, delete, drop, insert, select, update on mysql Database_Name to someone@localhost identified by 'password'; -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602)274-6905 Fax: (602)274-6905 Email: [EMAIL PROTECTED]Mobile: (602)326-7707 http://EffectiveSoftwareSolutions.com -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on OS X PROBLEM!
On Thursday, September 12, 2002, at 09:58 PM, Clayburn W. Juniel, III wrote: On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. also after a mysqladmin reload! i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there, it accepts them. then also the terminal will list them properly. why is this happening? please advise, phil I assume you started with: whoever% mysql -uroot -p Enter password: xxx mysql You need to add users like this: mysql grant create, delete, drop, insert, select, update on mysql Database_Name to someone@% identified by 'password'; and mysql grant create, delete, drop, insert, select, update on mysql Database_Name to someone@localhost identified by 'password'; Database_Name should have been Database_Name.* Clay __ Warning! Opinions will change due to new information. -- Clayburn W. Juniel, III Phone: (602)274-6905 Fax: (602)274-6905 Mobile: (602)326-7707 -- - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php