Question about Sun MySQL

1 Answer

Mysql change colum

How can i change a column size from VARCHAR(10) to VARCHAR(50)?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 6 Answers

Hi

To change the coulmn size, refer the below query:

alter table [table name] modify [column name] VARCHAR(3);

Posted on Sep 23, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Mysql> desc contact_info -> ; --------------


Hi David,

It looks like you're missing two more null's in the third record, the column count is only 21 and you have 23 fields in your destination table.

All your data matches up to the columns, but you'll need to insert ", null, null" before the last paren to cover CompanyURL and companyPhone):

('Karson', 'B', 'Campbell', null, 'Dr.', 'Chief Resident', 'Pediatrics', 'kbc232@mvch.org', null, null, '585-544-1212', 'home', '1955-01-05', 'Wife: Molly Kids: Cassidy, Justine, and Cory.', 'Mountain View Hospital', null, null, null, null, null, null, null, null, null, null )

Sep 06, 2013 | Sun MySQL

1 Answer

Need to make my table display in rows instead of column.


David, what you're looking for is pivot table functionality. Unfortunately, that is not a built-in feature for MySQL (it is for SQL Server 2005/2008).
Not knowing your table structure, or the size/number of rows/columns, I found the following link to be most helpful example: MySQL Pivot Table Example

Sep 04, 2013 | Sun MySQL

1 Answer

How to lock cell, column or row?


Lock (Colume / Row)
  1. Select colume or row that you want to lock (by default . it is locked)
  2. Right click and select menu 'Format cell'
  3. Click tab "Protection" and then check on "Lock" option.
  4. Click ok and close this dialog.
  5. Go to ribbon 'Review' and select "Protect sheet"
  6. Typing you password
  7. Saving and close your workbook and reopen again.

Nov 19, 2008 | Microsoft Computers & Internet

2 Answers

MYSQL Access denied


Hi Buddy,

Try this option....

mysql -u root -p

mysql will then ask you for the password give the proper password.

For changing mysql root password

mysqladmin -u root -p password <<newpwd>>

then mysql ask you to give password this is the old password and now the new password for the root will be newankush.

Sep 10, 2008 | Sun MySQL

1 Answer

MySQL Database


THE SYSTEM REQUIRMENTS ARE
MySQL Tools
1. A SQL server : This is an engine which provides access to your databases.
2. Client programs for accessing the server : A program allows you to enter queries directly and view results
3. A client library for writing your own programs : You can write your own programs into the client library using C.
Recommended Hardware Requirements For Mysql Installation
  1. Pentium V processor
  2. 128 MB RAM
Note that MySQL can be installed on a platform with as little as 32 MB
RECOMENDED SOFTWARE TOOLS for better performance
IT is recommended to have at least 128MB memory.
You can freely download MySQL from the website http://www.mysql.com MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others

Sep 08, 2008 | Sun MySQL

1 Answer

Problem mysql


Hi,

I'm not a MySQL wiz, but i played around a bit, and found this.

This is SELinux blocking access to the socket. The easiest way to get around it is to:
1. run system-config-securitylevel (either from a bash prompt or the menus)
2. Select the SELinux Tab.
3. Click the Transition twistie.
4. Select Disable SELinux protection for httpd daemon
5. Click OK
6. Reboot your computer (I know, nobody likes to reboot, but when changing SELinux it seems to be a necessity.)
7. Profit!!!

Good luck, let me know how it went.

Aug 10, 2008 | Sun MySQL

1 Answer

MySQL data types


These are the types i know

1.VARCHARs with length less than 4 become CHARs
2.CHARs with length more than 3 become VARCHARs.
3.NOT NULL gets added to the columns declared as PRIMARY KEYs
4.Default values such as NULL are specified for each column

If there are more i'm sure folks around here will post them.

Aug 05, 2008 | Sun MySQL

2 Answers

Mysql Report Error


An example of getting feedback from MySQL about a PHP problem -

mysql_connect("my.site.com", "username", "password")
This can also be done with this code -
die(mysql_error())

Each of the above lines will return the errors, if you have problems connecting to your MySQL database.
There are many more ways, this is just a taste.

Jul 29, 2008 | Sun MySQL

4 Answers

MySQL Error Messeage


When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command -
./bin/mysqladmin -u <username> password

Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>

Jul 27, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

97 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18331 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Cosma Papouis
Cosma Papouis

Level 3 Expert

404 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...