Login or Sign up Help | Site Map
Connecting Tech Pros Worldwide

MySQL Forum

MySQL database (open source) - Ask questions about mysql server, setup, queries, optimization, errors, tables, syntax, functions, SQL, storage engines, MySQL cluster, replication, scalability, availability, stored procedures, views and more.
Posting Guidelines. Read carefully before you post in a forum!
1 Reply | Posted by: ronverdonk | Last post by ronverdonk, 564 days ago
Please follow this site's Posting Guidelines when posting questions or answers. moderator more »
sticky
Designing a database problem
4 Replies | Posted by: drhowarddrfine | Last post by coolsti, Today
Someone normally does this stuff for me but I want to do this one. I'm having trouble visualizing how a table should be laid out where you would... more »
My Site Down. Re installed MySQL copy DB files back?
1 Reply | Posted by: dlite922 | Last post by dlite922, Yesterday
MySQL installation took a dump, (Windows XP) so I reinstalled, now the service starts fine. I want to put the my databases back. I tried to just do... more »
need to combine these two queries
2 Replies | Posted by: bips2005 | Last post by bips2005, 3 days ago
i have got two queries, $sql1 = "select cust_id from customer where comp_name = '$compname'"; $result =... more »
Connect to MySQL database
4 Replies | Posted by: miraan | Last post by r035198x, 3 days ago
This may seem REALLY obvious, but I am a beginner at MySQL and I have just created a new database in phpmyadmin. I have now opened up the mysql... more »
Backing up MySQL with PHPadmin
Post Reply? | Posted by: SSmeredith | Last post by SSmeredith, 3 days ago
Hi All! I'm really stumped to resort to posting a question online - and thank heavens for that! I learned it all from folks like you (gosh I sound... more »
Asking what datatype should I used?
1 Reply | Posted by: lotus18 | Last post by amitpatel66, 3 days ago
Hello World! I am currently working on a field that contains 'Prices' I declared its datatype as double, Length=7 and Decimals=2and it works fine... more »
Building MySQL on WinXP
3 Replies | Posted by: deepakd | Last post by deepakd, 3 days ago
I am using WinXP.I am trying to build MYSQL from source. I am using Visual C++ 2008. Can anybody help me out? more »
Format the auto_increment
4 Replies | Posted by: lotus18 | Last post by lotus18, 4 days ago
Hello World How to format the auto increment in mysql? Something like 000001 000002 000003 . . . more »
#1030 - Got error 28 from storage engine
Post Reply? | Posted by: abhishek2609 | Last post by abhishek2609, 4 days ago
I got this error #1030 - Got error 28 from storage engine when i'm trying to access any table from my database.........or also when i'm trying to... more »
#1030 - Got error 28 from storage engine
Post Reply? | Posted by: abhishek26 | Last post by abhishek26, 4 days ago
I got this error #1030 - Got error 28 from storage engine when i'm trying to access in table in my database.........or when i'm trying to edit... more »
How to retrieve comings birth days
2 Replies | Posted by: kamill | Last post by amitpatel66, 4 days ago
Dear Strange Friends, I need to fetch birth date (in dd-mm format) in ascending order start from current date(dd-mm format), But i am unable to... more »
Error in Selection MySQL client ran out of memory
Post Reply? | Posted by: vjayis | Last post by vjayis, 4 days ago
Hi i got an error while my site gets loaded Warning: mysql_query() : Unable to save result set in /path../includes/mysql.class.php on line 39 Error... more »
problem with create table
1 Reply | Posted by: swethak | Last post by amitpatel66, 4 days ago
Hi, In my phpmyadmin i logged with username and password.And create a new database.Thenafter i created the table and click on go button it gives... more »
Procedure: error -1?
1 Reply | Posted by: AdamGr | Last post by amitpatel66, 4 days ago
This must be a pretty newbie mistake, but I'm still flummoxed by it. I created a very simple procedure: create procedure deleteAll () begin delete... more »
Connecting to MySQL over a network? How?
1 Reply | Posted by: coolsti | Last post by coolsti, 4 days ago
What I actually really want to do is to access my MySQL database running on Linux from C# programs running on Windows on the same network. As a... more »
MYSQL: Return any value on missing row.
1 Reply | Posted by: pechar | Last post by pechar, 5 days ago
Hi Guys, I'm having problems returning a set of rows. What I have is two tables, one to store properties and another storing the images (image... more »
Normalization
1 Reply | Posted by: smartic | Last post by Stang02GT, 5 days ago
I'm new to MySQL language and my question is what is the idea of Normalization when i enter the data twice in the table but with foreign key... more »
how to find maximum occurences of distinct value?
5 Replies | Posted by: zensunni | Last post by coolsti, 6 days ago
Say we have a couple of tables like so: Departments_to_Employees department_id employee_id Employee employee_id I want to find how many employees... more »
using wildcard character in query
2 Replies | Posted by: dstyles7 | Last post by dlite922, 7 days ago
i created a list box and text box with a command button below the txt box is used to find info in the list box . i created a sql stament that does... more »
Sort with GROUP BY, HAVING
Post Reply? | Posted by: macaco | Last post by macaco, 8 days ago
Hi I've got the following table: id id_items id_fc nombre cantidad unidad precio moneda 1 1 0 Prod1 9612 unidad 152 dolar 21 1 1 prod3 150 NULL... more »
Formatted number column cannot be sorted by number
3 Replies | Posted by: dlite922 | Last post by dlite922, 8 days ago
This is again from the dynamic reporting module i'm building. Columns come in and are built based on XML doc and the HTML (smarty template) does... more »
Enter life-time rule for rows in a table
2 Replies | Posted by: luttkens | Last post by debasisdas, 8 days ago
I'm gonna keep track of all uniqe visitor on a web page and therefore I need to store all visitors IP-number. Each IP-number is only counted as a... more »
Advantages of JOIN
2 Replies | Posted by: pankajit09 | Last post by coolsti, 8 days ago
Hello, Does avoiding multiple queries the only advantage of JOIN ? more »
3 table join
8 Replies | Posted by: gertie2008 | Last post by coolsti, 9 days ago
Hi, I've got 3 tables: 1.) book: BookID, Title 2.) bookcomment: BookCommentID, BookID, ContactID, Comment 3.) responsibilitylog: ResponsibilityID,... more »
Multi Query Issue
3 Replies | Posted by: arggg | Last post by coolsti, 9 days ago
I have 3 tables I need to get data from. Which as fields I need from each. opencases_daily - Assigned_To, Prov_Group tsms - Group, Name prov_groups... more »

Top MySQL Forum Contributors