I'm try to install MySQL Workbench from the rpm on the MySQL web site and it fails:
error: Failed dependencies:
libcrypto.so.7 is needed by mysql-workbench-oss-5.1.7-1fc9.i386
...
This is probably pretty simple to do. But, I need a mysql command to copy/update one empty column with another column's data in the same row for multiple rows in a table.
I need column1's ...
Hi to all,
I need to know the value of an autoincrement field that mySQL will assign previous to insert the record in the database.
Is it possible?, how?.
A little bit urgent...thanks!!
Dear Experts,
I have a SQL select statement that outputs data as follows.
----------------------------
ID Attribute Value
----------------------------
10 username user...
Is there a my SQL equivalant to SCOPE_IDENTITY()
in MS SQL
cheers
steve
How can I spool the result from the mysql command to a txt file in my local drive.
OS=Linux
regards...
Mario
I have mysql-3.23.58-16 installed as an rpm on a RHES v3 system, and have been working with mysql databases via wordpress. It is now time to upgrade wordpress and back up the old databases, a...
MySQL Error - 1213 Deadlock found when trying to get lock; try restarting transaction
DELETE FROM upsl WHERE ipaddress = '100.x.x.x'
I saw this error this morning, I have no idea what it ...
I have an application that was converted from SQL Server. In that application we had code that handlled query timeouts. I have searched the PHP manuals, MySQL manual, as well as google and can...
Hi,
I have three select boxes which I implode to create one variable called $tcomp. This is saved into my db table. What I want to do is compare the variable date ($tcomp) held in the dat...
I need to limit the number of records that are returned from a stored procedure and need to keep the starting point and limit count dynamic.
So here would be an example of a stored procedur...
In the mysql administrator, under the health section, under the 'memory health' tab I see that the hit rate in my 'key efficiency' spends alot of time at 100% (on the same page, key buffer usa...
I have an image upload form that works.
Now I would like to add code to that form to transfer the path to the uploaded image into a MySQL text field.
Here is the page that holds the form...
Currently, the mysql database version 4.3 that my company using is getting error as below
Host 'service.XXXXXXX.com' is blocked because of many connection errors.
Unblock with 'mysql...
I have got a live databse on one server which i administer via phpMyAdmin. I dont want to experiment with it too much so i want to make a copy and transfer onto another server. Does anyone kno...
I am having a problem with some legacy code that won't work properly due to a mysql error
This code is used once a month to upload sales data on my dedicated server. Last month it worked fi...
I have done some MySQL work previously however this has got me stumped. I have these tables (part of a bigger schema):
Question
QuestionID (PK)
QuestionType
QuestionText
Surv...
I need to update a table column in oracle 10g db. Here's the senario
Table 1 Table 2 Table 3
column1 colu...
Hi All,
We had a phpBB running on FreeBSD using MySQL (I don't know the version) and we had the hard drive crash and had to send the drive out to be repaired sector by sector. The director...
I get this error every now and then:
mySQL error: Out of resources when opening file 'C:\WINNT\TEMP\#sql_318_0.MYI' (Errcode: 24)
mySQL error code: 23
After restarting the server everything...
I would like to change the contents of an enum field in my mysql table.
FROM:
field1 enum('aaa','ccc','eee') default 'aaa'
TO:
field1 enum('aaa','bbb','ccc','eee') default 'aaa'
The...
Hi, I'm trying to sort the records in a table by using an 'up' and 'down' buttons (images).
Basically it should swap the position of the two records in the database:
example records A B C ...
Hi,
Please kindly assist how can we prevent resulting to null?
we have two columns, firstname and last name
select concat(firstname,' ',lastname) as name
from table1
if one of the...
Hello,
How do I insert a record into a column, if that record does not already exist.
If it does exist, then do nothing:
----------------------------------------------------------------...
hello. i have a form that posts results to a processing page and i need to insert an array into mysql from this page. however, i am having trouble with an array. code below.
th idea is say ...
