Hot Solutions

I am writing a C program to run as a cron job on a linux server and do some calculations in the MySql DB.

I have Ubuntu 8.04.3 and MySql 5.5.

I am including <mysql.h>, but when I run the program, I get:
error while loading shared...

Trying to figure out how to build this SQL query:

SELECT * FROM Drives WHERE computerID=448 AND (Letter='D' OR Letter='e' OR letter='f') AND missing !=1 AND Filesystem ='NTFS' ORDER BY Free DESC LIMIT 1;

However would like to test, if there...

I'm trying to cull multiple columns into one joined statement but am quite confused. It's using postgresql. From what I can tell, it has identical query-grammar to any variation of SQL.

This works:

 

But I'd like to add another column...

Hi experts,

Mental block!

I need to list the first name and surnames of all those in an SQL table who have the same surname.  

Any help appreciated.

Thanks

Col

Hey,

I am trying to do this via SQL, to batch change the post_type column in wp_posts:

1. Find all posts that belong to the category Blog (which has an ID of 72)
2. Replace post_type = "post" to "article_type"

Any ideas?

I tried this...

Hi there,

I'm now looking for a new database product that meets my following requirements.

1. Run on Linux
    Since my other applications/databases/scripts are running on Linux, just want to be able to simply reuse those resources.
2....

We have a shared hosting account which hosts a website's files, and a VPS which hosts the database for that website. This setup was working for a while until we decided to upgrade the shared account's version of php to version 5.4.0 (the hosting...

Hi, I'm a relatively newbie to linux and have a Debian 6.0 (Squeeze) VM and wanted to upgrade it from MySQL 5.1 to 5.5, but when I do a:

"apt-get install mysql-server-5.5", I get a:

E: Unable to locate package mysql-server-5.5
E: Couldn't...

Hi. This is my situation.

I have 1000 customers. Each of them have their own customer ID. I want to send a pdf to everyone with 5 questions, and once they submit the form, ideally the data comes straight to my SQL database. I also want to...

Q. How do I insert data into newly created database tables having relational constraints to one another?

I need some help with a query that I can't quite figure out. I am trying to get a DISTINCT list of CODES with a NAME given that the NAME has multiple values.

I don't care what NAME it uses just that it gets one but the CODE should be unique.
...

Hi,

I'm about to finish a new Drupal 7 site and before to 'go live' i wanna reset all statistics (things like: how many reads, how many pageviews, ect...)

Any idea?
Peter

Hi Experts,

I'm writing a software and going to sell it soon. I will provide all PHP files to buyer, but then he can open those files in php editor and edit them easily and I wouldn't like it. My question is: Is there any way to encrypt php...

I have a working iReport where I pass parameters to an SQL statement.  This time I am trying to passing queries involving dates.  I want to query by age so I included a -->> DATEDIFF(YEAR, BIRTHDATE, DATE()) AS AGE <<--  in the SQL statement...

Experts Exchange,

What's the best open source server setup on a Windows 7 and is the most secure?  Based on my initial research, it's WAMP (Windows, Apache, MySQL and PHP).  My company has MS SQL servers set up.  What arguments can I use to...

Recently i upgraded an application from a lower version to a higher version?
now i face the problem that when i try to update the records , it takes more time. previously it was done immediately.

What could be the reason? how can I improve...

Experts -

I'm getting the error when I tried to connect from oracle to mysql via DBLINK.

I guess this is something to do with the User/privileges.

Need some help.

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle...

I have two tables First one "PersonInfo" , Second one "Salaries". I would like to update a field in the second table with value from first table , There is a relation between tables. as shown in attached Pic. when i make update with the following...

Is it possible to select from more than one column in sql.
What i am trying to do is build a search where if I type a first name or a last name in my search form I can retrieve data checking two different columns.  Is that possible.  This code...

How do I start myql? Log file below

ran command  /etc/init.d/mysqld start ( or restart)

MySQL Daemon failed to start.

[root@u153777777 ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]...

Hi Guys,

Which is the best method to handling NULL values.

For example :

1) SELECT ISNULL(PAID_AMOUNT,0.00) AS PAID_AMOUNT from T_PAYMENT

