MySQL Database Forum

Hey Gang, Playing around with stored procedures in version 5 (I am giggling like a child, I am so excited about it). Anyway, anyone know if there is a way, yet, to describe the procedure once it is already created in the db? I see in the sp.test the create,call,drop. Can we "desc" or "show"? Thanks,

Hai un nuovo messaggio da Morena227. Per ascolto chiama da fisso lo 89-9030-521. Il messaggio rimarrà nel sistema per 15 giorni, poi si provvederà all'eliminazione. Lo Staff non è responsabile del contenuto dei messaggi. Non rispondere all'e-mail (sistema automatico). In caso di errore di invio, o Lei non è il diretto destinatario della e-mail...

Is there a limit to the number of tables allowed in MySQL? Is there any non-obvious performance hit associated with having too many tables? Assume the data size will be the same. In other words, having a table that is 1.5Gig versus having 1000 tables that are each 1.5MB in size. Lukas

Hi there, I'm currently trying to implement a website that will store and retrieve Polish, so I need to be able to handle Polish characters using classic ASP with MySql5. Does anybody have an experience of doing this as I'm banging my head against a brick wall getting this to work using either utf8 or latin2. I can't believe I'm the...

Hi all, So I've been thrown into developer hell, with the assignment "Here's $formerprogrammers's project, it doesn't work, fix it, oh yeah, and there's a tight deadline" It seems like $formerprogrammer knew just enough about php/mysql to write a working product on a REALLY bad design. Not surprisingly our company/client decided to jump...

Hi, I'm trying to build a simple search for a database of jobs. Users can search using three groups of critera: 1) Area (check boxes) Buying and merchandising Design Executive

Hi, I have noticed with MySQL Administrator when I backup stored procs they never restore properley.

Sorry for cross posting, just realised myodbc wasn't the place for this: Hello, I'm having a problem with records inserted using NOW() as data in a field having that timestamp updated when I alter another field. I am using MySQL version 5.0.20-nt. To replicate: use test;

Hi all, I have a problem with the issue in the subject, i have all data in one big excel file, in a denormalized form, and on the other side, i have mysql database with many tables, which is already in production, and it is of course in the 3rd NF. How do i go about importing that excel file , is there any good tool i could use to handle...

I am trying to convert a declare syntax from SQL to MySQL the syntax is as follows: declare @x int; set @x = (SELECT max(ixBugEvent) FROM bugevent); UPDATE bugevent SET ixAttachment = (SELECT max(ixAttachment) FROM attachment), ixBug = (SELECT max(ixBug) FROM bug)

I just want to assign a variable from a query that returns a single value result. The problem is that the following will also emit (print) the result to the terminal as a side effect. SELECT @SomeVar := SomeFieldCalculation FROM ... WHERE ... Is there not a simple way to accomplish this silently. IOW - get SELECT to

Hello there, We got a problem atm with our 20k database. Everytime we search for sth. with double quotes it takes much more longer than without. Here is what we did: mysql> SELECT COUNT(*) FROM `Pages` WHERE MATCH (`Text`) AGAINST ('"term"' IN BOOLEAN MODE); +----------+ | COUNT(*) | +----------+

Hi All, How can I return a row when the condition is not met for example simplified SELECT Name,SUM(Cost) AS T FROM DB WHERE Name="+Name +" GROUP BY Name this works fine but I ned it to return Name and Zero Cost if Name does not exist

Hi! I am working with mysql server 5.0 an I have an Index in a database table, but I need to index the word 'once'. My index it's not indexing it because once is a number... How can I configure Mysql or the index to index this word? My index is Fulltext type.

I have MySql server version: 5.0.22-community-nt. When I try to import data with this command mysql --default-character-set=utf8 mimi < c:\django\mujserver\mimi.sql I will get the error ERROR 2006 (HY000) at line 230: MySQL server has gone away

i have the following table in my application CREATE TABLE `documentList` ( `id` INT UNSIGNED NOT NULL auto_increment, `document` varchar(255) NOT NULL, `archiveDate` date, `contentType` varchar(30), `resultCode` varchar(30), `size` MEDIUMINT UNSIGNED , `title` varchar(200) ,

I'm running MySQL 5.0.19 (windows), and running mostly well, but in some cases seems too slow. I've been optimizing SQL as much as possible, indexing important fields, using OPTIMIZE TABLE to clear out deleted records, etc. I would also like to adjust the my.ini settings to make sure things are set there to be as optimal as possible. My...

How do I set one field to have the updated timestamp, and another to have the created timestamp? I want to do this directly from code generated from DB Designer if possible?! JJ

So I have a table that has, among other things, these feilds: id PRIMARY KEY name VARCHAR(50) prerequisite INT NOT NULL Prerequisite contains a reference to the id of whatever item comes before it. How can I generate a query on this that will put them in sequence?

Hi, We're using a mySQL database as a replica of another (Sybase) DB for reporting purposes. The Sybase is part of a real-time mission critical system - hence the separate database where people can run their queries on. Currently a separate application is copying the information we're interested in from Sybase to mySQL in an overnight...

Dear Sir, Let i have a large Text file. the fromat is : SL. Name Code address phone 01. dhihjb 50126 bjjkgh 634 02. vjhvjd 5646 sdfsd 46546 03. 45454 dfcsdf dsfsdf dsfgsf Now i want to insert data separetely into individual field of database.

I previously posted this on mysql.users, but I am guessing that that was in inappropriate forum, as I did not receive any responses. Does anyone know of a set of standards for securing MYsql 5.0 on Windows 2000? I already saw the document on mysql.com's website at http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html,...

I have forgotten a lot about SQL and would like to be (gently) reminded how to do this: In a MySQL query on the database (one table with 15 variable length fields, I want to put each field into a Bash variable so that I can handle each field as an entity. The query I have is something like this: mysql -e "use $database; select field1,...

Hello I compiled mysql++ with Visual Studio 2003, the problem is I got i memory leak when i debug the application, the leak occurs even when i only use the mysqlpp::Connection class. Note I linked mysqlpp with mysql 5.0 Thanks

I'm just starting to use MySQL again and have found MySQL++. Are MySQL++ questions on topic here? I couldn't find a MySQL++ newsgroup.