MySQL Database Forum

Can anybody tell me how t ocreate Procedure, Function and trigger in MySql if you have tutorial related this topic then send me if possible Thank You

Hi All, I'm running MySQL 5.0.15-nt running over WinXP-Pro/SP2. The following group of commands and responses suggests to me that my installation of MySQL is corrupted. Is there anyway I can get rid of the offending database "depot_test" short of un/reinstalling MySQL? Thanks in Advance, Richard

in my stored procedure i have some if else statements: SET @status = ""; IF (code is invalid... SET @status = "Invalid code."; SELECT @status; END IF;

Hi everyone, I've got a question about how to size the server hardware for a MySQL system that I've got to buy and build. We're going to be putting a database on MySQL that will contain upwards of 20 million rows of data. This data will be used by Java applications running under Tomcat to provide web pages, Java data objects and probably...

hello grp ! while running one application sometime i got these errors Status : Failure - Deadlock found when trying to get lock; try restarting transaction Info : CREATE TEMPORARY TABLE TBL_XXXXX_TEMP AS SELECT ... some stuff

Hi, I've been using MS Access as a front end to our remote MySQL db for a long time. I've just added a facility for clients to select a record to copy along with all its sub-records. The initial record copies accross ok, but I seem to be having a spot of bother getting the sql syntax to work. I keep getting an ODBC error 3146 ?

What is the different between utf8_general_ci and ut8_unicode_ci when specifiying the collation for a mysql database? Thanks. --AK

What is the difference between utf8_general_ci and ut8_unicode_ci when specifiying the collation for a mysql database? Thanks. --AK

I am looking for some software package for students information for school, is there any open-source package available?. This should collect complete student information like: student details, collect student grade/marks info, also staff details. appreciated. GS.

I'd like to introduce myself to the group. I am currently researching the use of MySQL as a database backend for AutoCAD Map 3D. I will hopefully be doing some work with geospatial data in MySQL. I tried a post or two on the MySQL forums, but didn't get much of a response. I'm hoping I'll do better on this group. :] Is there a place to...

Hi, I have a table of a million records and wrote a CGI-PERL script to display the results based on the user input. The results might be anywhere from 100 to 1000 per query and presently I am displaying them as 25 results per page. Problem: Each query is taking about 20-30 seconds. My solution: I have tried to optimize the table and also...

if I want to find a user_id from table 1 which does not exist in the table 2(possible multiple entries for any user_id). the user_id in table 2 is a subset from table 1. if I can not use subquery and minus, how can I do it? thanks.

Hello grp! i'm using INNODB tables which are using frequently . if i fire a SELECT query which fetch major part of table it usually take 10-20 seconds to complete. in mean time if any UPDATE qry comes for a perticular row which is part of SELECT qry i want to know that whether UPDATE will wait for completing SELECT qry or not, or it...

I've been tasked by my boss with configuring a MySQL install that we host for one our partners to support SSL using a commercial certificate. MySQL is installed on Windows 2000 Server. 1st: I know nothing about MySQL. 2nd: What little documentation I was able to find was very cryptic and seems written for LINUX. 3rd: I have found...

Hi, Will the SP's & Triggers writtien in MS SQL work in MySQL ? Or we have to alter. Can some body suggests me if any body has done and how difficult it will be? satya

Hai friends previously I have optimized the query using index that time in my database only 65000 record ,right now in my database 1,50000 recoreds so i need again optimize the query .Now my site loaded very slow . Please give me any suggestion how to optiminze the query agian . Thanks vssp

I was hoping someone will be able to help me, i've got a bit of experience with mysql, but nothing quite like this. I have a table with 3 columns 'sid', 'aid', and 'call'. What i want to do is to create a query that shows me all records where sid matches and aid matches but call differs. For example, it would give me this result:

I have a list like this: Reckless Engineer St Bonaventures The Blue Mountain The Croft The Cube Club The Folk house I'd like to reorder that ignoring the leading "The".

I would like to be able to mail merge records from multiple mysql tables using a simple template, preferably via a command line script. MSWord mail merge via ODBC will not work for me as it only supports a single table. Are there any utilities or simple scripts avaialble that would accomplish this?

I've got a XML file like the example below which I would like to import into a mysql database. I would like to import into multiple tables so each Channel Name gets its own table. How would I go about doing this? I normally use PremiumSoft Navicat for importing xml but I don't think it will sepearate to multiple tables? Thanks in advance...

I'm trying to allow someone from a specific IP to connect to a mySQL db w/OBDC. I've run several GRANT queries on the mysql db i.e. GRANT select,update,insert,delete,create,drop,alter,index on ESdemo.* to 'aname'@'24.55.41.125' identified by 'pwd232123'; GRANT select,update,insert,delete,create,drop,alter,index on ESdemostore.* to...

Hi, I am experiencing the following problem: Once in a while i am seeing a CR_SERVER_LOST error from mysql_stmt_fetch() method. Database server (mysql) seems to work just fine on the other machine. Why?? Is there any work around this? Thanks.

Hello Is there a way to look for all the child tables of a table in MySQL 4.1? I know for the latest version of MySQL you can use information_schema.table_constraints to look the same. Is there something similar there for MySQL 4.1? Right now, I'm running SHOW CREATE TABLE `$table` for all tables, and

Hi, I have a database with two tables a) A table of 2 million records with city, zip and associated information (say XYZ) and b) zipcode latitude, longitude table having >40,000 records/zip codes PROBLEM: I need to find the the XYZs within the the range of a certain zipcode. This zipcode and radial range in miles is entered by the user...

I am designing a website in which users can send messages to one another. Each user will have a mailbox where they can read their incoming and outgoing messages and delete them if necessary. Anyone have suggestions on the optimal way to design the database for such a system?