July 10th, 2008
msquared (Administrator)
|
Posting Guidelines. Read carefully before you post in a forum!
Please follow this site's Posting Guidelines when posting questions or answers.
moderator more »
sticky
|
|
Converting an .SQL file to CSV/TSV with apache?
Apparently you can use Apache (or an Apache product?) to take .SQL database backup files and turn it into a CSV file.
Would it be easier to install... more »
|
|
whats wrong with using a BLOB?
the previous programmer for the html/php site i now have the reins of used a mysql database, but for SOME reason he decided to post product images to... more »
|
|
Tree in mysql
hi...
i am designing the database for an inventory system while designing it forming tree like structure.... so i am unable to implement tree in... more »
|
|
Stringing together a CASE expression
I am converting some MS Access queries into sharepointe reporting services and I'm stuck.
I have a query in access that basically says:
IIF ( =... more »
|
|
pls help me set root password
First of all, I'm not sure if I've set up root password for MySQL server or not. I was following this tutorial... more »
|
|
Between Dates
Hi,
I'm new to SQL and I have the following quesiton.
I have table of data as follows:
Date
31-01-2007
12-31-2007
31-01-2008 more »
|
|
Reset AutoIncrement Colume value
I need to change the value for a autoincrement value to start value of 10000 not 0. The column already exists. more »
|
|
Looking for "best practices" type suggestion.
I have a database that currently contains different albums. The way I had the database was that there is a "description" field in which I placed all... more »
|
|
max_allowed_packet
Is there a way where you can update or set the max_allowed_packet inside myslq browser?
I tried to change the my.cnf file but still does not take... more »
|
|
Modify max allowed packet
I am already using MySql 5 and is currently working on a code to save pictures to a table. How can I modify the max_allowed_packet system variable? more »
|
|
negative value is sql
i have a query like this
select (a+b+c)-(d+e) where some condition
this fetches one record and the values in the table are like... more »
|
|
Subquery convertion to run in mysql 4.0
Hi
I have encounter problem in mysql with my query regarding subquery support. The IN and NOT IN are not supported.
my client's server is running... more »
|
|
Closing connections
Hi
I'm running a popular site which hasn't had any problems up to a year ago. Pages can take an age to load and the site is often down. Although... more »
|
|
How to check if a table is empty?
Hi Guys,
I want to check if a table is empty or not?
In my table (i.e test) have no records and id is a primary key as well as auto increment... more »
|
|
Help with MySQL Group function (I think)
I have a table salary, and when I select it, it looks like this
Name Year Income
-------------------------------
James Smith 2008 ... more »
|
|
How Can I get PHP script to work in a MySQL row?! (Please help ASAP!)
Hi, I've almost set myself up a fully working CMS type thing, all that I'm lacking is a submission form, which I've made. for the pages, I'm using... more »
|
|
query failing with indexed (or not) ORDER BY
Hi MySQL masters,
I've got a bit of an issue here I'm hoping somebody will be able to help me with.
I have a large DB (1 million plus rows) and... more »
|
|
Representing or determining "friend of a friend of a friend" relationships
1 Reply |
Posted by: FLEB
| Last post by Atli, 5 days ago
I'm working on a PHP/MySQL site with social networking and "message blast" functionality, and I'm not sure what the best method to represent multiple... more »
|
|
DB Backu Query
Hi,
Any one can suggest me to take a backup using mysql Query in windows xp without using any tools.
Thanks & Regards,
JSuresh more »
|
|
Is this inefficient? (A little too much complexity.)
Alright, I finally worked up a massive SQL query that gets me the result I want for my PHP 6 CMS: Module Engine Class.
I have read various comments... more »
|
|
MySQL Getting Started
Good day,
Im currently developing a Java API to be used for our project( Simple website using JSP ).
Now, i really don't have any idea how to... more »
|
|
Connecting to MySql DB from a .NET app
1 Reply |
Posted by: ypytt
| Last post by coolsti, 5 days ago
Hi all,
I'm developing a Windows application in C# using Visual Studio 2005. The application should be able to read data from a MySql database. I've... more »
|
|
Help wiet error
http://img369.imageshack.us/img369/3838/otroerrogb7.jpg
my error i its create one server game name lineage 1 plz any help me more »
|
|
read/write table efficiency
Hey mysql gurus,
I've got a bit of an efficiency question, and just trying to figure out how best to manage this.
For my site HearWhere.com, I... more »
|
|
selection on many to many with uniqueness of one field
hi, first of all, sorry for my bad english!
i have 3 tables: companies, contacts and an inbetween table: compcont
i want to select some companies... more »
|
|