2) SELECT CASE WHEN PAID_AMOUNT ISNULL THEN 0.00 ELSE PAID_AMOUNT  END AS PAID_AMOUNT FROM...

Hi,

Hopefully a simple one here. I need to select a customers from a mySQL database with a birthday within 3 months of today. What is the best way to do this using an existing  date of birth field?

Cheers

I compiled the version of MariaDB a derivative MySQL implementation and when I went to
install a plug-in storage engine I got the error:


MariaDB [(none)]> INSTALL PLUGIN XTRADB  SONAME 'ha_xtradb.so';
ERROR 1127 (HY000): Can't find symbol...

I'm on mysql and need the query to:

I have data in field called "desc" like:

181x1
184x4
1101x2
193x1

What I want to do is select everything before the "x".

If a user tries to submit a post on my website they encounter the error message 'Could not open socket'

The user is requested to enter in a CAPTCHA, I'm not sure if that's related.

My current Query is listed below:

SELECT mstr_meeting.NAME, mstr_meeting.ROOM_NAME, mstr_meeting.start_time, mstr_meeting.DURATION, mstr_meeting.DAY_OF_WEEK, mstr_meeting.MEETING_NOTES,mstr_location.BUILDING_NAME, mstr_location.STREET_ADDRESS,...

i need to insert into table test via mysql in a php document, a built select from various tables in the table production. below is the output - the first element of the array is the sql query, and the second element is the sql error returned.
 ...

I need to show related products on my online store website

I have two tables, one with the product details (main table) and another which takes the product id and adds the related product id (relate table).

So, from the screenshots you can...

Hello Experts...
I have a directory full of CV's and cover letters that carry regular expressions and an ApplicantID
eg:
CoveringLetterforVacancyRef:005_CoveringLetter_4_6663.doc
CV_CV_4_6074.doc
The file extention may also be .docx or .pdf...

Hi,

I have 2 tables: tb_initdata(with 3 colums - ID, Name, Type) and tb_new(with 2 colums - ID, Product). I need a mysql query to update the table tb_initdata(column Name) with data from tb_new(column Product) where the ID columns are equals....

Hi Experts,

I need to develop a simple ad server. I want to show ads one after another and if there are no more rows start from the beginning. Is there a simple way besides creating a counter?

The database:

AD1
AD2
AD3

The result...

This SQL which has been in place for over 8 months when run on MySQL throughthe MySQL ODBC driver under .net is sometimes taking up to 36 seconds to return the result and as a result my .net application is timing out.  I know that is the...

hello experts,
i created a game in php, i want to give each kind of unit in the game some attribute..
for example:
tank is ground unit and he can attack only ground units.
helicopter is air unit and he can attack ground and air units.

so i...

Hello Experts,

I'm looking for an open source / free Helpdesk ticketing system.  
Hopefully something where we have the possibility of checking everything via Web.

Thank you,
Randall

I am trying to pull out some data from a MySQL DB where the values in 2 columns need to be replaced with values from another table during runtime.  
To be more specific, i'm trying to select the schedule for a bunch of teams and then display it...

Hey all i am new at these web service things. I am wanting to use VB.net web service on an outside server housing the mySQL DB. However the data to be placed into the mySQL server is on the inside network that can not be touched by outsiders...

I have some easy question, it seems...

I have the following data in the database....

#2;142022;;;;;;141987;#3;142022;;;;;;141630;#4;142022;;;;;;141629;#5;142022;;;;;;141628;#6;

How could i change it to this one
...

Am running drupal on MAMP (on a Macbook Pro using OSX 10.7.3). It seems to run ok apart from the fact that I keep on getting the error:

