Re: Running mysql (complete newbie)
Hi guys/gals, the problem is directory perms but not in the tmp. And yes you should have my.cnf in your /etc (can change this location but cant remember where), and there are sample cnf files in the support-files directory of mysql. As far as the directory issue goes simply run: chown -R mysql data chgrp -R mysql data in the mysql directory. Obviously you need to have a mysql user, and this lets that user, and only that user write to the data directory, or even enter it for that matter (besides root of course). HTH! -Nick On Wed, 2003-07-30 at 01:19, Peter Bradley wrote: Hi Sanya Don't appear to have a file called my.cnf anywhere on my system. Should I have? If so how should it be formatted, and what should be in it? Peter On Wed, 2003-07-30 at 18:42, Sanya Shaik wrote: You need to set the sock in usr/local/mysql/data/my.cnf to /tmp/mysql.sock Peter Bradley [EMAIL PROTECTED] wrote: Hi guys and gals, I'm a complete newbie to mysql, so please bear with me. Today I downloaded mysql4.0 binary distribution and installed it on my SuSE Linux 8.1 box. I've unzipped it and put it in: /usr/local/mysql-standard-4.0.14-pc-linux-i686 and I've created a symbolic link to give me /usr/local/mysql I then ran scripts/mysql_install_db (as root). The output was: = | |linux:/usr/local/mysql # ./scripts/mysql_install_db |Installing all prepared tables |030730 4:24:13 ./bin/mysqld: Shutdown Complete | | |To start mysqld at boot time you have to copy |support-files/mysql.server |to the right place for your system | |PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! |This is done with: |./bin/mysqladmin -u root password 'new-password' |./bin/mysqladmin -u root -h linux password 'new-password' |See the manual for more instructions. | |NOTE: If you are upgrading from a MySQL = 3.22.10 you should run |the ./bin/mysql_fix_privilege_tables. Otherwise you will not be |able to use the new GRANT command! | |You can start the MySQL daemon with: |cd . ; ./bin/mysqld_safe | |You can test the MySQL daemon with the benchmarks in the 'sql-bench' |directory: |cd sql-bench ; perl run-all-tests | |Please report any problems with the ./bin/mysqlbug script! | |The latest information about MySQL is available on the web at |http://www.mysql.com |Support MySQL by buying support/licenses at https://order.mysql.com | |linux:/usr/local/mysql # | === I then tried to start mysql as a normal user and got: | |[EMAIL PROTECTED]:/usr/local/mysql bin/safe_mysqld --log |[1] 2693 |[EMAIL PROTECTED]:/usr/local/mysql Starting mysqld daemon with databases |from /usr/local/mysql/data |bin/safe_mysqld: line 296: /usr/local/mysql/data/linux.err: Permission |denied |rm: cannot remove `/tmp/mysql.sock': Operation not permitted |bin/safe_mysqld: line 1: /usr/local/mysql/data/linux.err: Permission |denied |tee: /usr/local/mysql/data/linux.err: Permission denied |030730 04:27:40 mysqld ended |tee: /usr/local/mysql/data/linux.err: Permission denied | |== So I tried as root and got: | |linux:/usr/local/mysql # ./bin/safe_mysqld --log |[1] 2740 |linux:/usr/local/mysql # Starting mysqld daemon with databases from |/usr/local/mysql/data |030730 04:30:05 mysqld ended | I did check to see if mysqld was running, but of course it wasn't. I also tried the perl script run-all-tests, but it just reported mysql wasn't running ('Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' when connecting to DBI:mysql:database=test;host=test;host=localhost with user: '' password: '') Can anyone help? Thanks Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replacing text on query..
Hello all. I was wandering if it was possible to do a general replacement of text on a query. What I want to do is for any fields that equal 'false' to be replaced with 0 and any fields that equal 'true' be replaced with 1. Now I know you can do if statements, but I have a whole bunch of fields and don't really want to go down the route on all of the fields. But if I have to I will. Thanks for the advice! -Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Replacing text on query..
Thanks for pointing that one out. Unfortunately relplace(table.*, ...) does not work (syntax error) so I'll stil have to go through each field individually. This will be two statements per-field which kinda stinks, but oh well. Thanks again! -Nick On Mon, 2003-06-23 at 11:10, Mike Hillyer wrote: Take a look at the REPLACE() function: http://www.mysql.com/doc/en/String_functions.html#IDX1202 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Nick Stuart [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 8:58 AM To: MySQL List Subject: Replacing text on query.. Hello all. I was wandering if it was possible to do a general replacement of text on a query. What I want to do is for any fields that equal 'false' to be replaced with 0 and any fields that equal 'true' be replaced with 1. Now I know you can do if statements, but I have a whole bunch of fields and don't really want to go down the route on all of the fields. But if I have to I will. Thanks for the advice! -Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Forgot to include stack....
har har, silly filter On Fri, 2003-01-10 at 14:43, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I forgot to include the stack dump in my bug report. Here it is: 0x806f3bb handle_segfault + 447 0x8269928 pthread_sighandler + 184 0x807724c check_connections__FP3THD + 200 0x8077665 handle_one_connection + 337 0x82670dc pthread_start_thread + 220 0x829c67a thread_start + 4 - 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: Case Problems...
Ah, I see. Was unaware of this new feature, and thanks for the explanation. -Nick On Thu, 2003-01-09 at 17:20, Stefan Hinz, iConnect (Berlin) wrote: Nick, CREATE DATABASE LookAtMe; the database is created but as: lookatme This is not a bug, but a feature. By default, MySQL 4.0.x has lower_case_table_names set to 1. If you want to change this behaviour, put this in the [mysqld] section of your c:\my.cnf or c:\winnt\my.ini file, and restart the MySQL server: set-variable = lower_case_table_names=0 Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 7:52 PM Subject: Case Problems... I seem to have found a bug with 4.0.7. I just want to make sure the issue hasn't been covered before I submit a report. I have 4.0.7 installed on windows 2000 server with all the service packs and stuff. When I connect to the database through a Linux client (haven't tried it on the box itself) and issue: CREATE DATABASE LookAtMe; the database is created but as: lookatme with no caps. Anybody run into this before? I know Winblow$ isn't case sensitive and all but it should still create the database/folder as I type it. -- -Nick Stuart USM Computer Science Major Visit us at http://csforum.newtsplace.com (run with LAMP) Filter Fodder: mysql, sql, queries, why isn't CREATE or DATABASE in the god damn list! =D - 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 - 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
Case Problems...
I seem to have found a bug with 4.0.7. I just want to make sure the issue hasn't been covered before I submit a report. I have 4.0.7 installed on windows 2000 server with all the service packs and stuff. When I connect to the database through a Linux client (haven't tried it on the box itself) and issue: CREATE DATABASE LookAtMe; the database is created but as: lookatme with no caps. Anybody run into this before? I know Winblow$ isn't case sensitive and all but it should still create the database/folder as I type it. -- -Nick Stuart USM Computer Science Major Visit us at http://csforum.newtsplace.com (run with LAMP) Filter Fodder: mysql, sql, queries, why isn't CREATE or DATABASE in the god damn list! =D - 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
Alter table error
Got another problem with 4.0.7 when trying to alter the table. Trying to run: ALTER TABLE `call_information` CHANGE `close_date` `close_date` TIMESTAMP DEFAULT '' NOT NULL and it returns a: ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to '.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) Any ideas on why I would get this?? I think it has something to do with my case problem that I posted before because if you look it says helpdesk instead of HelpDesk. -- -Nick Stuart USM Computer Science Major Visit us at http://csforum.newtsplace.com (run with LAMP) - 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: Alter table error
Thats what I thought, but wasnt the case. The directory was open to full control by everyone. I did fix the problem though. It turns out this is an issue with windows not letting anyone edit a file that is in use. And when a table is used mysql will cache and hence windows thinks it's in use and will lock it. I just had to do a mysqladmin -u root refresh and I was able to edit the table. God how I've missed windows! blah! Thanks for the pointer though. I ended up finding this solution somewhere through google, can't remember where atm though. -Nick On Wed, 2003-01-08 at 19:19, Jennifer Goodie wrote: ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to '.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) Any ideas on why I would get this?? Errorcode 13 is permission denied or file not found. Either .\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have permission to overwrite it, or the user does not have write permissions on the data dir and everything in it. Using perror will help you decode the errorcodes. SQL,QUERY - 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
mysql 4.0.2 problems
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - 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 with query
I think the best way to do this is to set up two tables. One for the main topic list, then one for each sub topic. You may already have this but I cant see it here. Anyways to get your selection order correct you could do something like:SELECT * FROM forum ORDER BY parent_id, id Have any exampls of what you tried? And what exactly didnt work or turn out right?-Nick I am trying to get something like the following: Title - topic #1 sub topic #1.1 topic #2 sub topic #2.1 sub topic #2.2 from the following table (I am using php for scripting). forum idint parent_id int (refers to the forum.id field) title ... How can I get the above output in the correct order since the posts into the table can come in any order? I have tried various order by's and group by's. I am so lost on this. Thanks in Advance, Scott Hathaway query, sql - 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 - 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
run-all-tests time
Just a quick question on how long this bench mark usually runs for. Started it a while ago and its still kicking away. Know its working because the Questions number keeps on going up.Thanks for the info. -Nick p.s. System is w2k 2gig Intel 4 with 512 ram filter fodder: sql, query - 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: Any way to make a 'top ten' query?
Couldnt you do. SELECT * FROM tbl ORDER DESC LIMIT 10 As there is no TOP operator nor nested selects in MySQL, I wonder if there still exists some clever way to maketop ten type of a query , i.e. to select ten best selling products or ten highest mountains for example. thanks - 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 - 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: SQL Help Needed
Ok this should be easy so I'm prolly going to screw it up, but here goes =D Your query should be: SELECT UserID, SUM(points) FROM History WHERE WeekID = 'whatever' GROUP BY UserIdI think that should do it. Someone yell if its wrong though. -Nick I have 2 tables Users (UserID) History (UserID, WeekID, Points) When a User record is created a record is inserted into History with the current WeekID, so for example data could be : Users History -- - 1 - 10 - 1 - 20 - 1 - 30 - 2 - 40 I want to run a query to return one row for each User row and their points for any given week. In other words somebody asks for all points in Week 1 the result should be : - 10 - 20 - 30 - 0 Or, all points for WeekID 2 would give : - 0 - 0 - 0 - 40 I have tried lots of things but I think my brain is just not giving me the correct solution. Please help! - 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 - 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: MyISAM internal algorithms
Ok, so know you got me interested. What exactly are R-Trees. I know the structure of B trees, hadto program a small version of a B' tree before, but never heard of an R-Tree. Any explanation or link to where I might find some info would be appreciated. -Nick On Mon, May 20, 2002 at 09:39:52AM -0600, Andrei Cojocaru wrote: I believe mySQL uses B-Trees (not binary trees), that's about all I know :) Right. The indexes are B- Tree structures (until R-Trees appear in 4.1, of course). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: returning top two values
Not a problem. I think the easist way to do it is SELECT * FROM families ORDER BY score DESC LIMIT 2 Of course you need your grouping statement in there but the ORDER BY section shouldntmake a difference. There are MAX and MIN functions but my understanding is that those will only return THE highest/lowest values and not say the highest two values. It would work Ibelieve if there were two families with the same highest score. Someone correct me if I'mwrong. -Nick Hi, I have a table containing data on a number of families. I want to retrieve members of each family that have the two highest scoring values for a column. i.e the max and second max. Is there a function similar to max() or greatest() that will return the top 2 values when grouping by family ID? I can do this using perl in about three steps but would rather make life easier for myself if I can. Thanks in advance Rich mysql query - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: UPDATE question, SQL syntax, etc.
There is no from clause in the update syntax. However, I'm not sure how you would update a tablethe way you are trying to. I'm sure it can be done, and your SQL looks correct besides the fromclause. Just take that out and see if what it says. -Nick hi. i'm new to the list and have only been playing with mySQL for a few weeks now, i have a question regrading the syntax of an UPDATE statement - i hope nobody minds me asking. i want to uopdate a table with the data from another, i've written the following: update trackinfo SET trackinfo.postcode = newtrackinfo.postcode FROM trackinfo, newtrackinfo WHERE trackinfo.telephone = newtrackinfo.telephone; it should update trackinfo with the postcodes from newtrackinfo, as long as the telephone numbers match - but i get an errror - it complains about the 'FROM...' onwards. am i missign something simple? cheers, .ben - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Embedding MySQL...
Is it possible to embed MySQL in a stand alone java app? I know you can do it in c++/vb but waswandering if it was possible to do so in Java. Thanks for the help! -Nick - 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 admin of MySQL from Win 2K
Have you tried using phpMyAdmin?? It allows you to connect to several different host quiteeasily. You can download it at: http://www.phpwizard.net/projects/phpMyAdmin/index.html And actually any of the GUI front end apps for M$ should be able to connect to a remote server (I think). You just have tomake sure your MySQL permissions allow for outside users to log on. -Nick Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 index question
From my understanding primary keys and foreign keys are indexed. Someone correct me if I'mwrong here. And you shouldn't have to do anything else to field besides make it a float to usenegative numbers. -Nick Regarding mysql... 1) Are primary keys and foreign keys by default indexes for a table? 2) Do I have to use a special data other than float to allow for negative numbers, i.e. I want to be able to enter -1.76 and be able to later do math against that number... Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply. Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Age calculation
Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers datecalculations and has specifics on Age calcs. -Nick Hello, mysql, How to get Age from field date-time that contain dateofbirth and then display as xx year yy month zz days. Best regards. Kittiphum Worachat [EMAIL PROTECTED] 2002-05-15 - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Question about MySQL
As far as I know MySQL does not yet support nested SELECT statements. -Nick Hi, I am new in the MySql business so I'm sorry if my question is too simple. Is there any way to nest queries in MySql in the following manner: select field from table where id = (select ...) Thanks for your attention, Sigalit _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql- unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
java...mysql
Sorry if this got sent twice... Hello all. Im trying to right a simple program for MySQL through java but am running into a problem of sorts. Following is the code that has theproblem: conn = DriverManager.getConnection(jdbc:mysql://localhost/mysql?user=rootpassword=);stmt = conn.createStatement(); stmt.execute(CREATE DATABASE quake3parsed); conn.close(); shell.exec(C:\\mysql\\bin\\mysqladmin -u root - p reload).waitFor(); conn = DriverManager.getConnection(jdbc:mysql://localhost/quake3parsed?user=rootpassword==);stmt = conn.createStatement(); The problem is on the second connect try I get the following SQL Exception: SQLException: General error: Unknown database 'quake3parsed' SQLState: S1000 VenderError: 1049 But if I go to access MySQL from any other source it shows that the database has been created and is there. Is there any sort ofgrace period that I need to wait for MySQL to take the new db? Also I tried it by using: shell.exec(C:\\mysql\\bin\\mysqladmin -u root -p* CREATE quake3parsed).waitFor(); as well but that gave the same results. Thanks for the help in advance. -Nick - 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 Me
Whats your INSERT statement look like? And does it give any errors back? -Nick I am using MySql with Visual Basic. I Got an ERROR when trying to add a new record in situation as under. I have a table Company and a field in that table EmpName char (20) and one record is there value is = Piyush I am trying to add a new record I can add if the value of field is less then or equal to the length of old record len(Piyush) = 6.(Max Length of value from old records) If i will try to add Ashok i can add it BUT If I TRY TO ADD SANDEEP the length is 7 I could not add it. getting an error. and if there is not any record means maximum value from old record is zero then i could not add a record means clearly i could not add FIRST RECORD ANYWAY FORM VISUAL BASIC. what is solution Please help ME. Thanks in Advance - Piyush - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql- unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
SBS and MySQL
Hello all, We recently Installed MySQL on M$ lovely Small Business Server, and since then we have been experience some problems. I was wondering if any one had experience with SBSand MySQL and if they did or did not have any problems with it. Personally I don't think it is MySQL that is crashing it but try telling that to the IT guys =) Apparently some of the problems include the kernel crashing and some of the backups are failing for no apparentreason. Is there any way at all that MySQL could be responsible for these? I wouldn't thinkthat MySQL would do this as it simply runs as a service and doesn't particularly mess with anywindows settings. Thanks for the help! -Nick - 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
PHP Question
Ok so this really doesnt have anything to do with MySQL but I thought this might be a good placeto ask. Ok heres the problem. I am constructing a Message Board with MySQL and php (was usingASP) and I dont want the user to reload/repost data. For example, say the user goes to post amessage, after they hit the post button it takes them to a temp page saying that there post wassuccesful with a link to go view the post. The problem arises if some one decides to hit thereload button. Because of the way I have the posting page setup it will reload the page and postthe message again! doh! Anyways, has anyone come up against a similar problem and found a way around it? Thanks in advance. -Nick - 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:PHP Question
Thanks for all of you who responded with ideas. I think I'm going to go with the temp page,redirect solution. Seems to me that this is the simplest and easiest way to deal with it. I could have dont it with MySQL as some one stated by entering a unique identifier andkeeping track of that, but generating and passing that around could become a hassel, and Iknew there must have been a better way. Thanks again, -Nick - 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
storing files...
Is there a way to store files in MySQL? Looking to store somthing like a zip file in the databaseand be able to retrieve/download it from something like ASP. Thanks -Nick - 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
Text Field Inserts
I'm having a problem with trying to come up with a work around for this common(?) problem. I'mnew to using MySQL but have gotten a handle on it pretty easily. My problem is that I'm using itto develop a simple message board and of course message boards have a lot of text in them. My problem is when a user types in a word like can't or it's or something similar. You can see the problem in that ' will stop the current string and the next characters will be a newone, which of course wrecks havoc on the statement. Also haven't experimented with other punctuation but anything else to look out for would be nice as well. Thanks for the help in advance. -Nick - 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