Re: dumb question?
Goede morgen, and thank you for your suggestion. I am actually wondering if the difference between lasso 8.1 and 8.6 is so big that traditional lasso code can not be used when connecting w/ MySQL ? You mentioned ... This can be done in the server configuration, so no alterations are necessary Do you mean one of the mode that came with lasso (Server, site) to resume may I ask you to confirm: the simple code [inline:-add, -database=..., -table=..., field=value] can not be used anymore w/ MySQL, or can it? Alvast Bedankt --- On Wed, 7/6/11, Rik Wasmus rik.was...@grib.nl wrote: From: Rik Wasmus rik.was...@grib.nl Subject: Re: dumb question? To: mysql@lists.mysql.com Date: Wednesday, July 6, 2011, 10:27 PM On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1 You'll need to enable ANSI_QUOTES to be able the use '' as an identifier quote character rather then MySQL's default '`'. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes This can be done in the server configuration, so no client/lasso alterations are necessary. -- Rik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=luna...@yahoo.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: dumb question?
2011/07/06 23:56 -0700, XL Cordemans Goede morgen, and thank you for your suggestion. I am actually wondering if the difference between lasso 8.1 and 8.6 is so big that traditional lasso code can not be used when connecting w/ MySQL ? You mentioned ... This can be done in the server configuration, so no alterations are necessary This mode is set in my.cnf (under Windows my.ini), found in one of a variety of standard places, in the variable sql-mode, say sql-mode=ANSI,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION . The mode in question is ANSI. There is always a copy of this file in the directory into which the program MySQL was installed, but that is not the first place where it is sought. Under Linux, say, /etc/my.cnf takes precedence. Quote from help: On Windows, MySQL programs read startup options from the following files, in the specified order (top items are used first). File NamePurpose WINDIR\my.ini, WINDIR\my.cnf Global options C:\my.ini, C:\my.cnf Global options INSTALLDIR\my.ini, INSTALLDIR\my.cnf Global options On Unix, Linux and Mac OS X, MySQL programs read startup options from the following files, in the specified order (top items are used first). File NamePurpose /etc/my.cnf Global options /etc/mysql/my.cnfGlobal options SYSCONFDIR/my.cnfGlobal options $MYSQL_HOME/my.cnf Server-specific options defaults-extra-file The file specified with --defaults-extra-file=path, if any ~/.my.cnfUser-specific options ~ represents the current user's home directory (the value of $HOME). SYSCONFDIR represents the directory specified with the SYSCONFDIR option to CMake when MySQL was built. By default, this is the etc directory located under the compiled-in installation directory. MYSQL_HOME is an environment variable containing the path to the directory in which the server-specific my.cnf file resides. If MYSQL_HOME is not set and you start the server using the mysqld_safe program, mysqld_safe attempts to set MYSQL_HOME as follows: Let BASEDIR and DATADIR represent the path names of the MySQL base directory and data directory, respectively. If there is a my.cnf file in DATADIR but not in BASEDIR, mysqld_safe sets MYSQL_HOME to DATADIR. Otherwise, if MYSQL_HOME is not set and there is no my.cnf file in DATADIR, mysqld_safe sets MYSQL_HOME to BASEDIR. In MySQL 5.5, use of DATADIR as the location for my.cnf is deprecated. Typically, DATADIR is /usr/local/mysql/data for a binary installation or /usr/local/var for a source installation. Note that this is the data directory location that was specified at configuration time, not the one specified with the --datadir option when mysqld starts. Use of --datadir at runtime has no effect on where the server looks for option files, because it looks for them before processing any options. MySQL looks for option files in the order just described and reads any that exist. If an option file that you want to use does not exist, create it with a plain text editor. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: dumb question?
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1 You'll need to enable ANSI_QUOTES to be able the use '' as an identifier quote character rather then MySQL's default '`'. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes This can be done in the server configuration, so no client/lasso alterations are necessary. -- Rik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: dumb question?
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1 You'll need to enable ANSI_QUOTES to be able the use '' as an identifier quote character rather then MySQL's default '`'. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes Oh, and if possible, go for even more standards-compliant: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi -- Rik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: dumb question?
Rik and Crew String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled Column names are never surrounded by ticks or double quotes so TABLE table_name FOO VARCHAR(30) /snip where the INSERT statement for table table_name column FOO would look like: INSERT INTO table_name FOO VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS UNLESS ANSI_QUOTES ARE ENABLED'); Bedankt, Martin Subject: Re: dumb question? From: rik.was...@grib.nl To: mysql@lists.mysql.com Date: Wed, 6 Jul 2011 16:39:16 +0200 On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1 You'll need to enable ANSI_QUOTES to be able the use '' as an identifier quote character rather then MySQL's default '`'. See: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes Oh, and if possible, go for even more standards-compliant: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi -- Rik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
RE: dumb question?
On Wed, 2011-07-06 at 11:03 -0400, Martin Gainty wrote: Rik and Crew Please keep your replies to the list only, I don't need to double on e-mail... String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are enabled Column names are never surrounded by ticks or double quotes They surely can, and in this case, are. so TABLE table_name FOO VARCHAR(30) /snip where the INSERT statement for table table_name column FOO would look like: INSERT INTO table_name FOO VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS UNLESS ANSI_QUOTES ARE ENABLED'); May I quote: (error code) 1064 (error message) HY000 [Actual][MySQL] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1 See the double quotes around the column name? Aye? 'nuff said. Bedankt, Martin Graag gedaan, -- Rik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Dumb question (joining tables)
wrote: I have large fact table, in which there are much ids (that are in fact foreign keys but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of fact columns, so it has two fields (id (PK) and name)) in my query, it chooses strange execution plan. When I do simple join, it uses my second table as first, scanning it and joining records from fact table by their foreign key. If I do straight join or left outer join it makes full scan of second table, ignorig its pk (use key(primary) doesn't help). I guess, standart execution plan for all such cases must be scan of first table joining all other description tables by their PKs. Forgot to say that query fetches all data from fact table, grouping by some columns. You have not given us your table definitions or your queries. How are we supposed to answer your question. post your show create tables and the explains for your queries. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dumb Question - Moving Data from Access to MySQL
Jeremy Proffitt wrote: Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tried: INSERT INTO EXPARTAB1 VALUES (SELECT * FROM EXPARTAB) That should be: insert into EXPARTAB1 select * from EXPARTAB or maybe you should do something like: insert into destination_tablename ( field_1, field_2 ) select field_1, field_2 from source_tablename You'll have to do it the 2nd way if you change any field names. This is the most reliable way to shift data from one database to the other ( via Access ). You can use scripts, but you have to rely on the author of the script setting the data types correctly. Setup your tables yourself, making sure all your destination fields can accommodate your data, and the make a set of queries in Access ( access calls them 'append queries' ). If there is a problem, Access will usually let you know where it occured so you can go and fix it. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dumb Question: Listing tables in telnet
- is a continuatin line for your sql stamement. Remember yo conclude your statement with a semi=colon... Denis Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type in commands and it just does another - What is that? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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: Dumb Question: Listing tables in telnet
On Monday 19 November 2001 01:25, Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type in commands and it just does another - What is that? The - indicates that it is waiting for the rest of the query. You need to end each query with a semi-colon. Thus: mysql show tables;ENTER hth -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Professor Gorden Newell threw another shutout in last week's Chem Eng. 130 midterm. Once again a student did not receive a single point on his exam. Newell has now tossed 5 shutouts this quarter. Newell's earned exam average has now dropped to a phenomenal 30%. */ - 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: Dumb Question: Listing tables in telnet
Todd, The arrow is like the PS2 prompt from your shell in Unix. That is, the first line of your command says Mysql and every line thereafter is just a greater-than. This is because the mysql client is waiting for more commands. You can enter more than one command at a time this way, and not have to write it all out on one line. When you are finished with a command, place a semi-colon or a backslash-g. In other words, I think you wanted to enter the following command: Mysql show tables ; or Mysql show tables \g Note that the spacing between the command and the semi-colon (or \g) doesn't matter, you can have the sem come right after your text or you can add a space for clarity. --- Todd Williamsen [EMAIL PROTECTED] wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type in commands and it just does another - What is that? Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.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: Dumb Question...
Don't feel badly, I wondered the same thing! In a nutshell, they are logs, and you can delete them. You can also turn them off (I did). - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: MySQL Mailling List [EMAIL PROTECTED] Sent: Friday, September 21, 2001 2:36 PM Subject: Dumb Question... Okay, I know this is an RTFM question, but I tried, and I couldn't find it in the online manual. I was looking at the /var/lib/mysql directory today, where all my databases are, and I noticed a bunch of machine-bin files. What /are/ those, and are they something I need to be concerned about? -- Matthew Walker Ecommerce Project Manager Mountain Top Herbs --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 - 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: Dumb Question...
How would I go about turning them off? Yes, I know. Another RTFM question, but some of these things are a little hard to find in the online manual. -Original Message- From: Matthew Simpson [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 1:47 PM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: Dumb Question... Don't feel badly, I wondered the same thing! In a nutshell, they are logs, and you can delete them. You can also turn them off (I did). - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: MySQL Mailling List [EMAIL PROTECTED] Sent: Friday, September 21, 2001 2:36 PM Subject: Dumb Question... Okay, I know this is an RTFM question, but I tried, and I couldn't find it in the online manual. I was looking at the /var/lib/mysql directory today, where all my databases are, and I noticed a bunch of machine-bin files. What /are/ those, and are they something I need to be concerned about? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 - 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: Dumb Question...
Okay, I know this is an RTFM question, but I tried, and I couldn't find it in the online manual. Try loading the manual, then do your browsers equivalent of find in page, and search for -bin 3 or 4 searches on next occurence, and you're there I was looking at the /var/lib/mysql directory today, where all my databases are, and I noticed a bunch of machine-bin files. What /are/ those, Binary logs. and are they something I need to be concerned about? The binary log contains all information that is available in the update log in a more efficient format. It also contains information about how long every query that updated the database took. The binary log is also used when you are replicating a slave from a master. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Dumb Question...
-Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:48 PM To: 'Matthew Simpson' Cc: [EMAIL PROTECTED] Subject: RE: Dumb Question... How would I go about turning them off? Yes, I know. Another RTFM question, but some of these things are a little hard to find in the online manual. - especially when you don't bother looking... Try starting mysqld without --log-bin. If that doesn't work, then you might want to Read The Fine Manual sec. 4.9.4, The Binary Update Log. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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