Database

Database

After creating a table in SQL, I wish to change the size allotted to a particular column (say, I want to change the size of the salary column from 3 to 4).

But I could find no option in the SQL developer version, is there any command to modify this?

  • 3104 views
  • 1 answers
  • 0 votes

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;

  • 973 views
  • 3 answers
  • 0 votes

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

  • 989 views
  • 2 answers
  • 1 votes

Can we download a excel file by using oracle database. Also, Can we upload it the same?

I don't know much about the database.

Please help in this regard.

  • 905 views
  • 1 answers
  • 0 votes

Hello,

I am looking to authenticate users on my website based on data that's in an Oracle database. But I am having difficulties finding accurate data on the web. Can some one guide me? I need the query of Oracle database that run in PHP.

Thanks in advance.

  • 1244 views
  • 1 answers
  • 0 votes

Hello,

I have created the following:

1 Form created in VB2008

3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record]

2 Database created in MS Access 2003

File Name: Information.mbd

Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number]

How to create connection? How to get data on form load from database in Textboxes? How to insert, update, delete data? Please provide information as I am not able to get any simplest way to understand these questions.

Thanks in advance

 

  • 1152 views
  • 1 answers
  • 0 votes

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

  • 923 views
  • 1 answers
  • 0 votes

How can I create a Crystal Report and use Visual Studio 2008 and MS Access 2010 as the base table?

 

 

 

  • 1683 views
  • 1 answers
  • 0 votes

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?

 

  • 832 views
  • 1 answers
  • 0 votes

The error message below always shows up every time I try to go to Business Intelligence > core application in the Oracle Enterprise Manager Fusion Middleware Control:

“Stream Close” “For more information, please see the server’s error log for an entry beginning with: Server Exception during PPR, #7”

Business Intelligence -> core application>Oracle Enterprise Manager Fusion Middleware Control>stream closed

  • 979 views
  • 2 answers
  • 0 votes

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...