by: 'bonehead |
last post by:
Greetings,
I'd like to figure out some syntax for retrieving the data from a table
when I don't know all the of field names. What I do know are, the name
of the table, the names of the primary...
|
by: Craig Stadler |
last post by:
mySQL 4.0.20a WIN32
Need help with backslash syntax/like queries..
Query1:
select * from dbtable1 where Filespec like 'http://www.10291.com/%'
returns :...
|
by: janet |
last post by:
HI,
We had some data which had low cardinality (86) , the count for that
table is 9 million rows.
How to optimize query which involve joining this table on that column?
I'm not sure if...
|
by: Peter |
last post by:
I have a Query called "DATA" that contains 60 records with 6 fields of
data. I want to dump the query results into a specific xls file.
The first worksheet of this xls file has space for the...
|
by: Sreedhar Vankayala |
last post by:
Hi,
I have a table IV00108wc which contains several thousand records in whcih
ITEMNMBR is the primary key.
I have a com+ object returning recordset which has ITEMNMBR and another
details...
|
by: joshsackett |
last post by:
I am having a problem with indexes on specific tables. For some reason
a query that runs against a view is not selecting the correct index on
a table. I run the same query against the table...
|
by: Felix_WafyTech |
last post by:
Hi,
I'm working with the ObjectDatasource and the application is getting more
and more chatty. Is there a way I could make the ObjectDatasource support
multiple DataTables that could be...
|
by: Nikolay Petrov |
last post by:
I have three really small tables, which gave me a lot of headache.
They reside in a MS Access database and a I am accessing them through
ADO.NET(VB).
Can't figure out how to make a "Select" query...
|
by: craigfr |
last post by:
I am making a graph comparing last year's defect data with YTD defect data. Our fiscal year starts Nov.1 and ends Oct.31.
To get the YTD, I started used a simple date serial criteria:
Between...
|
by: JonTwend |
last post by:
I am working with the Twitter API and finding it great fun and generally easy to use.
But I am having trouble getting to the data in the trends/current.json file. I am able to loop through 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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: 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...
|