Cannot set variable `max_allowed_packet` to `536870912` in your database configuration!
Probably you do...

How can set database collations of my triggers.
A batch command possible?

I have 2 Linux servers: LinuxOld and LinuxNew. I want to backup everything (applications, services, mysql, etc...) on LinuxOld and configure LinuxNew to operate exactly as LinuxOld. Please provide step-by-step instructions on how to do this task....

Hi,

I downloaded the mysql workbench from here:
http://www.mysql.com/downloads/mirror.php?id=406527

But when I run:
[root@seokingdomheaven Temp]# rpm -ivh mysql*
   1:mysql-workbench-gpl    warning: user mysqldev does not exist - using...

Dear Experts,

I have a MySQL database where storing characters in UTF8 format, it works correctly I can enter different language characters through phpMyAdmin interface, also can import .txt files to the database and that appears there without...

I have a simple CFQUERY in a CFC which gets data from a mySQL table.  I'm using getJSON to load the data into my CFML page.  

My first attempt was wholly successful, but I have now added a new column into the mySQL query and after doing this,...

I am trying to use mysql load data infile to load a file, where one line is:

from_unixtime(1317553562), 1, 3

The second and third fields are correct.

The first field is a datetime field and only the value "0" is being entered.

How can...

I need to display results from my database in price ASC.

But they currently go...£1, £1.50, £22, £3 etc when it should be £1, £1.50, £3, £22

Any ideas how to sort this?

Dear Experts,

Can you please have a short look on that attached printscreen from phpMyAdmin, could you advise how the columns can be rearranged? Concretely I would like if the "kategoria" would be after the "szofaj"

thanks,

Hi,

I have a cable called books populated with around 800 books.  I forgot to add a column called price - thus i want to add it now, the only problem i am having is inputting 800 random prices into this new column.

