Hi guys,
I would like to know whether is there an option to detect locked tables in mysql or no. I mean locked by LOCK TABLE table WRITE/READ command ?
cheers,
Marcin
Can somebody write me a code, how to view data from tables in c# (using select statement)?
I tried it myself and posted the code here, but i didn't get it right.
Please help!
I am working on a non Rails web app, so no migrations script by default.
The Sequel ORM lets me create tables easily in a script:
#!/usr/bin/env ruby
require 'rubygems'
require 'sequel'
## Connect to the database
DB = Sequel.sqlite('./ex1.db')
unless DB.table_exists? :posts
DB.create_table :posts do
primary_key :id
varchar :title
…
Hi,
I want to create a a full text search usng ms sql 2005.
here is the structure of my table
User-contains fields of Id, fname,lname,email,alternativeemail
Attachment-contains fields of id, name,category,filenameorurl
Certification-contains of fileds of id, title,school,sdate,edate
EducationalBackground-contain of fields of,…
I'm at the planning stages of a multi-user application where each user will only have access their own data. There'll be a few tables that relate to each other, so I could use JOINs to ensure they're accessing only their data, but should I include user_id in each table? Would this be faster? It would certainly make some of the…
Since chains of rainbow tables are very long, are there many different reduction functions used to reduce each hash, or are there only a handful, while using indexes to prevent merging? or something else?
Hi, I'm just starting to play around with GTK+ and I wanted to stop bad habits before they happen. I see that GTK+ seems to be a little based in HTML/CSS and I was wondering if there are any reasons to avoid using tables for layout.
Hi! What would be an appropriate way to do this, since mySQL obviously doesnt enjoy this.
To leave either partitioning or the foreign keys out from the database design would not seem like a good idea to me. I'll guess that there is a workaround for this?
Update 03/24:
…
Using PHP/PDO is it possible to use a wildcard for the columns when a select is done on multiple tables and the returned array keys are fully qualified to avoid column name clash?
example:
SELECT * from table1, table2;
gives:
Array keys are 'table1.id', 'table2.id',…
So, I have a control with a datagrid in it and I was wondering if depending on the value I get back from the a Request.QueryString if I could set the table name to that (that is the value being sent) and then have it build the columns?
I have about 3 different tables,…
I'm developing a website that publishes scientific articles, not as PDF but as HTML. As a input tool for the editorial team, we use TinyMCE for normal text plus a couple of custom plugins for footnotes and citations. But we are not really happy with TinyMCEs table…
Short of SQL-dumping my entire database to text and searching that, is there a way to search for a specific substring in all tables of a MySQL database if you are not sure which table/record/field that substring actually occurs?
Hi,
I want to create a a full text search usng ms sql 2005.
here is the structure of my table
User-contains fields of Id, fname,lname,email,alternativeemail
Attachment-contains fields of id, name,category,filenameorurl
Certification-contains of fileds of id,…
I have an ASP.NET 3.5 Project (not website) and I don't understand why all these modules are being created and loaded. I thought that with a web project it would all compile to a single .DLL
'WebDev.WebServer.EXE' (Managed): Loaded…
I am trying to import a csv file to insert data into an existing table on my database. I go through the wizard and when it comes to select source tables and views for the destination, there are none to choose from. It just thinks I…
Hello,
Are there any tools or tricks how to automatically extract tables from pdfs. Are there any C# libraries that could do that? Or do you maybe know other methods how this could be handled?
Thank you very much
Assume I have the following tables (**bold** - primary key, *italics* - foreign key):
patient(**patient_id**, name)
disease(**disease_id**, name)
patient_disease(**p_d_id**, *patient_id*, *disease,_id* )
I want to draw the ER…
I have two tables with the same structure:
id name
1 Merry
2 Mike
and
id name
1 Mike
2 Alis
I need to join second table to first with keeping unique names, so that result is:
id name
1 Merry
2 Mike
3 Alis
Is it possible…
Hi,
I am joining two tables 'sales/order_item_collection' and 'sales/orders' by 'order_id', so that afterward i can filter sold products by 'store_id' and 'product_name'
Here is the code:
$orderTable =…
Hi
I wanna delete records from child tables as well as parent table with in a single query. please find the query given below. here response header is the primary table and responseid is the primary key.
DELETE…
How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL…
for tables with 1,000,000 rows and possibly many many more !
haven't done any benchmarking myself so wanted to get the experts opinion.
Looked at some articles on row_number() but it seems to have…
I am having issues using NDbUnit with tables that have their own schema - ie:
CREATE TABLE MYSCHEMA.MyTable01
(
Id int NOT NULL,
Description varchar(50) NOT NULL
)
Is this a supported…
I am trying to enforce a CHECK Constraint in a ORACLE Database on multiple tables
CREATE TABLE RollingStocks (
Id NUMBER,
Name Varchar2(80) NOT NULL,
RollingStockCategoryId…