use
mysqldump --databases your_database_n ame > new_database_na me.txt
run this on mysql.
Hope this will help u.
tomarvijay80
Last Activity: Oct 10 '08, 07:58 AM
Joined: Nov 24 '06
Location: Delhi
-
u can use source workready.txt /*(if your file is in the same directory otherwise give path before workready.txt)*/
It will drop database and create a new one, if u don't want to drop and create a database simply open ur .txt file and remove drop and create database statement.Leave a comment:
-
this will replace first 0 from the value with 44 and concatenate the rest with 44.Code:UPDATE mytable SET column_name = concat('44', right(column_name,length(column_name)-1));
Hope this will help u.
Thanks
VijayLeave a comment:
-
Ya, u can use trigers for updating columns or the other way is to concatenate columns while fetching records.Leave a comment:
-
Hi kardiffBlue,
Hope this code will help u. In this I am using access database. u can change database and table as per ur requirement.
Dim cn As New ADODB.Connectio n
Dim rs As New ADODB.Recordset
Dim sql As String
Private Sub cmdFind_Click()
cn.ConnectionSt ring = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=D:\Visua l Basic\text\comp any.mdb;Persist Security Info=False"...Leave a comment:
-
Dim xlapp As Excel.Applicati on
Dim xlbook As Excel.WorkBook
Dim xlsheet As Excel.WorkSheet
Set xlbook = GetObject("d:\v isual basic\TEST.xls" )
Set xlapp = xlbook.Parent
xlapp.Visible = True
xlapp.Windows(" TEST.XLS").Visi ble = True
Set xlsheet = xlbook.Sheets(" Sheet1")
xlsheet.Cells(1 , 1) = "TEXT"
...Leave a comment:
-
tomarvijay80 replied to concatenating two fields and storing the value in a single field using mysqlin MySQLSolution::
select concat(A,' ',B) as A from XYZ ;
If you want to see separate values in column A then
select concat(A,' , ',B) as A from XYZ ;
Hope this solve ur problem....Leave a comment:
-
Hi,
The solution I knows it
if U have a column sal in a table emp want to find out the second highest value the solution is
select sal from emp a where 2=(select count(distinct( sal)) from emp b where a.sal<=b.sal);
May be it helpfull to you....Leave a comment:
-
You can download of SQL Server from www.microsoft.c om or search for the book in google as SQL server book 2000. SQL server is very user friendly. If u have an experience on working with access u can easily learn SQL Server.Leave a comment:
-
U can select unique value from any column by using this query.
Select distinct(column _name) from table_name;Leave a comment:
No activity results to display
Leave a comment: