MySQL Database Forum

Good morning I wish to do the following: 1. return an integer (0 or 1) whether a table exists in the database otherwise I will create the table Problem: instead of returning an integer I am being returned the "table name" if it exists, or a NULL.

Is there an issue with stored procedure and mySQL v5.0.18 ? We are programming an application that need stored procedures and triggers and our programmer can't make them work, is it a know issue or our programmer missed something? Regards, Marty

Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; > $sth=$dbh->prepare($SQL_Text); > $sth->execute(); > while ( ($tt) = $sth->fetchrow_array( ) ) { print $tt; } for reference here is the mysql...

I have a rating system on a forum I'm building. Users can rate a topic either good or bad. For each Good rating, one point is added to the topic's score. For every Bad rating, one point is subtracted to the topic's score. Each time a rating is made, several things are inputted into a MySQL table called ratings rating_id rating_date ...

Hello: I have a problem when i create a database: # mysqladmin -uroot -pclave create basedato mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' #

I know this is a stupid question, but for the life of me I cannot find it in the online docs. If I am running MySQL as a Windows Service, how do I obtain the command line? Thanks, Ike

Hi, I am using fulltext searches and they are working fine. We have set ft_min_word_length to 3. However, some users need to search for two-letter words, and we are not sure if we should change ft_min_word_length to ft_min_word_length=2

Could someone please tell me what the problem is? This is what I'm getting from the logs: 060119 21:04:43 mysqld started 060119 21:04:43 bdb: /opt/mysql: Permission denied 060119 21:04:43 bdb: /opt/mysql/log.0000000001: Permission denied 060119 21:04:43 bdb: PANIC: Permission denied 060119 21:04:43 bdb: PANIC: DB_RUNRECOVERY:...

I've created a web page in .php which receives it's content from a MySQL database, it is all working nicely and looking good except that a field which I have called Ed_Main is now about 65kb and now does not display all the text stored in it. I'm using PHPMyadmin to administer MySQL. MySQL version 4.0 (CGI setup) MySQL installed on local...

I'm creating my first web application in PHP/MySQL, however, when I go to view the database contents, the data has been stored in the wrong columns. I've gone through my insertion code with a fine toothcomb and can see no errors which might cause this. I will post the code below, and you will see that I have some diagnostics built in, which show...

Hi, Does anybody got any issue with the version 5.0.18 of mySQL and using triggers? Is there any troubleshooting for that kind of issue? Thanks, Marty

Hi, I have a table with a primary key defined with the auto_increment option. I've incidentally deleted some rows from this table and I would like to know if it is possible to recover that data. It is still lying around in the mysql files? Many thank for any information.

I have a database with `session` and `age` values for every record. I want to sort all of the records by `session` and then sort that result by `age.` Using ORDER BY `session`,`age` gives a result ordered by `age.` Is there a way to do what I want in a single SQL request? By backup option is to GROUP BY `session` and then walk back...

So.... I want to create another slave and I want to do it as fast as possible. Normally I take a slave offline, record the position, do a dump, import the dump, set the position and start the new slave. ....this takes forever... I recently tried just copying all of the files over, setting the position, and starting it up. This didn't...

I wish I knew what this was called, and I could have made a more sensible subject. For that matter, I knew what it was called, I could have googled it! Anyway, let's I have a table with name, class, grade. joe bio a jill chem b john psych b john chem a jill pysch a

I would like to edit an incoming date field which is mm/dd/yyyy and convert it to yyyy-mm-dd as required by mysql. Any ideas?

I have the following table tableA column_a column_x column_y column_z tableB column_x column_y

Hi everybody, I am unable to install mysql-administrator on Redhat AS 4. #rpm -i mysql-administrator-1.1.6-1.i386.rpm erreur: Dépendances requises: libstdc++.so.6(GLIBCXX_3.4.4) est nécessaire pour mysql-administrator-1.1.6-1.i386 But I already have the library:

Hello Does there exist any debugger for the stored procedures in MySQL 5? If not is there some documentation of how debugging tips in general? Tim

Problem: how to have query show only most recent records. This query shows all exams in 2005 for particular individual (grades not shown to avoid embarrassing John Slacker!): SELECT examhistory.coursekey, students.userid, students.firstname, students.lastname, examhistory.examdate,coursekeylookup.examdescription FROM students,...

Hello, In order to access mysql I must type at the command prompt mysql --user='username' --password='password' How can I change it so that all I have to type is mysql

I've got a very simple query ("SELECT a,b,c FROM mytable WHERE d=foo AND e=bar"; d and e are part of the primary key) that I'm executing tens of thousands of times in a particular application. The primary key is too big to fit in the key cache (it's about 64G, the table is really huge). I've noticed when I do a SHOW PROCESSLIST that the query...

i suck so much that i don't even know if this is a JOIN or a subquery or who-knows what. Here's the idea: I want to select two things at the same time (form one table) average for columnX and average for columnX where columnY=Z so i started of course with select avg(columnX) as avg1, avg(columnX) as avg2 from table where columnY=Z

i researched for a while on the net and found that more people have this problem, but could not get an answer. i am very new to MySql. linux - feudora i log into mysql using "root" when i am in mysql, and i type any comand, like show databases, i get

Dear all, I want to perform a simple search for a query such as: SELECT * FROM SOME_TABLE WHERE SOME_TABLE.SOME_COLUMN LIKE '%SOME_KEYWORD%' The same statement if implemented in a stored procedure would look similar like this: