Connecting Tech Pros Worldwide
 
 
Sign In | Register Now About Bytes | Help | Site Map
[ http://bytes.com/adLoader.php?parent=database
Bytes > Forums - Questions and Answers > MySQL Forum

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.
Subscribe View Unanswered Questions Post a Question
September 9th, 2008 msquared (Administrator)
Posting Guidelines. Read carefully before you post in a forum!
[image]1 Reply | Posted by: ronverdonk | Last post by ronverdonk, 659 days ago
Please follow this site's Posting Guidelines when posting questions or answers. moderator more »
sticky
Check if a record exists in the last 30 records
[image]6 Replies | Posted by: djpaul | Last post by Atli, Today
Hello! I want to check if a record exists in the last 30 records that were added. For example, i have a table wich contains about 34000 records by... more »
flusing the database
[image]2 Replies | Posted by: pradeepjain | Last post by Atli, Today
hii guys, I am using a table .which i use it for testing for some times .when it goes live i must flush all the data from it so that... more »
Lost connection to MySQL server at 'reading initial communication packet'
[image]5 Replies | Posted by: xoise | Last post by xoise, Today
Warning: mysql_connect() : Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in... more »
Combining two fields
[image]5 Replies | Posted by: lmeeson | Last post by Atli, Yesterday
i want to combine two fields and have used the the following query UPDATE SudentInfo SET image1name = CONCAT(imagepath,UserName,'1'); this works... more »
MySQL: Replacing the first 0 with 44
[image]3 Replies | Posted by: aaronwood66 | Last post by Atli, Yesterday
I have a problem I hope someone can help me with. I have about 2000 records that I need to change permentantly in a MySQL database -mobile numbers... more »
String search in MySQL query
[image]7 Replies | Posted by: srinivembu | Last post by Atli, Yesterday
Hi, I am trying to port my application from SQLite to MySQL database. I believe MySQL by default searches string in case insensitive manner while... more »
Exporting database from a linux server
[image]3 Replies | Posted by: Alien | Last post by coolsti, Yesterday
Hi, I am trying to export a database in my linux server into another server. I did some googling on mysqldump which basically dumps the content of... more »
search engine
[image]1 Reply | Posted by: raaman rai | Last post by snester, Yesterday
hello experts, i wanna know how do we create a search engine for your own database driven website. I wanna search the "ENTIRE MYSQL DATABASE" for any... more »
Sort with GROUP BY, HAVING
[image]1 Reply | Posted by: macaco | Last post by snester, 3 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 »
Importing a database
[image]2 Replies | Posted by: Alien | Last post by tomarvijay80, 3 days ago
I just managed to use mysqldump to dump a database into a text file. Now I uploaded it into my server where i want to import it. I tried looking up... more »
Prepare statement allows only global variables?
[image]Post Reply? | Posted by: getmeidea | Last post by getmeidea, 3 days ago
SET @qry = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; PREPARE stmt2 FROM @s; SET @first_param = 6; SET @sec_param = 8; EXECUTE stmt2 USING... more »
Count of value
[image]1 Reply | Posted by: Nellorekrishna | Last post by Atli, 3 days ago
Hi , Can anybody help in in finding count of value in a column. suppose test is a column and in it value are seperated by comma... more »
Receiving Syntax Error using "OR" command
[image]6 Replies | Posted by: adigga1 | Last post by coolsti, 4 days ago
Hello, I am attempting to call a particular table if the OR statement is used. When I try it gives me a Syntax error. Please assist? Here is the... more »
Date format conversion
[image]3 Replies | Posted by: sam12 | Last post by Atli, 5 days ago
Hi I am having a problem to convert the date format This is my date feild in an existing database 6/26/02 11 05/02/2002 6/05/02... more »
problem with mysqp
[image]3 Replies | Posted by: rejath | Last post by rejath, 5 days ago
i wrote a php page to insert data into mysql database....first it seemed ok and was inserting currectly ..after inserting abt 10 to 12 rows inside... more »
query not using index(es)
[image]3 Replies | Posted by: pedalpete | Last post by coolsti, 7 days ago
I'm running a few mysql queries, and noticed some really slow behavior. I ran the explain, and on the first query, only one index is being used when... more »
Join problem
[image]2 Replies | Posted by: gaz69a | Last post by gaz69a, 8 days ago
Hi, Let’s say that we have three tables: CREATE TABLE t_1 (id_x INT); CREATE TABLE t_2 (id_x INT, value_2 INT); CREATE TABLE t_3 (id_x INT, value_3... more »
How to recover deleted rows in MySQL
[image]1 Reply | Posted by: dbquest | Last post by r035198x, 8 days ago
Hi, Is there a way to recover the deleted rows? We do have a backup but not for all the rows that got deleted. Appreciate some quick help on... more »
LEFT JOIN problem
[image]4 Replies | Posted by: !NoItAll | Last post by r035198x, 9 days ago
Total SQL Newbie here! I have two tables I need to join. There are 34-thousand entries in table 1, 5-thousand entries in table 2. So - there are... more »
Remote Connection To Database
[image]6 Replies | Posted by: chazzy69 | Last post by coolsti, 10 days ago
Not sure if this is where i should be posting this question but here goes anyways; As the title indicates im trying to setup a remote connection to... more »
Can't connect to local MySQL server through socket on Ubuntu.
[image]1 Reply | Posted by: sasimca007 | Last post by Atli, 11 days ago
Hi friends, I installed mysql in ubuntu but, i don't know how to connect to that mysql. Actually we connect to postgresql by psql... more »
Error in Database Restore
[image]1 Reply | Posted by: raaman rai | Last post by coolsti, 11 days ago
Hi experts, i dumped my MySQL database and now when i restore it in another machine i cannot restore two of my tables. It restores upto some point... more »
database backup error
[image]3 Replies | Posted by: raaman rai | Last post by raaman rai, 12 days ago
i am trying to backup my MySQL database using the following command but it generates error. I am using WAMP 2.0 server and is an XP... more »
SQL & GROUP BY
[image]1 Reply | Posted by: hstello | Last post by coolsti, 13 days ago
I have a rather simple SQL statement, but I can't get it to work properly. I have four columns in the activities table "LoginID", "StartDateTime",... more »
Obtaining mySQL account information
[image]1 Reply | Posted by: Alien | Last post by numberwhun, 13 days ago
Hi, I am new to mySQL just now installed Drupal, a CMS that runs on PHP and mySQL on my apache server (XAMPP). While trying to install the Drupal,... more »
1 2 3 4 5 6 . . . 100 Next »

Latest Articles: Read & Comment
Why Values in Unbound Form Controls Don't Persist 10 Tips to Avoid Information Overload at Work How to Freelance to Your First Million, It's been done! 10 Technologies to Help Cut Costs in the Slow Economy Dragging and Dropping Files Into your C#.NET Program
Top MySQL Forum Contributors
ronverdonk (964 posts) Atli (460 posts) pbmods (445 posts) mwasif (392 posts) r035198x (342 posts) code green (200 posts) amitpatel66 (189 posts) coolsti (120 posts) Motoma (101 posts) bartonc (89 posts)
[ http://bytes.com/adLoader.php?parent=database
Quick Browse:
Communities / Archives
XML / CSS | HTML | Javascript | PHP | Perl | Visual Basic | Python | C++ / C | Java | .NET / C# / VB / XML / ASP.net | ASP
PostgreSQL | MS SQL | Oracle | IBM DB2 | MS Access | MySQL

About Bytes | Sitemap | Privacy Policy | Terms of Use
Copyright 1995-2008 Bytes.com. All rights Reserved

You are viewing a mobilized version of this site...
View original page here

Mobilized by Mowser Mowser