Re: dynamic value like excel
this may help you test create table d ( - date date ); Query OK, 0 rows affected (0.45 sec) test insert into d values(now()); Query OK, 1 row affected (0.12 sec) test select * from d; ++ | date | ++ | 2005-09-10 | ++ 1 row in set (0.00 sec) On Sep 10, 2005, at 8:52 AM, liofr wrote: i want to put a value in a column that is the date of today . IS there a solution to do that in sql way ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO issue
On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote: This is the part that gets me: As part of the agreement, the companies will work together on a range of joint marketing, sales, training, business development and support programs that will benefit customers throughout the Americas, Europe and Asia. I suppose it depends on how much 'joint work' is actually involved. As another poster pointed out, this could just be SCO up to their usual spin. But I agree with you - if this is some kind of special business relationship, then Postgres is looking all the more inviting. MySQL AB doing work for SCO is one thing, partnership would be much a different matter which would then lead me to agree that looking at Pg would be a good idea. Hopefully MySQL AB will make all this clear one way or the other ... Rich Allen Dare Do
Re: InnoDB Record Lock Command
something along the lines of: mysql select * from table where column = value lock in share mode On Sep 5, 2005, at 4:01 PM, Rich wrote: Hi there. I am looking for the syntax to lock individual records in an InnoDB table. I can't seem to find anything outside of locking full tables. Rich Allen A kidney transplant saved my life, plese consider being an organ donor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
views in 5.0.11
iH i have a view created in 5.0.11 on several innodb tables. when doing a select * on the view after first getting into the mysql command line, the last column has incorrect values. without running any other command and performing the same select statement, all columns are correct. is this a known issue? running mysql on mac os x 10.4 thanks Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: all user command
mysqladmin processlist On Jul 26, 2005, at 5:21 PM, Joeffrey Betita wrote: hello what command should i type to see all the user connected to the database. thank you very much. Rich Allen Dare Do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQLDump - Command line password
have you looked at using a my.cnf file? eMac:~ hcir$ mysqldump test /temp/test.sql eMac:~ hcir$ ls -l /temp/test.sql -rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql contents of ~/.my.cnf [client] user= username password= password # actual username and password of course are not 'username' and 'password' On Jul 19, 2005, at 3:40 PM, Cabbar Duzayak wrote: Hi, I have setup cronjobs to take daily backups of my db using mysqldump. But the problem is, mysqldump requires the password to be passed via command line, which means anyone on the same machine can take a peek at my password using top, ps -ef, etc. Is there a way of avoiding this, i.e. making it read the password from some file, etc? Or, is there any other alternative I can use?
Re: How do you become a MySQL DBA
iH Mark, i work for a small independent telco where i have developed a number of apps that interface with class 5 switches and other telco gear. if you would like to email me off list i would be happy to give more details On May 31, 2005, at 2:50 PM, Mark Ahlstrom wrote: Here's an odd question for you, how do you become a MySQL DBA? I've got enough Solaris/Linux Experience under my belt and I was a Jr. Oracle DBA for a year, which got me really interested in RDBMS. I try to work with MySQL as much as possible, but I work with one of those large telco's that does not like anything where they can't pay large amounts of money. This means I have to work it into my spare time. I've been trying to tie MySQL into basic services: ftp, DSPAM, pop3, AND offer help for what we do have: running backups and repairing the odd table when needed. But the question is, what else could I do to help develope DBA skills? Right now I have very little data that goes beyond 2 tables, so my query skills are withering. Rich Allen A kidney transplant saved my life, plese consider being an organ donor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tiger - MySQL --- any news ???
i am running 4.1.9 binary on tiger without any trouble Your MySQL connection id is 1 to server version: 4.1.9-standard - hcir On May 23, 2005, at 1:03 PM, Kevin Victor wrote: I would like to know if there is any existing solution for running MySQL on Tiger. I dont see a binary version for 10.4 yet, will it be released any time soon?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
access two like tables with one query
iH i have a database that i only have READ access to (i am not the creator). there are tables with stats data that are created each day; ie data3_1_2005 and 'data3_2_2005. each table has the same layout. create table data3_1_2005 ( port char(8), tmval int, val int ) how can i create a single query to get all the rows related to port from both files without creating a merge table? thanks - hcir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Large 30 GB Database
i have one MySQL dB that is currently about 26Gb, properly indexed searches are very quick - hcir On Jul 28, 2004, at 4:23 AM, matt ryan wrote: Should I even attempt this using mysql? Has anyone played with this much data in mysql? I've got two 100 gig databases in mysql, and slave replication on both of them, the only time I have a problem is table scans, that much data will be slow. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and Macs
iH any machine running OS X can run MySQL, this link http://dev.mysql.com/downloads/mysql/4.0.html has a Mac OS X version with a package installer - hcir On Jun 29, 2004, at 5:14 PM, Jim Carwardine wrote: Im new to the list and new to mySQL. Im a Mac user and would like to set up a DB on my Mac. When I look at the MySQL web site, I cant seem to find any info on what hardware can be used. Can mySQL be run on a Mac? If so, what do I need to know about how to set it up? Can anyone point me to a setup procedure? Jim -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load data infile
sounds like --safe-mode has been turned on, check your my.cnf files - hcir On Jun 10, 2004, at 7:18 PM, Nik Belajcic wrote: I have a strange problem importing data from a text file. There are 1353 rows in the text file (generated by a Perl script) but only 1000 get imported into MySQL. I am clueless why would this be happening - it seems as if there was a cutoff point at 1000 rows which, of course, doesn't make any sense. Any thoughts much appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query question
Garth, good catch! - hcir mysql - hcir On May 24, 2004, at 1:05 PM, Garth Webb wrote: On Mon, 2004-05-24 at 11:32, John Nichel wrote: Rich Allen wrote: iH this should work test select * from xt; ++---+ | id | field | ++---+ | 1 | 0 | | 2 | 0 | | 3 | 7 | | 4 | 8 | | 5 | 7 | | 6 | 0 | | 7 | 6 | | 8 | 7 | | 9 | 8 | ++---+ 9 rows in set (0.00 sec) test select count(distinct(field)) + (select count(*) from xt where field=0) - 1 from xt; + --+ | count(distinct(field)) + (select count(*) from xt where field=0) - 1 | + --+ | 6 | + --+ 1 row in set (0.01 sec) note that i subtract one since i counted a 0 value in the distinct part ... - hcir That's what I needed. Thanks! Note that this solution will be off by one if there aren't any zeros in your data. Try this: select count(IF(field0,NULL,1)) + count(distinct IF(field0,field,NULL)) from test; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query question
iH this should work test select * from xt; ++---+ | id | field | ++---+ | 1 | 0 | | 2 | 0 | | 3 | 7 | | 4 | 8 | | 5 | 7 | | 6 | 0 | | 7 | 6 | | 8 | 7 | | 9 | 8 | ++---+ 9 rows in set (0.00 sec) test select count(distinct(field)) + (select count(*) from xt where field=0) - 1 from xt; +--+ | count(distinct(field)) + (select count(*) from xt where field=0) - 1 | +--+ |6 | +--+ 1 row in set (0.01 sec) note that i subtract one since i counted a 0 value in the distinct part ... - hcir mysql - hcir On May 24, 2004, at 9:36 AM, John Nichel wrote: Hi, I have a table which I want to select data from (obiviously). In this table, I have a field which is an integer, and defaults to 0. What I would like to do is count all rows in that table which not only equals 0 for the field, but has a distinct value which is greater than 0. id field 1 0 2 0 3 7 4 8 5 7 6 0 7 6 8 7 9 8 For the above example, my count should return 6. Three zero's count as 3, three seven's count as 1, two eight's count as 1, and one six counts as 1. I've tried... SELECT COUNT(*) FROM db.table WHERE ( field = 0 || ( field 0 DISTINCT field ) ) But it still returns the count of all the rows. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem running MySQL on MacOS X.3
ps should show you something like the following: Jupiter:~/desktop hcir$ ps uax | grep mysql root 291 0.0 0.118644 1072 ?? S 3May04 0:00.06 sh ./bin/safe_mysqld --user=mysql mysql 338 0.0 2.551720 19872 ?? S 3May04 10:17.86 /usr/local/mysql-standard-4.1.0-alpha-apple-darwin6.4-powerpc/bin/ mysqld hcir20399 0.0 0.018172344 std S+ 10:52AM 0:00.01 grep mysql if you dont see this i would check the error log after you try to start the server with something like: #/usr/local/mysql/bin/mysqld_safe -uuser - hcir On May 11, 2004, at 10:29 AM, Gabriel Ricard wrote: Did you configure MySQL and run the /usr/local/mysql/scripts/mysql_install_db to initialize your data directory? - Gabriel On May 10, 2004, at 5:21 PM, Tim Jarman wrote: I have an iBook G4 running MacOS X.3 on Darwin 7.0. I downloaded and ran the binary installer (mysql-standard-4.0.18.pkg and it appeared to work fine; I have /usr/local/mysql and so on as per the docs. I also installed MySQLStartupItem. However, I don't actually appear to have a functional installation. If I do: /usr/local/mysql/bin/mysql or even sudo /usr/local/mysql/bin/mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) although /tmp/mysql.sock does exist, which seems to indicate the server is running. But then again ps -a -x doesn't seem to show it, so maybe it isn't; if I do ps -A |fgrep mysql on my Linux box, where MySQL is running happily, I get a hit for mysqld_safe plus ten others for mysqld. I tried starting the server manually as suggested in the docs: sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server but when I try running mysql I get error 2002 as before. I found mention of this problem on FAQTS and in the MySQL mailing lists archive, the latter of which suggested this email address. Any clues would be most welcome! Please cc any replies to me as I am not currently subscribed to any of the MySQL lists. Thanks in advance, Tim Jarman - hcir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
iH is mysql installed and running? - hcir On Apr 8, 2004, at 9:53 AM, Kirti S. Bajwa wrote: cpan install DBD::mysql Errors returned: Can't exec mysql_config: No such file or directory at Makefile.PL line 174 readline() on closed filehandle PIPE at Makefile.PL line 176 ... (there are 10 such errors) Then few other lines of output without error. Then I get the following (error) response: Checking if your kit is complete... looks good Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (number of such errors) Note (probabally harmless): No library found for -lmysqlclient Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. ... (again quite a number of such errors) Note (probabally harmless): No library found for -lgz Writing Makefile for DBD::mysql Makefile:89: *** missing separator. Stop. /usr/bin/make --NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible cpan What are these errors? How should I fix them? Can I continue installing other software (Apache, qmail, etc.) Thanks. Kirti -Original Message- From: Rich Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 6:02 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]' Subject: Re: Perl Modelues you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Perl Modelues
you can install Perl modules with $ perl -MCPAN -e shell cpan install [module::name] - hcir mysql - hcir On Apr 7, 2004, at 10:57 AM, Kirti S. Bajwa wrote: Hello List: I have run into stone wall in figuring out installation of Perl DBI modules with MySQL. When I review the MySQL documentation, 2.7.1 Installing Perl on Unix, it mentions that the easiest way to install Perl DBI is to use CPAN. However when I go to the link provided in the documentation http://search.cpan.org, I can't figure out how to find the Perl module. Can someone show me the light. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hostname
127.0.0.1 is always localhost, perhaps you could make this change in your scripts - hcir use MySQL is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when the script asks: SHOW GRANTS FOR 'user'@'127.0.0.1' Mysql replies that there is no such grants, because it knows 'user'@'localhost' instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL access issue
this link from the mysql docs should help http://www.mysql.com/doc/en/Resetting_permissions.html - hcir Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for the db's and frankly I'm not an MySQL buff to be honest. Our DB Admin is gone now, I need access to mysql db's, but I don't know what the username/password was for them. What are my options here to be able to not lose this info and get root access into the db's in mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up MySQL on Mac OS X
iH you may find this site helpful in getting MySQL running for the first time http://www.entropy.ch/software/macosx/mysql/ also recommend that you spend some time learning how to be root, unix permissions, etc - hcir On Thursday, Aug 21, 2003, at 22:53 America/Anchorage, Bob Goldberg wrote: I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Checking the mysql status
this is a Perl script, not shell ... #!/usr/bin/perl use strict; use DBI; # change the next four to match your network my $SLAVE_IP= '0.0.0.0'; my $MASTER_IP = '0.0.0.0'; my $USER= 'user'; my $PASSWORD= 'password'; my ( $dbh, $sth, @masterResult, @slaveResult, $i ); $dbh = DBI-connect(dbi:mysql:database=test;host=$MASTER_IP, $USER, $PASSWORD); $sth = $dbh-prepare(show master status); $sth-execute(); @masterResult = $sth-fetchrow_array; $sth-finish; $dbh-disconnect; $dbh = DBI-connect(dbi:mysql:database=test;host=$SLAVE_IP, $USER, $PASSWORD); $sth = $dbh-prepare(show slave status); $sth-execute(); @slaveResult = $sth-fetchrow_array; $sth-finish; $dbh-disconnect; ($masterResult[1] == $slaveResult[16]) ? print 'OK' : print 'Error'; # hcir Hello, mysql, I want to write a shell script to check the slave synchronize with master failed or sucessfully. Any idea to implement this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
link from Access to MySQL
iH i found in the ODBC faq how to link from mysql to access, can this be done in reverse? link from access to mysql? thanks - hcir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Paul, do you address this in any of your books?
this article on cross tabulations should help you ... http://www.mysql.com/articles/wizard/index.html - hcir (mysql sql query) On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS wrote: I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? - 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
ampersand in match against
iH how do i properly escape the ampersand character in a mysql select match against statement mysql select * from logbook where match(username,body) against ('AT\T'); does not find a match although it should thanks - hcir - 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
SuSE DBD::mysql
iH trying to get v7.3 of SuSE/PPC working with mysql and perl. i have the mysql server working and perl reports that the mysql driver is available but when trying to connect to the a database i get error while loading shared libraries: /usr/lib/perl5/site_perl/5.6.1/ppc-linux/auto/DBD/mysql/mysql.so: undefined symbol; mysql_init the script simply tries to connect and disconnect and does work under Mac OS X any idea what i am doing wrong here? thanks - hcir - 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
install on SuSE/PPC
iH trying to install mySQL 4.0.10 onto SuSE/PPC and getting an error when running ./configure cant create executable any ideas? thanks - hcir - 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
mySQLGUI/MacOSX
trying to get mySQLGUI to install on Mac OS X, fltk seemed to install ok but am getting the follwoing for flvw [ARTiBook:~/src/flvw/1.0] root# make === making src === Compiling Flv_List.cxx... In file included from ../FL/Flv_List.H:45, from Flv_List.cxx:38: ../FL/Flv_Style.H:111: warning: friend declaration requires class-key, i.e. `friend class Flv_Style_List' Flv_List.cxx: In member function `virtual void Flv_List::draw_row(int, int, int, int, int, int)': Flv_List.cxx:178: `inactive' undeclared (first use this function) Flv_List.cxx:178: (Each undeclared identifier is reported only once for each function it appears in.) make[1]: *** [Flv_List.o] Error 1 === making test === make[1]: *** No rule to make target `../lib/libflvw.a', needed by `testlist'. top. make: *** [all] Error 2 hints/suggestions? thanks - hcir - 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: restart or not?
have you looked at the mysql command flush privileges - hcir On Tuesday, January 28, 2003, at 02:05 PM, Jon Miller wrote: When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; - 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: Help - Convert Date from longtext to MySQL date format
this command should get your data moved to a new sql table insert into table2 select (concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2))) from table1; - hcir On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote: Hi I have a few tables in a database Z, namely table a b c In table a, the columns are my_date - longtext num - int(11) eg: mysql select * from a; +--+--+--+ | my_date | x| +--+--+ | 08/06/2002 |1 | | 08/07/2002 |2 | +--+--+--+ 2 rows in set (0.00 sec) Tables b and c have the same table structure and data type format. Q: How do I convert 08/06/2002 to 2002-08-06 format without having to reinput all my data from scratch ? - 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: remote database
mysql -h10.0.0.5 -u[username] -Dvisitor -p[password] should get you in - hcir On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote: I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. It doesn't work when I give it -h but it works without. # mysql -h 10.0.0.5 -D visitor ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) but # mysql -D visitor works. - 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: Article: Using the Ruby DBI Module
Paul/others, /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:477:in `load_driver': Could not load driver (uninitialized constant Mysql at DBI::DBD) (DBI::InterfaceError) from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:384:in `_get_full_driver' from /usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:364:in `connect' from /Users/hcir/Desktop/simple.rb:8 am getting this when using the simple.rb example with Mac OS X 10.2.3? i have Perl working with mysql and DBI ... followed the install from the link below thanks - hcir http://www.kitebird.com/articles/ - 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: What's returned from $sth-execute(); ?
this should answer your question, from the DBI documentation http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm#execute sql,query,queries,smallint - hcir On Friday, January 10, 2003, at 02:55 PM, [EMAIL PROTECTED] wrote: I've been using the return value of $sth-execute(); (in Perl DBI) to determine if I have a result set. I'm not using the value I get back but am assuming that if it's =1 then I have some results. - 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 MySQL databases and tables via Perl/DBI
the example will connect to the local mySQL server and create a new database named 'dbname #!/usr/bin/perl -w use DBI; $dbh = DBI-connect( dbi:mysql:, 'user', 'password', { PrintError = 0 } ) or die Can\t connect to database: $DBI::errstr\n; $dbh-do(create database dbname); $dbh-disconnect or warn Disconnection failed: $DBI::errstr\n; On Wednesday, January 8, 2003, at 12:04 PM, Ken Hilliard wrote: I'd like to be able to create a new database using Perl/DBI instead of using the MySQL command line (and other) utilities. It looks like you can create a new database with the driver handle but I can't seem to make it work. - 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: changing database location
shutdown mysql, move all the files in your current data directory to the new location in your my.cnf file (ie. unix: /etc/my.cnf) [mysqld] datadir=/my --- all data files are in /my - hcir On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote: Hi All Right now I have all my MySQL database files getting stored in /var/lib/mysql/ If I want to change that to another location, say, /home/mysql or something else, how do I do it? - 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 local infile
sound like you may want to add the following to your my.cnf file for MySQL [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote: Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version How come? What method can I use to input bulk data? - 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 local infile
try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi Guo wrote: Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many different tries. Does anyone make it work with this version? It worked for when I used v3.23.52. - 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 command
i believe that this security issue came up with the .51 version of mysql you can remove this block by adding this to your my.cnf file [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Friday, December 6, 2002, at 10:16 AM, Padma kuruganti wrote: Hi I just downloaded version 3.23.53 for evaluation. when I try to use LOAD DATA LOCAL INFILE 'some.txt into TABLE sometable I get a message saying 'the used command is not allowed in this version of mySQL. IS - 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
joing 2 columns to 1 table
if i have the following mySQL tables create table list ( id int, name char(20) ); insert into list values(1, 'bob'); insert into list values(2, 'joe'); create table list2 ( id1 int, id2 int ); insert into list2 values(1,2); insert into list2 values(2,1); what query will return the following result result: - bob, joe joe, bob thanks - hcir - 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
[mysqld 4.0.x DBD::mysql 2.1020]
Description: using LOAD DATA INFILE from Perl crashes table How-To-Repeat: issue LOAD DATA INFILE from Perl w/ DBD::mysql 2.1020 installed Fix: i downgrade to 2.0491 Submitter-Id: submitter ID Originator: Rich Allen Organization: none MySQL support: none Synopsis: LOAD DATA w/ DBD::mysql Severity: critical Priority: high Category: mysql Class: Release: mysql-4.0.4-beta (Source distribution) Server: ./bin/mysqladmin Ver 8.37 Distrib 4.0.4-beta, for apple-darwin6.1 on powerpc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.4-beta Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 25 min 25 sec Threads: 1 Questions: 1819 Slow queries: 0 Opens: 766 Flush tables: 5 Open tables: 47 Queries per second avg: 0.355 Environment: System: Darwin ARTiBook.local. 6.1 Darwin Kernel Version 6.1: Fri Sep 6 23:24:34 PDT 2002; root:xnu/xnu-344.2.obj~2/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs Thread model: posix Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 20020420 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Sep 18 18:08 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --mandir=/usr/local/share/man/ --with-innodb --enable-local-infile - 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: merge tables - errorno: 143 - Is there a limit on columns with merged tables ?
from perror 143 = Conflicting table definition between MERGE and mapped table On Sunday, Sep 22, 2002, at 18:36 America/Anchorage, David Herring wrote: Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143) Reducing the number of colums in the tables to be merged removed the problem. - 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