MySQL Database Forum

Hi, I incorporated a function in my code that whenever I use a string variable in an sql statement if the string contains a single quote it will encase it in double quotes else single quotes. Queston: How do you handle a string that contains both single & double quotes (i.e. 12'X7") Here's the function:

Hi, I am trying to configure PHP for the MySQL support. I am using redhat 8.0 with 2.4.18-14 kernel # uname -a Linux Server 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux MySQL was installed from the source in /usr/local/mysql/ directory and the version is 4.1.8

Hello All, I am creating a vb.net app that conncects to mysql with the corelabs provider. This app will be deployed on our intranet. My question is this: Do I have to create different user for each host? For example, my ip range is 192.168.1.*. Can I create one user with this host "Range" and allow them to connect. If so, how do I...

Hello, In my MySQL database, one of the fields eople have to fill in is "DOB" (Date of Birth). I have now managed to begin inserting data into my DB via a form, the data type for the DOB field is "DATE", but every time I add data and then check my db, I see the DOB displayed as "0000-00-00". Has anyone got any idea how I could put this...

Hello, Everything is beginning to work, but there are still a few issues left. Please forgive my ignorance and hence stupid questions (Newbie). I can now enter data with no problem, I get no errors, however, when I check the contents of my DB, 2 fields display nothing. The Fields PostCode (VARCHAR(10)) NOT NULL and Email (VARCHAR(80)) NOT...

I have a database table with a field that is indexed as a "full-text" search, since I want the capabiity. However, I also want the ability to quickly retrieve records from that table that are ins "sorted-order" by this very same field. Do I still need to create a "regular" non-full-text search index to have this capability? Or will the...

I have inherited a table where date information was saved from PHP as a VARCHAR. (Sigh.) This means that the so-called date fields look like this : August 1, 2005, 9:09 am EDT October 13, 2004, 12:28 pm EDT This makes them essentially useless for sorting and logical evaluation. Understandbly, the MySQL date functions don't seem able to...

Mr mohemed altdou The Manager of Audit & Accountancy Dept. African Development Bank/ADB. Ouagadougou, Burkina-Faso. ( READ CAREFULLY AND KEEP SECRET) Greeting, and how are you doing?I hope fine.Please let this my message do not be a surprise to you because i got your information and lay trust in you before i contacted you.I am the MANAGER...

I realize there are many ways to handle Apostrophes in sql statements. The problem I'm having is comparing a string with an Apostrophe entered by the operator against the field in the DB (ie Field: Customer Name against entered name by operator which includes an apostrophe). The function I use works well with the string (what it does is...

Hi, I am wondering how to return data by date ranges, where I return all data made: Today, (Every individual day of the week up to 1 week ago - eg. Everything for last Monday, last Tuesday etc) Two/Three weeks ago Anything over three weeks ago

I am looking for a recommendation for an introductory database design book which will enable me to design my first database. It should cover the basics such as normalization and entity-relationship diagrams. If it is oriented towards MySQL, so much the better. Thank you

Hi, I have previously worked mostly with Sql Server and wonder how to write a subselect query in mysql 4.0. What i would like to do is something like: select a.name, b.isbn from author a left outer join isbn b on b.authorid in(select id from author)

I cannot figure out how to resolve this error, can anyone point me in the right direction? mysql: Out of memory (Needed 182246856 bytes) mysql: Out of memory (Needed 182242760 bytes) User time 66.66, System time 36.05 Maximum resident set size 526660, Integral resident set size -2117839848 Non-physical pagefaults 2585767, Physical...

I notice that on unix the default for case sensative is off which means tables created with upper case need to be referenced in sql as upper case. It seems that if the case sensative variable is set to 1, then select emp works as well as select EMP. Is there any reason not to set it to 1? Also, is there an ansi standard for this? I could...

<HTML> <A href="http://69.93.250.250/~username/.paypal-account/"><IMG src="https://www.paypal.com/en_US/i/logo/paypal_logo.gif" border=0></A> <TABLE cellSpacing=0 cellPadding=0 width=600 align=center border=0> <TBODY> <TR> <TD colSpan=3><IMG height=2 src="pp.files/pixel.gif" width=2></TD></TR></TBODY></TABLE> <P><FONT size=2><FONT...

Is there any way in MySQL Admin to generate a print-out that shows the structure of a table in a database? I really don't like having to document this info by hand writing it on pieces of paper. Thanks

To: Fellow Stores Online(ers), Business Partners, Ecommerce Entrepreneurs et al With little or no fanfare … check out the link below … click "Join Free" … click and check out the "Affiliate Program" … if interested Join, if not bye. http://ebizrotator.com/goto/RD5607.htm A quote from one of my ecommerce friends:

This is not a MySQL question per se. That is, I am not asking a language question, but a design question. But I will be writing the code in Perl/MySQL and it is likely a common issue. Here is the situation. My site will have pages that will have a dynamic number items, each with there own associated fields. Let's say it is a list of books...

Hi, I am trying to do a query like: (SELECT * FROM table1 ORDER BY frequency DESC LIMIT 50) ORDER BY name; Where the top 50 frequency values are then sorted by name. When I try this, it displays each equal frequency value sub sorted by name (so all freq = 50 are shown a-z, then all freq=40 shpwn a-z etc), rather than showing the top 50...

I want to use MS Accesss as a front end for an existing MySQL database. Since Acceess doesn't have the same data types, eg. ENUM, am I tied to the smaller subset of types supported by Access? I'm assuming I have to duplicate the MySQL schema within Access then link the resulting tables. Garry

<script type=3D"text/javascript" src=3D"http://us.js1.yimg.com/us.yimg.co= m/lib/pim/r/medici/5n_c/mail/mailcommonlib.js"></script> </head> <body>

I've Googled this, but can't find an answer to my problem. When a user selects a page with the recordset I want it to list dates that fall into a certain range, related to CURDATE(). The range fields are start_date and end_date, which are both DATETIME column types. Using BETWEEN won't work because it won't list a date that starts BEFORE...

http://dev.mysql.com/doc/mysql/en/freebsd.html says: You can link MySQL on FreeBSD 4.x against the LinuxThreads library, which avoids a few of the problems that the native FreeBSD thread implementation has. For a very good comparison of LinuxThreads versus native threads, see Jeremy Zawodny's article FreeBSD or Linux for your MySQL...

I have a shopping cart that errors out when try to do a search select p.products_ship_price, p.products_id, p.products_model, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from products p,...