Re: Character escaping
On 12/5/03 10:40 PM Bob MacIsaac wrote: [...] This is likely something simple but I've spent too much time on it with no results - hope somebody can help - thanks. Hi Bob - try looking into the $dbh-quote() method. --Jo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: odbc 3.51.06
Prathima Rao [EMAIL PROTECTED] wrote: dear mysq team, i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06 please help What OS do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what about foreign keys?
Hi there I have some trouble with MyISAM tables. I have found that supports 3 different types of the 1:1 relation. a)1:1 b)1:1 (Non-Identyfying) c)1:1 (Descedent Obj.) What all these about? What type of tables do u use normally? I want to deploy a small application with a few tables (up to 10) in a system with 233 Mhz and 48 mb ram, so something light is required... Thx Suggestions plz? __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't seem to reset password
[EMAIL PROTECTED] wrote: I have been reading and following the instructions from: http://www.mysql.com/doc/en/Resetting_permissions.html But, if I do: ./bin/mysqld_safe --skip-grant-tables And then I: mysqladmin -u root password 'mypassword' I get: mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' Flush privilege tables and then change password. this is a 3.2 install that was working just fine but I just did an upgrade to 4.1. I think I did the ?update permissions? script ok when I did the install. But is this the problem? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date query problem
Hi,This query is give an error like below;There is a column that name and description are date in Table that also include database.in the table,there are some date like that:2003-12-01,2003-11-16,2003-12-01,2003-12-03,2003-11-19. when i run this query,if i query between 2003-12-01 and 2003-12-05,result is right, but if i query 1 mount ago (i mean between 2003-11-15 and 2003-12-05), the data is between 2003-12-01 and 2003-12-05 date. data that in 11. mount didn't listed.how can solve this problem...This Sql query:Sqlquery = "SELECT * FROM table1 WHERE Gruop like '" txtGruop.Text "' And date_first between '" txtdate1.Text "' and '" txtdate2.Text "' Order by date_first ASC ; "Adodc1.RecordSource = SqlqueryAdodc1.Refresh This my table constructions;Table name:Table1Name |Surname|Group |Date_First---Hasan |DEMIR |Chief |2003-11-05Abidin |BESON |Chief |2003-11-16Tosun |KALAS |Chief |2003-11-18Kazm |RUSTU |Manager|2003-12-03Ali |HASIM |Worker |2003-11-20Kaan |ATES |Worker |2003-12-04Kadir |KEK |Worker |2003-12-01Aslan |SUCU |Worker |2003-11-22Kadriye|OZEN |Worker |2003-12-15Halis |ERKILET|Worker |2003-11-21Kazm |HAS |Worker |2003-12-07Sqlquery = "SELECT * FROM table1 WHERE Gruop like 'Chief' And date_first between '2003-12-05' and '2003-12-15' Order by date_first ASC ; "Query result: 2003-12-05,06,07,08,09,10,11,12,13,14,15but;Sqlquery = "SELECT * FROM table1 WHERE Gruop like 'Chief' And date_first between '2003-11-16' and '2003-12-04' Order by date_first ASC ; "Query result: 2003-12-01,02,03,04 What is problem? Best regards
Query how to??
Hi, I'm having problems to make a query. Situation: One table with data: JobID,Year,Week,Place,Name 1,2003,1,Place1,Person1 2,2003,1,Place2,Person2 3,2003,2,Place1,Person3 4,2003,2,Place2,Person4 5,2003,3,Place1,Person2 6,2003,3,Place2,Person6 7,2003,3,Place3,Person5 8,2003,4,Place1,Person1 9,2003,4,Place3,Person5 I want to query this table to get the following result: Year,Week,P1,N1,P2,N2,P3,N3,... 2003,1,Place1,Person1,Place2,Person2,, 2003,2,Place1,Person3,Place2,Person4,, 2003,3,Place1,Person2,Place2,Person6,Place3,Person5 2003,4,Place1,Person1,,,Place3,Person5 What should the select query be to achieve this?? Thanks --- [This E-mail is scanned for viruses by Declude Virus, this service is provided to you by Syscom nv (http://www.syscom.be)] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I share the MySQL data and where data and index files are stored
Dear All, I am working on linux 8.0 and mysql 4.0.18. I want to know where the mysql stores the data files and index files? I know at the time of table creation mysql creates 3 file .frm, .MYD, .MYI and is stored in the path given by --datadir=, I want to know when I call insert row then where is this data goes I mean in which file it stores. I want to shared the database files but when I do this it shares only the table definition not the table data, shows tables are empty. So can anyone please help in sharing the table data. Any help in this regards is welcome. Thank You with regards bhartendu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Form Handling.
I have just made a form using html, I wish to publish it, on to my website, but do I need to have a databse on a server so that my customers can submit their information to me? Is there another way of doing it. I look forward to your reply. Yours Sincerely Wesley - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
MySQL installation problem
Hello, I have made a fresh installation of SuSE Linux 9.0. Now I try to install MySQL, but I cannot start mysqld, it always terminates. These are the two installation commands I used after installing with YaST: LPC:~ # mysql_install_db - all tables have been created in /var/lib/mysql/mysql/ including host.frm LPC:~ # mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 031206 15:05:20 mysqld ended The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete What is wrong? What can I do now? Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Form Handling.
email the form contents to yourself or write it to a text file and store that on your server. hth jeff Wesley Philpot [EMAIL PROTECTED]To: [EMAIL PROTECTED] hoo.com cc: Subject: Form Handling. 12/06/2003 09:41 AM I have just made a form using html, I wish to publish it, on to my website, but do I need to have a databse on a server so that my customers can submit their information to me? Is there another way of doing it. I look forward to your reply. Yours Sincerely Wesley - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I share the MySQL data and where data and index files are stored
Bhartendu Maheshwari [EMAIL PROTECTED] wrote on 06/12/2003 14:40:29: I know at the time of table creation mysql creates 3 file .frm, .MYD, .MYI and is stored in the path given by --datadir=, I want to know when I call insert row then where is this data goes I mean in which file it stores. I want to shared the database files but when I do this it shares only the table definition not the table data, shows tables are empty. So can anyone please help in sharing the table data. The table definition is in the .frm file, the raw table data in the .MYD file and the indexes in the .MYI file. HOWEVER, it is very dangerous to share these files. MySQL performs extensive internal caching, so that it is rarely possible to know when these files are up-to-date while mysqld is running. Sharing the data files, rather than sharing the mysqld server, is not to be recommended at all. Could you perhaps explain what you are trying to achieve? There is quite likely to be a better way to achieve it. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 03:52:05PM +0100, Franz Edler wrote: The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete What is wrong? Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
perl DBI vs. prepare and execute do
I am using the Perl DBI to connect to a mySQL database. I am using prepare and execute statements to send the query to the database and then execute it. Is there any benefit to doing this versus using do? Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MAC OS X installation problem
On Dec 05, 2003, at 17:00, Lost Idols wrote: A newbie here, with a simple question (I guess). I just installed MySQL on my OS X 10.2 But failed pretty quick. Please help me... I wanna get started. This it what it looks like after following the description in the ReadMe file. Last login: Fri Dec 5 22:41:28 on ttyp1 Welcome to Darwin! [COVERMAN:~] staffan% sudo /Library/StartupItems/MySQL/MySQL start Starting MySQL database server [COVERMAN:~] staffan% /usr/local/mysql/bin/mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [COVERMAN:~] staffan% It sounds like you have to install the permissions tables. Run this command: /usr/local/mysql/bin/mysql_install_db And then do as it says. After that, you should be able to start MySQL with the StartupItems script. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Undefined symbols error message
Hi, I am a mySQL newbie and would appreciate any possible help you may be able to provide with the following query. I recently installed mySQL on Mac OS X.2 following all the necessary instructions, got the mySQL daemon running. All fine and well I thought until I tried to access the mySQL database to start creating Tables only to receive the following error message in the terminal application: dyld: bin/mysql Undefined symbols: bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap Can anybody help me with what this means and what I have to do to rectify the above? I am very new to mySQL and I cannot get any further than this! What have I done that's wrong because all the reference manuals I look at are absolutely blank on this error. If anyone out there can provide any suggestions I would be more than grateful. Yours Sincerely James Griffiths -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation problem
From: Chris Elsworth Sent: Saturday, December 06, 2003 5:09 PM The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user root (using YaST) and created the database-files with mysql_install_db also as user root. Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 08:20:57PM +0100, Franz Edler wrote: Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user root (using YaST) and created the database-files with mysql_install_db also as user root. During normal operation, mysql should run as the user mysql, so it can't read those. You'll want to chown them. Not having a mysql group isn't critical, but if you haven't got a mysql user then I dare say you need to check the installation process, because it probably hasn't worked correctly. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: perl DBI vs. prepare and execute do
On 12/6/03 8:52 AM Dan Anderson wrote: I am using the Perl DBI to connect to a mySQL database. I am using prepare and execute statements to send the query to the database and then execute it. Is there any benefit to doing this versus using do? The O'Reilly book Programming the Perl DBI says: ...the do() method supplied by the DBI makes executing non-SELECT statements much simpler than repeatedly preparing and executing statements. ... There is a drawback to doing this, however: performance. If you invoked do() repeatedly to insert a huge number of rows into a table, you could be preparing a statement handle many times more than is required, especially if the statement contained placeholder variables. HTH. --Jo smime.p7s Description: S/MIME Cryptographic Signature
MySql40, MSAccess2003, MyODBC3.51, and white spaces.
I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC process completes but due to Access insistance on nonconformity it creates tables with spaces in the field names. Example: db=lergdb table=LERG_6 field =LERG_6.SHA INDICATOR I could manually go in and rename every field but this database needs to migrate weekly. All my scripts are php based. My issue is I can't figure out how to tell php to query a field on a table with a space in the name: $query=SELECT LERG_6.SWITCH, 'LERG_6.SHA INDICATOR' FROM LERG_6 WHERE 'LERG_6.SHA INDICATOR' = 00; returns either an error or : NOGLEXADS0 LERG_6.SHA INDICATOR can someone help me either fix my ODBC load or help me correctly syntax my php query line? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.
Duke, Brian wrote: I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC process completes but due to Access insistance on nonconformity it creates tables with spaces in the field names. Example: db=lergdb table=LERG_6 field =LERG_6.SHA INDICATOR I could manually go in and rename every field but this database needs to migrate weekly. All my scripts are php based. My issue is I can't figure out how to tell php to query a field on a table with a space in the name: $query=SELECT LERG_6.SWITCH, 'LERG_6.SHA INDICATOR' FROM LERG_6 WHERE 'LERG_6.SHA INDICATOR' = 00; returns either an error or : NOGLEXADS0 LERG_6.SHA INDICATOR can someone help me either fix my ODBC load or help me correctly syntax my php query line? Try using backticks: `field with spaces` And try migrating away from Access, or you'll be increasingly more sorry as your project increases in size. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySql40, MSAccess2003, MyODBC3.51, and white spaces.
I agree with that. the LERG does not get generated by us. I push it immediately to Mysql every week. so you are recommending: $query=SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00; (the backticks are around `LERG_6.SHA INDICATOR`) is this correct? -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 2:46 PM To: Duke, Brian; [EMAIL PROTECTED] Subject: Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces. can someone help me either fix my ODBC load or help me correctly syntax my php query line? Try using backticks: `field with spaces` And try migrating away from Access, or you'll be increasingly more sorry as your project increases in size. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.
Duke, Brian wrote: I agree with that. the LERG does not get generated by us. I push it immediately to Mysql every week. so you are recommending: $query=SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00; (the backticks are around `LERG_6.SHA INDICATOR`) is this correct? That's what I had in mind. It works in Access with ADO. I assume it works in PHP, but I've never had to do it from PHP. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL vs. MaxDB
I looked at SAP about 6 months ago. I don't know what MySQL has done with SAP since they took it over, but I found SAP to have limited (and poor) documentation, was difficult to setup, was a source-code nightmare (it's written in more than one language, and uses a pre-compiler to unify the source-base before compiling), etc. I found SAP to be inpenetrable, and I'm an Oracle DBA (Oracle itself is often considered overly complex). I would suggest PostgresQL before SAP if you want the triggers, views, and stored procedures (assuming you don't want to pay for Oracle). David. - Original Message - From: Matthew [EMAIL PROTECTED] To: Keith Bussey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 4:18 PM Subject: Re: MySQL vs. MaxDB from http://www.mysql.com/press/release_2003_35.html The MySQL database is a high performance relational database management system that is noted for its speed, stability and ease of use, while MaxDB is certified for SAP applications and includes features such as stored procedures, triggers and views, for the most demanding enterprise use. I know, it's a lazy response. I haven't noticed any performance comparison artiles. - Original Message - From: Keith Bussey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:25 PM Subject: MySQL vs. MaxDB Hola, I was wondering if anyone could point me to any articles or URLs that could give me an idea of the differences between MaxDB and MySQL, specifically if one were to use MaxDB instead of MySQL, what disadvantages would come with the advantages (which to me are basically some of the features MySQL doesnt have yet.) ?? Off the top of my head, I assume MySQL would be faster than MaxDB for web- based applications/sites, but thats just an assumption I'd like to find some facts. Thanks, -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- 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]