MySQL University session on October 1: InnoDB Internals: InnoDB File Formats and Source Code Structure
InnoDB Internals: InnoDB File Formats and Source Code Structure http://forge.mysql.com/wiki/InnoDB_Internals:_InnoDB_File_Formats_and_Source_Code_Structure This Thursday (October 1st, 14:00 UTC - one hour later than usually), Calvin Sun will give a session on InnoDB Internals: InnoDB File Formats and Source Code Structure. The InnoDB storage engine provides transactions, row-level locking, and automatic crash recovery. Its on-disk files play a pivotal role for those key features. This presentation describes how on-disk files are structured, how compressed tables are organized, and how long variable-length columns are stored. As we develop new features, it is inevitable for file format changes. We will explain how the new file format management works in the InnoDB Plugin. This talk also covers InnoDB source code structure. For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks: * October 8: Building MySQL Releases on Unix (Jörg Brühe) * October 15: The Spider Storage Engine (Giuseppe Maxia) * October 22: Dual Master Setups With MMM (Arjen Lentz) * October 29: MySQL scalability on SPARC INTEL X5500 (Nehalem) (Benoit Chaffanjon) * November 12: Gearman for MySQL (Giuseppe Maxia) * November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith) * December 3: Practical Full-Text Search in MySQL (Bill Karwin) The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Is It Possible to create a Join with Multiple Tables
c...@hosting4days.com wrote: :Newbie: Short Question: Is it possible to create an inner join (or another join) with multiple tables? something like $query_list1 = SELECT table1.id,table1.status, table2.id, table3.id (more here - etc.) FROM table1 INNER JOIN table2 ON table1.id = table2.id INNER JOIN table3 ON table2.id = table3.id WHERE table1.status = 'open'; Q: Is something like this possible? The easiest way to find out if something might work is to try it. Did you actually try the statement you posted above? Assuming your typing was correct, it should have worked just fine. For future reference, here is the JOIN page in the MySQL manual: http://dev.mysql.com/doc/refman/5.1/en/join.html Suggestion -- If you have a problem: document what you did, what you did it to, and the error message you received. Include any alternatives you have tried and enough explanation that we can figure out what you are trying to accomplish. Normally this will get you correct and accurate responses very quickly. -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Newbie question: importing cvs settings
-Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: Sunday, September 27, 2009 10:19 AM Cc: 'mysql' Subject: Re: Newbie question: importing cvs settings Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? [JS] This is just a shot in the dark, but Excel can be rather surprising when it puts out a CSV file. Depending upon the data, and exactly how you've specified the export, it can put double-quotes in unexpected places. If you leave out the 17th line of data what happens? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Patrice Olivier-Wilson wrote: Yep, typo ...:-( I did some screen shots of 2 tests. A workaround solution is to make a final entry in the csv file that I don't really need. Then everything up to that point gets imported ok using CSV method. The LOAD DATA method did not enter anything. My earlier assumption about line 17 was false. It was dependent on how many rows, and I had been using tests with same amount of data. As I said, very beginner level, so thanks for the patience. screenshots at http://biz-comm.com/mysqlprojects/ thank you -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the- infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Create Syntax (easy)
Hi; Please give me the syntax below such that I can force the insert statements to use only selected values (item1, item2, item3): create table (field SOMETHING_HERE item1 item2 item3, ... ) TIA, Victor
Re: Newbie question: importing cvs settings
Jerry Schwartz wrote: [JS] This is just a shot in the dark, but Excel can be rather surprising when it puts out a CSV file. Depending upon the data, and exactly how you've specified the export, it can put double-quotes in unexpected places. If you leave out the 17th line of data what happens? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com Thanks Jerry, Gavin and John: Sorry for not an immediate response to all of your suggestions. Other demands were pulling at me since I first asked for assistance. I opened the .csv file with Text Wrangler, and the commas are missing at about line 17 portfolio_ID,portfolio_sort_ID,portfolio_title,portfolio_bodycopy,portfolio_image,portfolio_before ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg, ,1,Kitchens,,123.jpg ,1,Kitchens,,123.jpg ,1,Kitchens,,123.jpg So not sure why that is happening. I'm on a Mac, using Excel 2008. But at least you all have helped me find what it is doing, so now, I can at least pull into a txt file and make corrections manually. My thanks to all of you for your help and patience. (above represents an empty portfolio_ID, a filled in sort_ID, title, empty bodycopy, image, empty before) Thank you. -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Create Syntax (easy)
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi victorsube...@gmail.comwrote: Hi; Please give me the syntax below such that I can force the insert statements to use only selected values (item1, item2, item3): create table (field SOMETHING_HERE item1 item2 item3, ... ) TIA, Victor CREATE TABLE set_test( rowid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, myset SET('Travel','Sports','Dancing','Fine Dining') ); From: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html David -- There is more hunger for love and appreciation in this world than for bread.- Mother Teresa
Re: Create Syntax (easy)
That's it! Thanks, V On Tue, Sep 29, 2009 at 12:13 PM, David Giragosian dgiragos...@gmail.comwrote: On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi victorsube...@gmail.com wrote: Hi; Please give me the syntax below such that I can force the insert statements to use only selected values (item1, item2, item3): create table (field SOMETHING_HERE item1 item2 item3, ... ) TIA, Victor CREATE TABLE set_test( rowid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, myset SET('Travel','Sports','Dancing','Fine Dining') ); From: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html David -- There is more hunger for love and appreciation in this world than for bread.- Mother Teresa
SELECT by day
Hi, I want to search all rows with datum = 'tuesday' for example, something like: SELECT * FROM `table_anw` WHERE datum=DAYOFWEEK(3); '3' as tuesday. I found in the manual I can do: SELECT DAYOFWEEK('1998-02-03'); and will get '3' for Tuesday. But thats not what I want. I want to select only tuesdays. Any ideas? Thanks in advance Kerstin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: SELECT by day
Have you tried this? SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; Kerstin Finke kerstinfi...@hotmail.com escreveu na mensagem news:20090929130406.9802.qm...@lists.mysql.com... Hi, I want to search all rows with datum = 'tuesday' for example, something like: SELECT * FROM `table_anw` WHERE datum=DAYOFWEEK(3); '3' as tuesday. I found in the manual I can do: SELECT DAYOFWEEK('1998-02-03'); and will get '3' for Tuesday. But thats not what I want. I want to select only tuesdays. Any ideas? Thanks in advance Kerstin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: SELECT by day
Try this SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; Scott Swaim I.T. Director Total Care / Joshua Family Medical Care (817) 297-4455 Website: www.totalcareclinic.com NOTICE: The information contained in this e-mail is privileged and confidential and is intended for the exclusive use of the recipient(s) named above. If you are not the intended recipient or his or her agent, you are hereby notified that you have received this document in error and that any use, disclosure, dissemination, distribution, or copying of this message is prohibited. If you have received this communication in error, please notify the sender immediately by e-mail, and delete the original message -Original Message- From: Kerstin Finke [mailto:kerstinfi...@hotmail.com] Sent: Tuesday, September 29, 2009 8:04 AM To: mysql@lists.mysql.com Subject: SELECT by day Hi, I want to search all rows with datum = 'tuesday' for example, something like: SELECT * FROM `table_anw` WHERE datum=DAYOFWEEK(3); '3' as tuesday. I found in the manual I can do: SELECT DAYOFWEEK('1998-02-03'); and will get '3' for Tuesday. But thats not what I want. I want to select only tuesdays. Any ideas? Thanks in advance Kerstin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sc...@tmcclinic.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: SELECT by day
SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; SELECT * FROM `table_anw` WHERE WEEKDAY(datum) = 2; SELECT * FROM `table_anw` WHERE DAYNAME(datum) = 'Tuesday'; SELECT * FROM `table_anw` WHERE DATE_FORMAT(datum,'%W') = 'Tuesday'; SELECT * FROM `table_anw` WHERE DATE_FORMAT(datum,'%a') = 'Tue'; DAYOFWEEK function begins back (1 for Sunday, 2 for Monday, ..., 7 for Saturday) (See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_dayofweek) WEEKDAY function begins back (0 for Sunday, 1 for Monday, ..., 6 for Saturday) (See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_weekday) DAYNAME brings back day of week fully spelled out (Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday) (See http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_dayname) DATE_FORMAT using special metacharacters for date and time components (see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format) These queries should all bring back the same results where datum is a Tuesday Give it a try !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Kerstin Finke [mailto:kerstinfi...@hotmail.com] Sent: Tuesday, September 29, 2009 9:04 AM To: mysql@lists.mysql.com Subject: SELECT by day Hi, I want to search all rows with datum = 'tuesday' for example, something like: SELECT * FROM `table_anw` WHERE datum=DAYOFWEEK(3); '3' as tuesday. I found in the manual I can do: SELECT DAYOFWEEK('1998-02-03'); and will get '3' for Tuesday. But thats not what I want. I want to select only tuesdays. Any ideas? Thanks in advance Kerstin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Unable To Remove User
I just created a generic test user account on MySQL 5.1 and now for some reason I am unable to remove him... mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select User, Host from user; +++ | User | Host | +++ | carlos | localhost | | root | localhost | +++ 2 rows in set (0.01 sec) I obviously from above have a user name 'carlos'@'localhost' when I try to delete him, I get the following: mysql drop user 'carlos'@'localhost'; ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' Can someone please help me understand why I am unable to remove this user from MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Unable To Remove User
At 06:35 PM 9/29/2009, Carlos Williams wrote: I just created a generic test user account on MySQL 5.1 and now for some reason I am unable to remove him... mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select User, Host from user; +++ | User | Host | +++ | carlos | localhost | | root | localhost | +++ 2 rows in set (0.01 sec) I obviously from above have a user name 'carlos'@'localhost' when I try to delete him, I get the following: mysql drop user 'carlos'@'localhost'; ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' Can someone please help me understand why I am unable to remove this user from MySQL? Why don't you just say Drop User carlos? Also are you logged in as root? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mo...@fastmail.fm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Simply join that confuses me.
I have a table of projects with several columns for the IDs of some people in various roles, and then a table of the people. How can I get all the people for a given project, but keep their roles straight? Projects -- Project_ID Boss_ID Admin_ID Assistant_ID People ID Name Can I do something like this: SELECT * from Projects where Project_ID = 5, Name from People where Projects.Boss_ID = People.ID as Boss_Name, Name from People where Projects.Admin_ID = People.ID as Admin_Name, Name from People where Projects.Assistant_ID = People.ID as Assistant_Name I know that syntax isn't right but I'm not sure where to go. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org