by: Mike |
last post by:
Hello,
I'm trying to understand how to map hierarchical XML data to relational
database tables, but I seem to be missing something. I'm not a database
expert, but I know the basics. XML seems...
|
by: joshsackett |
last post by:
Hi all,
I have 5 databases, each about 20GB in size. I need to copy the data to
a new server for reporting purposes. Initially I wanted to setup
transactional replication; however, the database...
|
by: Karam Chand |
last post by:
Hello
I have been working with Access and MySQL for pretty
long time. Very simple and able to perform their jobs.
I dont need to start a flame anymore :)
I have to work with PGSQL for my...
|
by: m.e.bruche |
last post by:
Hi,
In my database, I created a lot of tables before I found out about
schemas. It's a mess!
Suppose I want to get organised, and create a couple of schemas. How do
I move existing tables...
|
by: shsandeep |
last post by:
I currently have 500 tables in 1 single schema.
I would like to move 250 out of the 500 tables into a new schema.
How is this done?
Thanks.
|
by: fuzzybr80 |
last post by:
I am using MySQL 5.0 with a number of innodb tables whose ibdata files
are growing quite quickly and filling up the /var partition (file is
/var/mysql/ibdata1). Earlier on I followed instructions...
|
by: David++ |
last post by:
Dear List,
Is it possible to have a schema with tables of the same name? I need to
build an XML document based on the following schema -
<?xml version="1.0" encoding="utf-8"?>
<xs:schema...
|
by: Henrik |
last post by:
Hi,
I'm really stuck with this one. I have a dataset with two tables. One table
is company data, and the other is contacts. I populate these by using a SP in
SQL Server which returns the two...
|
by: Troels Arvin |
last post by:
Hello,
How does a use efficiently move a table between tablespaces, given that
the user doesn't have shell access to the server hosting the database?
Is there some built-in routine that the...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|