I am currently working on a medium size project, i used to work with MySQL server but my client wants me to use MySQL. I am concerned about its performance and how it will affect the speed of every process. I need assistance especially from those who have used MYSQL, thanks

After I activate a password protection on MySQL form PHPmy Admin, how can I view that on my site? The help doesn't give sufficient explanation how to run that. I'm on Ubuntu with LAMP server.

While creating a table for emails in mysql database it shows the following error: "#1064 – You have an error in your SQL syntax"

the following code I tried:

'
'
—
— Table structure for table `coming_soon_emails`
—

CREATE TABLE `coming_soon_emails` (
  `email` varchar(64) collate utf8_unicode_ci NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

How can I create a password for my localhost? I can not find the exact way to do that.

Hello

I have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" table so i cannot use primary key_foreign_key reference.

Could anyone help me what should I use?

Thanks

I have made a database that consists of product codes with their corresponding prices. I encoded the product codes and then tried to update the database but when running the MDF file, it is still showing the updated product codes. Does anyone knows how to avoid this permanently?

Hi guys, 

Can anyone please explain me what is Database normalization and why it's important.

Need answers quickly.

I am building a database ( in ASCII text format) which I want to put online and want to: 

1) Allow others to query it.

2) Allow others to submit entries

(with administration  approval first if possible).

Hi, today morning when I try to reach the server it says MySQL cluster fail. Then it opens up but shows no records. Please help. I'm in great need.

Hi guys ,

I need your help to select the most appropriate data type in mysql to store a large body of textual information