Top Solutions

what is normalization .explain ti with an example also explain 1nf,2nf,3nf,4nf and bcnf and aplly it onto a sample table as an example

Hello,

in MS SQL there is a command that I can issue where when used as the default value for
the fields (DateTime datatype) will generate date & time value when a new row is inserted.

CREATE TABLE [TBL_TABLE](
 [fldDATE] [datetime] NULL...

SETUP:
WindowXP Home Edition
Almost fresh installation, only softwares installed are: IIS, Apache, Tomcat, J2SE, Perl, PHP, and two firewalls.


GOAL:
I installed before MySQL on window 2000 professional and it worked fine with PHP. This...

This coldfusion/MySQL query is driving me crazy. It just won't return the month of september's values from 2007. The column 'trading_data_values.TDVdate' contains several entries for sept with the date in the form '2007-09-20'.

<cfquery...

In MySQL, how do I do an insert based upon whether or not a row already exists in a table? The SQL below doesn't seem to work, so I'm looking for another way to accomplish this. Below is all of the code that I have so far (I'm in the process of...

I found solution for my case sensitivity problem:
i need to set
lower_case_table_names=1
so MYSQL on my remote server(linux) is not case senisitive.

But how to actually change this value?

Is there any possible way to import this list to a table with name
portlist
columns :
Name
Port
Description

for example i will import this both port :
msp (historic)   18/tcp    Message Send Protocol
msp (historic)   18/udp    Message...

I am going out of my mind.... I have installed and uninstalled MySQL about 8 times now due to problems I've been having and I STILL cannot uninstall it completely. Every time I reinstall, and then open mysqladmin.exe it STILL shows my old user...

I have a javascript function
function copyToClipboard(text) {
        if (window.clipboardData) window.clipboardData.setData("Text", text);
        else if (window.netscape) {
                    user_pref("signed.applets.codebase_principal_support",...

Dear Experts,

I run an ecommerce website and I'm doing load testing on the site to see what load it can handle. When I run the case 1000 users in 1 hour, the site breaks down and I start getting the error messages below in the log files.
...

Hello experts

im constantly uploading with phpmyadmin, some not so large sql statements (4 - 9 Mb) to a site running phpmyadmin php apache on linux.  also to a site running php myadmin php apache on windows xp.

in both im getting the...

Hi
I have a small contacts database(Microsoft Office Access 2007) which is connected to my form using a Adodc control, I also have a mysql statement to find a specific record. I would now like to add the following controls

ADD
DELETE
EDIT...

Have a problem with MySql and Entity Framework 4.1 code first.
I create following dbContext:
 
The model:
 
In web.config I added:
 

Table is already created, and I cant get the date from it.
 
On the second line i get an exception:
 ...

Hi,

Please kindly assist how can we remotly login to mysql ?

running on fedora core 3 (fresh install) everything is default.

how can we change the root (mysql) password? are there commands we need to run to get mysql setup and ready to...

I am a total newbie to MySQL. I'm in a position where I need to grasp MySQL and FAST!!!!

I have been really struggling. I was first getting the Error 2003 but after following the advice in one of the Experts Exchange forums it...

I'm trying to output JSON format from a MS SQL procedure. The SP attached works fine as long as the @XMLString does not exceed  VARCHAR(MAX)), but gives an error if this is exceeded. How can I modify the attached to work with a larger number of...

I'm just doing a simple searching type script and can't seem to find the answer to this anywhere.  In MSSQL, I can run the following:

SELECT field_name
FROM table_name
WHERE CONTAINS(field_name,  ' this AND that ')

which will return all...

I've got a problem. I have a SharePoint_Config_log.LDF file that is over 6BG located on C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data. I've followed the suggestions in related posts about shrinking this. The problem is that the...

If i change the code be low mysql_query("SET CHARACTER_SET_RESULTS=utf8") to
mysql_query("SET CHARACTER_SET_RESULTS=tis620")  what will happen when i update  form php code



if (EW_USE_MYSQLI) {
$conn = mysqli_connect($HOST, $USER, $PASS,...

I'm using this code to select people (EXEC) from a database which works fine. But I get php warnings in error_log:

PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource
PHP Warning:  mysql_num_rows():...

I'm getting a '500 - View not found [name, type, prefix]: frontpage,html,contentView' error after trying to upload a Joomla 1.5 site from my local PC to host VPS.

www.arcalinea.com

I'm able to access the uploaded site's backend fine but...

Hello experts, hope you can help me with this problem:

I'm trying to use the create function statement inside a delphi program using Zeos DBO to connect to a MySQL 5.0.41 server. here's the function i'm creating:

DELIMITER |

CREATE...

After installing PhpMyAdmin on Win7, 64-bit machine with Apache 2.2, PHP 5.2, MySQL 5.1, then entering http://alan-pc/phpmyadmin/index.php, I receive the following message:

phpMyAdmin - Error

The mysql extension is missing. Please check...

opkg install mysql-server
mysql_install_db --defaults-file=/opt/etc/my.cnf --force
 returns :
 

fill_help_tables.sql is located at /mnt/opt/usr/share/mysql

my.conf is a direct copy of my-small.conf example from mysql.

Any ideas?
I do...

I have a mysql database file I need to edit. It's for a Zen Cart database. The original file, before I altered it, is listed as the First Code in the included code block.

I ran am additional  query though my Zen Cart SQL Query Executor (code...

I have a win 2003 server which has the subject file located in the windows/temp folder.  It keep growing in size and will not permit deletion saying it is in use.

Any chance it is used by Symantec EndPoint Protection?  I checked with Symantec...

I need to import over 200 bug reports into our new Mantis 1.17 deployment. I have carefully read through http://www.mantisbt.org/bugs/view.php?id=4220, and it looks like the right solution for what we currently have. I've downloaded...

Hi there,
I am running out of space on my C dive.
I have Visual Studio 2005 running on my Server, so i have tried to run the MSIZAP.exe command to delete the orphaned files so that this might give me some space.
This usually works.
...

Hi,

I have this table: tbl_1

Type     Value
x              1
x              2
y              1
z              0
x              3
y              1

I'd like to get the average of Value when Type = x in one sql query.

I tried this:...

My FreePBX installation (CentOS, Asterisk, FreePBX 1.4.29.1, FreePBX 2.6.0.1, MySQL 5.0.77, all on the same server) is not recording CDR data into the database, nor to CSV files.
I can access the database by logging in to mysql as freepbx, or...

Creating my first MYSQL database under EasyPHP

Please, notice that I will post several questions and the first question is my first database under EasyPHP, and then I will post a series of questions as follows:


With a great help from...

I have a computer that can browse all websites but not search engine sites. I've ran virus/spyware scans with combofix, malware bytes, spybot etc. I have reset IE settings, tested in Firefox with the same result.
When I ping www.google.com its...

Hi,

Can anyone please tell me the equivalent syntax in MySql for the following?
 
*** isnull(col_name,' ') *** (Microsoft SQL Server)

Since the query,
*** select isnull(col_name,' '), id  from table_name order by id *** gives the...

Hi,

I'm using Roshan Bhattarai's "Populate triple drop down list from database using Ajax and PHP" (found here: http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html).

The...

OK, I was able to transpose all distinct values of a column into separate columns, thanks to KendallTech and Wolfen351, now all I want to do is the complete opposite.

I have a character string with elements separated by a semicolumn (;).  I...

Hi,
I am new to Mysql,

1) Can I install MySQL Workbench (GUI Tool)  on Win 7 64 bit?
It seems to show only 32 bit options?
http://dev.mysql.com/downloads/workbench/5.2.html

2) I have installed tbe MySQL Cluster on the Win 7  64 bit and I...

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 D - When you click the 'up' button for C the records...

I have the following query:

SELECT
ID,
Date,
[ProuctID(New)],
(CASE WHEN CONTAINS( [ProuctID(New)], '1') THEN 'yes' ELSE NULL END) AS [Product]
FROM
dbo.Data

I need this to return data (for exmaple) like:

ID, Date, ProductID(New),...

Hello,

I installed apache, mysql and php on my Windows XP pro box for developmental purposes. I can start Apache and view the page at http://localhost:81. I selected 81 to prevent conflicts in IIS but I may be wrong about that....

Anyway,...

I am trying to get VISIO to export a database model, but I can't get it to export the correct things.

I made the connection through the DSN just fine. When I use the export to database wizard or function, it keeps exporting useless data such...

I am trying to import a .csv table into MySQL via PHPMyAdmin.  At first, it was timing out whenever I tried to import.  Based on various forumn posts, I increased the following to 10000M in order to get the Import function to work: ...

Suppose I have a table called Products with the following fields

ProductID (VARCHAR(20))
Cost (DOUBLE)

and a table called ProductComponents with the following fields

ComponentID (VARCHAR(20))
ProductID (VARCHAR(20))
Cost (DOUBLE)
...

I'm not sure if I need to reindex MySQL, but it seems to be corrupted and is acting strange.

I saw this on another answer posted, but I don't know what to do after I do a
mysql -u username -p  and I don't know the name of the database or the...

I recently installed the MySQL connector version 5.2.3 into Visual Studio 2008.  Now when I load VS and attempt to use the server explorer to connect to a database I get

An unexpected error occurred in the .NET Framework Data Provdier for...

I'm attempting to set-up a slave/master replication process for the first time.

I have followed this procedure...

1.  On Master - GRANT REPLICATION SLAVE ON *.* TO username@slavehost IDENTIFIED BY 'password';

2.  Installed the same...

I have two tables. One has a bunch of listings.. One has a bunch of votes.. or views or whatever based on Table A.
So Table A has a bunch of listings with Unique ID Numbers.
Table B has information about who voted on table A.
So there can be 4...

http://192.168.0.88/testserver88/comset0dele.php?select2=91?select3=034004

my code is below i want the value of 034004  but I don no how to do that be cause when i echo it give me

91?select3=034004

I have XAMPP installed and wanted to install a MySQL client, I was surprised to find it is not part of XAMPP.

Accidentally I also installed mysql-server, so the command I used was
sudo apt-get install mysql-client mysql-server
I really...

I am new to this SQL stuff. can any one spot why I am getting the following error?



Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax...

I have and Excel/CSV file and I need to import this into MYSQL.

I use asp.net (VB) version 2.0, I also have MySQL Administrator version 1.2.12

I DO NOT have access to the MySql database file directory it is on a hosted environment and I...

I can't seem to get select into outfile to work. Take a look of what I've tried:

# cd /
# mkdir test
# chmod 777 test
# chown mysql:mysql test
mysql> select * into outfile '/test/data' from table1;
ERROR 1 (HY000): Can't create/write to...

Hello, I am running RH 5. I am new to MySQL so please bare with me. I have installed version 5.0.51. after going through the setup config documentation, i cannot get MySQL to start automatically. When the server boots up and tries to start...

I am to attempting to recover data from a schema that had both MyISAM and InnoDB tables.  I can recover the MyISAM tables without any problem, however I am running into difficulty trying to get the InnoDB tables back.  

Steps taken:
I have...

How to export the database schema from TOAD? I have to take the schema from one database and needs to be excecuted in to another database

Hello,

I have given an application with a file xy.db (size: 200 MByte).
I want to convert it into MDB or CVS.

with a binary editor ("WinHex"), I see inside the file xy.db:
--------------------------------------------------
almost at the...

Hello,

I am using this script to connect to a database that I will be using for WordPress:

<?php
$link = mysql_connect('myServer.safesecureweb.com', 'My.WordPress', 'MyPassword');
if (!$link) {
    die('Could not connect: ' ....

I have a very simple backend to a news section of a website. It is written in PHP in Dreamweaver using a MySQL database. It allows the user to add, amend and remove news items. The current function of the add form is adding a title (news_title),...

I've installed WAMP Server 2.0 onto my Windows XP SP2 system and I'm trying to import a mySQL database that was downloaded from the online server using Cpanel's database backup utility.  The file is saved as: mydb.sql.gz

On the local machine...

We are running a database application on windows 2003 R2 server using mysql. When we run queries the mysqld-nt.exe service runs at 100% of CPU usage. This slowdown entire application or freeze the application. We are not sure why this happening....

Hello Experts,

I am placing configuration items for an application in an mysql db table.  I plan on running a script that executes a select statement and outputs to a text file in the appropriate directory in the filesystem.  Works like a...

I am trying to set up and database to use the type ENUM and have '0,'1' and it keeps getting me an error when i try to save...any thoughs to why

Error

There seems to be an error in your SQL query. The MySQL server error output below, if...

Hello I am trying to connect to a remote MySql data base using the following.

Public Sub ConWebSQL()
    Set WebSQLEx = New ADODB.Connection
    WebSQLEx.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & "Server" & ";DATABASE=" &...

I have been working on an installer that does several things. The part I'm having trouble with is getting some .sql files to set up the database, user, permission, and initial table structure for the application.

For reference, I am using...

I have used example from ODBC in online help (see attached code).  After executing RegionID 100, it immediately adds record into DB.  When executing RegionID 101, it failed due to "duplicate record in database" and immediately goes to exception...

Hello all,

Yesterday, I installed WAMPserver on my laptop which comes with phpMyAdmin.
When I open up phpMyAdmin, I see this note at the bottom in red
"Your configuration file contains settings (root with no password) that correspond to the...

I'm having a hard time configureing a web site that I've had running for a couple of years now.

I recently added SQL Express 2008 to the server so I can use the ASP.Net 2.0 login controls, so I had to change from Windows Authentication to...

here is my INSERT Statement:

("INSERT INTO STUDENT (FNAME,LNAME,EMAILADDRESS,DATE) VALUES ('LName','FName','email@server.com','{0}')",DateTime.Now.ToShortDateString());      

using ODBC, this operation add a new record but the DateTime field is...

Hi -

I would like to be able to use php to generate a batch of qr codes with data from a table in my mysql database and format them on a page that can be saved and printed later -

I have successfully used Ray Paseur's qr code generation...

Hello,

I am using OpenKM version 5.1.8 with JBoss 4.2.3. I want to change its DB to MySql. Can any one help me in this issue??

I have MySQL installed on a windows 2003 server.  I have not used MySQL before, and do not know how to turn on logging to a file.  If I remote in the the server it is installed on, and launch the MySQL Administrator, I do see a section for server...

Hi - I'm not that bad at webbie stuff but am having a terrible time just copying a live Wordpress website to a local Apache server.
I installed XAMPPLITE and can't get Apache to stay running - seemed to be problems with other programs using Port...

Hello,
I have been running a MySQL file on a web server,
when the execution arrives to the functions, i am getting some problem,

Here a code snippet of a function :

DROP FUNCTION IF EXISTS `function1`;
DELIMITER ;;
CREATE  FUNCTION...

I have managed to get some code to create some vertical scrolling data from my mysql database. I want the ticker to scroll vertically and show jobs that have been posted by users. The code needs changing as I cant seem to return more than one...

Below is (as simple as I could from a massive data import) a table and one insertion of a record.  The problem is that the value going into value1 of 16.7 is getting converted to 9.9

Now, looking at the FLOAT definition, I think the conversion...

I no longer am able to connect to my mysqld server instance using the mysql command line interface. All mysql connection attempts generate an "ERROR 1130 (HY000) Host 'localhost' is not allowed to connect to this MySQL server" message. I am...

I am new to doing development in PHP.  I am a long time Delphi developer and got a copy of RADPHP XE.  I am trying to write a simple, SOAP based, web service that will pass records from a Linux box to a Delphi application.  I have done several of...

Dear experts:


In MS Access 2007, I noticed "Long Integer" data property.

Is that available in SQL too?

Thanks!

I have installed mysql just now ,but i dont know how to change the root password .

as i type in './mysql_secure_installation' ,it shows:

Enter current password for root (enter for none):

and I type some word or none and enter , it shows:...

I am trying to make an ODBC connection from Windows 2000 to my Linux Server which has MySQL server installed and running. I am able to ping the Linux connection no problem.   In the ODBC administrator I specify the correct server of my Linux...

I am following this article : http://www.howtoforge.com/mysql_master_master_replication

have setup Master (SErver 1) and Masetr ( SErver 2)
now i am in step -5
Salve is saying :

 Last_SQL_Errno: 1062
               Last_SQL_Error: Error...

I have a table called Product with the following fields

product_id, name, description, company, country

where product_id is an automatically generated ID. I have a stored proc to insert new data into this table (see attached code snippet). ...

i am building a website. The purpose of this site is to manipulate reecords stored in a database, so simply adding, editing & deleting records of customers. supposed to be used by the staff. i am using WAMP server and creating the web site using...

I have Appserv installed on my computer. InnoDB is disabled in MySQL. How can I enable it? I tried editing  the my.ini file and commented out

skip-innodb

but I don't see it enabled in phpMyAdmin.

Is there something else that  I am missing?

Dear Sir/Madam:

I am having rhel5 server working as a mail server now the requirement is to configure the mail server for the virtual users and domains hence postfix is compiled for the mysql  feature and downloaded the postfixadmin and run...

Hi all,

I've recently been appointed systems admin for my company and although we have been managing and maintaining our servers for the past number of years we have no real official documentation (SOPs, DRP, maintenance logs etc.) I recently...

Hi, Can anyone suggest the next step please, tried everything I usually do to get Apachi, PHP and MySQL working but this time is harder.

Downloaded libmysql.dll and pasted that in system32 folder, php5 directory and in ext folder. All in the...

Hello,

I got a bunch of questions on mysql, and answered all of them but one. I know asking to solve homework is against this forums rules, so I only ask for a VERY SMALL hint.

And here is the question:

Use the following schema tables:...

Hello

I don't have much experience in mysql but i was wondering what would be the easiest way to move our current mysql database to another server. In MS-SQL Server there is a feature to attach/detach a database so i was looking at something...

I have a TimeClock table that includes these two fields.

TrxDate     2007-11-02 00:00:00
ClockOut   1899-12-30 14:45:00

I want to take the DatePart of the the TrxDate field and replace the ClockOut DatePart with it so that I end up with...

The progrgammer of the database has created a trigger that I need to edit because it is incorrect. The ACTION STATEMENT is thus:
INSERT INTO audit_tbl_Containers (
                                             
                ...

Hello!

Got a problem with exporting my db's in phpmyadmin.
When i select the export option i get the following error

Fatal error: Call to undefined function __() in C:\xampp\phpMyAdmin\libraries\export\json.php on line 26

here is the...

this is a continuous question from here :
http://www.experts-exchange.com/Database/MySQL/Q_24923070.html?cid=1575#a25887117
and i am following this article
http://www.howtoforge.com/mysql_master_master_replication
i have done till step 6...

Does anyone know where I could find a dropdown list for country,state/province and city?

Something similar to http://www.geodatasource.com/world-major-cities.html but not as expensive, I don't mind paying up to $100.

Thanks in advance for...

I am trying to replicate data from a master server to a slave. I have two servers running Windows 2003 with MySQL 5.0.

Master Server: test2k3-2
Slave Server  : test2k3-1

When trying to LOAD DATA FROM MASTER, I get this error:

ERROR 1218...

I ran a mysql -V in Linux to see what version of mysql is on my server.

What version is this:

"mysql  Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.0 (i386) using  5.0"

I am very confused as it saysin Using 5.0 at the end.

Thanks
...

I recently upgraded to Joomla 2.5 and everything worked ok on the old server.

Since moving to a new server, the gallery page won't load the sigplus thumbnails, nor will they load in the lightbox popup.
...

Greetings,

I recently installed Apache 1.3.31, PHP 5 & Mysql 5.0.0 On a Windows XP Pro Box SP 2.
1) Apache was installed in C:\apache.
2) Php was in zipped and i extracted it to c:\php500
3) Mysql i installed using the installer.

Now...

Is there some kind of workaround that would make it possible to achieve the equivalent of Oracle's DECODE function in a MySQL query? Or could it be done through some convoluted PHP code?

I'm trying to return all rows from a table 'members',...