books(book_id,...

I need to convert the following query from Microsoft SQL Server to MYSQL.

It doesn't like the replace in the join.

 

Dear Experts,

Can I ask a short, the below query works fine in mySQL, but could you advise how should be the syntax if I would like to appear not only the words.id, but also the random.randnum column?

SELECT id FROM words LEFT JOIN random...

Hi,

I would like to know how to convert this MySQL Server Query:

 

To a SQL Server Query?

Thank you

Can someone suggest what field is best to use and the best way to handle and store and create currencies fields. But there will be various currencies there (USD, JPY, etc.)

Also, is there some special way to handle GMT times?

Thanks!

Dear Experts,

I am trying to figure out which host to enter to the MySQL Workbench connection screen



if my mysql server is on the Yahoo, showing on the database control panel in options "Server variables and settings" the following...

1. This sql code gives me a list of unique ip addresses

 

2. This sql code inserts an ip address into a table.

 

3. How can I modify this code so that it inserts all of the unique ip addresses from (1) into the ip table?

 

Is it possible to do a MySQL query to average multiple columns then sort in ASC or DESC?

So far I have this to average multiple columns which works but I need to take it one step further and sort in DESC order:

 

I'm using PHP and MySQL.

I have an XML that (somewhat simplified) looks like this:

 

I have a MySQL database with a table named "titles". Titles contains two fields, "id" and "description" (in reality 6 more, but for simplicity only 2).

i want to put the the...

hi,

i have imported my msn history into my mysql database,

now i need a application or fast way to create a reader in java (using netbeans),

i'm new to data grids / database connections and so on,

and don't know where to start at all,...

Dear experts,

I am trying to find a way to add a prefix to all my database tables.
For example I have tables named users, authmap, batch. I would like them to add a prefix to all of them such as drup_users, drup_authmap, drup_batch. Is there...

hello,
i have a pretty simple table.

the parent tc_group record has a parentID of 0. A tc_group can have children and that would be indicated by the parentID

CREATE TABLE `tc_group` (
      `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
...

When I add a '£' sign to my database using a text field on my CMS system the value becomes £6.00 in the database and then appears like that on the live page?

How can I get rid the  character?

I'm trying to figure out why $line['total1'] is empty when echo'd back?

 

My code
 

http://domain.com/prod.php?prod_id=6677'

Error:
 

How to fix my code! Thanks.

I'm getting too many connections coming in and my site hangs. Processlist in mysql shows lots of queries.

So is is safe to just stop mysql now? Will it interrupt any ongoing queries?

For example, should we do summation in PHP or using SQL statement?

Or should we do ordering in PHP or SQL?

Dear Experts,

The attached small code is generating a random number putting them to array, basically after I would like to post them to a MySQL database table named random.

But something is wrong in the syntax probably at the $POST method...

I am using Perl to do the script logic serverside in a web page. I have this query:
INSERT INTO movie_files_table (movie_id) SELECT id FROM movie_info_table WHERE name=".$dbh->quote($movieName).";

One row in movie_info_table can correspond to...

For purposes of installing avionte staffing software, their required software specs include Microsoft SQL Server 2008 R2 (64 bit) Standard. Licenses are ridiculous, so is there any way to implement the software on premise server with PostgreSQL...

Experts,

I need to setup a Wordpress Web farm.  A high availability solution.  I'm having a really hard time finding all the tweaking that goes with this project. Wordpress seems straight forward when it comes to one server and one MySQL.  I...

I have successfully installed the latest xampp on a windows server 2008.
The localhost port is :888
Mysql is running on 3306

When I type in the url: http://localhost:888/xampp I get the correct orange administration screen and I can...

Hi,
If I have a table as below, how would I sort records by `date_created` column where date input is in format DD/MM/YYYY HH:MM ?

Thanks in advance for your feedback.


CREATE TABLE IF NOT EXISTS `blogs` (
  `id` int(11) NOT NULL...

Hello Everyone,
  So I've got a book on database connections, and I'm going through a tutorial to make a connect.php and here's the code I have:

 

Now, when the script runs I'm getting this error, I've tried removing the excess space and...

Hi,

I am using mysql - i want to be able to copy the first parameter from a existing table, the second parameter i want to specify.

eg.

insert into (book_id,title) select book_id from books where where isbn = '12345678911' , 'php for...

For my real estate site I have two databases, one called 'Country' which lists all countries and their codes and another 'properties' which has all of the properties details. The properties table uses the country code from the 'Country' table...

Hello Experts!

I have a dataset that was created by the IDE, selecting tables only, no procedures or anything else.

I Extended the dataset so I could fill tables using different parameters

 

Declaring the tables and adapter I want to...

Hi,
Below is some code generously contributed by one of the fellows on the site. If you were to run it, it generates ( as per my settings below) 2500 unique 5 character strings.
I'm trying to adjust the code below slightly so that I can add the...

Hi folks.

I am really stuck on a good solution for parsing images (jpgs) for their keywords 2#025.
The keywords are comma separated like this:
Hello there, water, wind power, æble, how are you today?, lovely color that is, etc, etc

This...

Hello,

What is the suggested way to enter phone numbers?  I need users to enter phone numbers, but I don't want it to be an open varchar to allow them to enter the phone number any certain way... I want it to be constrained to just enter the...

INSERT INTO barcode( product_code)
SELECT product_code,  amount
FROM product


Mysql statement above not correct I want some thing different such as

if
 select  product_code,  amount
FROM product


ram_a        2
Hdd-16      3
...

Ive tried to alter this a dozen and a half times, I know I'm missing something so simple, just don't know what it is.

Im connecting to the db and grabbing the value in the colum and changing that into a variable

 

But no luck passing it...

I have a PHP file that does some data processing work in the mysql database and I run in from a web browser each weekend.

The PHP file usually completes the job in 4 hours, but past 2 weekends, it failed to complete. Then, i need to reexecute...

Hi,

I'm building a site were users who are logged-in can create user groups.

It will work like this:
A user creates a group by entering a group-name and adding the email addresses of the group members. Then the email addresses are checked....

Hi,
I've an Oracle 10g database and I'd like to migrate Oracle database to MySql database.

Can someone tell me whether I can use some options to migrate the data (dblink, tools,......)?


Thanks in advance!

Dear Experts,

Can you please have a short look I have a .csv file which contains characters which are different from english, these are marked with blue on the below picture



When I try to import this file with Character set of the file:...

HI,

I previously connected to my DB using an ODBC driver but now need to use the mysql.data.dll , its an ADO.NET component.

I connect to tht e DB finem and can update it, I just dont know how to read through the resultsset.

I used to...

I have my database in MySql which resides in a machine in the network. I need to convert this db in MySql to sqlite and generate a .db file using java code.

I have the following credentials of MySql db using which I can connect to it.
...

Using mysql db. I have a column "latlong" which is a point type with a spatial index. I would like to get the closest locations 4 miles closest to the latitude and longitude.

So far I have this...

SELECT `postcode`,county, ( 3959 * acos(...

SELECT MIN(field_name) works fine if the field is an integer field.

However, what if the field is a text field?

If these values are stored in a text field...

100
3
6
9

...the result returned is 9 and not 100.

Dear Experts,

Can you please advise what is the exact meaning of the "Fields escaped by" field on phpMyAdmin screen in the Import section?

Basically I would like to import a .csv file, and so far my experience was that this "Fields escaped...

Errors started last night on SQL Server, and when our server guy rebooted a whole drive disappeared and he had to rebuild the partition. From what I've read these errors mean that there is a an IO subsystem issue, where SQL Server is having...

At the moment I'm using this query to count distinct cities with more than 2 businesses.

SELECT DISTINCT bizCity, COUNT(*) as biz_count FROM finance WHERE bizState='$bizState'  GROUP BY bizCity HAVING biz_count > 2

What I would like to do...

Hello

I was working with the code attached. It is writing to a database but there are two problems.
(1) it seems to want to create a new table and does not write to an existing table.
(2) the current code takes a csv file and writes it to...

Dear Experts,

Could I ask a very general, on web pages there can be seen forms where for example a text field can have even 1000 characters long.

Technically when these data are submitted to a MySQL table, basically this all 1000 characters...

Hi:
My company has a website that connects to SQL server 2008.
The website interface using PHP/MySQL.  It is actually just  a WordPress modified/customized site.

so we have:
"website" <------> SQL server.

Basically,
1  - where is the...

Hello All,

I am moving from MSSQL over to MySQL and I have a simple question, is there a limit to the number of stored procedures you can have in a database?  Basically, I've success in creating the sps, however they do not exist on the list...

Hi. I am using the attached code. I am getting errors (below). The output should be something like this
ID: 0.0, actual: no, predicted: no
ID: 0.0, actual: no, predicted: no
ID: 1.0, actual: yes, predicted: yes
ID: 2.0, actual: yes,...

Hi There,
I have successfully imported some products from a virtuemart shopping cart (version 1.1.4, joomla 1.5) to a new install of joomla 2.5 virtuemart 2.0.2.

I did this using csv improved.

My only issue is I cannot seem to get the...

hello experts, i just want to know what is the best way to preform query with multiple table (2-3)
also, i read alot over the internet about the subject and some say subquery, some say join, so i want to know once and for all, witch case join is...

Dear Experts,

I have a simple table on the attached phpMyAdmin screen, could you please advise which sql command could add an autonumber for it?

So an additional column, which at each new records enter increasing with 1. Like for example in...

hi,
i have a query that is executed PBX that looks up names against numbers from a table so that we have caller ID on the phones.

the current query is: (where [NUMBER] is replaced by the calling number)

 

i need it to look in another...