What do you want to save?
Add Code snippet
New code examples
-
PHP 2022-02-02 18:30:50
showing database table in php
$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password mysql_select_db('hrmwaitrose'); $query = "SELECT * FROM employee"; //You don't need a ; like you do in SQL $result = mysql_query($query); echo "<t... Add solution -
VBA 2022-01-26 03:32:10
Restoring database file from backup file vb.net
Disable the emails in tblUsers by changing @ to # update tblUsers set Email = replace(Email, '%@%', '%#%') where Email like '%@%' update tblusers set email = replace(email,'@','#') Connection error: USE MASTER GO SELECT name as SQLServerLogIn,SID as... Add solution -
C# 2021-11-08 16:08:17
C# datareadeer return null
// ****** Use MySqlDataReader instead of SqlReader if you are using MySQL ******* //You need to check for IsDBNull: //That's your only reliable way to detect and handle this situation. //I wrapped those things into extension methods and tend to return a ... Add solution -
Other 2021-10-29 20:41:14
medium generate-tsql-stored-procedures
CREATE proc [dbo].[USP_QuerycreationSupport](@table_Name varchar(100))asbeginDECLARE @InserCols NVARCHAR(MAX)DECLARE @Inserparam NVARCHAR(MAX)DECLARE @Insertquery NVARCHAR(MAX)DECLARE @Selectquery NVARCHAR(MAX)DECLARE @Update NVARCHAR(MAX)DECLARE @DeleteQ... Add solution -
Java 2021-10-29 03:26:06
java sql connection example
import java.sql.*; class MySQLConnection{ public static final String DBNAME = "name_of_the_database"; // Like "testDB" /** JDBC driver name and database URL */ public static final String JDBC_DRIVER = "com.mysql.jdbc.Driver&qu... Add solution -
Other 2021-10-27 08:56:04
Access denied for user @'localhost' (using password: YES)
sudo /etc/init.d/mysql stop Now start up MySQL in safe mode, so you’ll skip the privileges table: sudo mysqld_safe --skip-grant-tables & // if you face issue,[mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists] run b... Add solution -
Other 2021-10-10 00:03:09
data engineer
• 7+ years Industry experience as a Data Engineer with solid understanding of Data Modeling, Data migration, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications. • Expert... Add solution
Best helpers
Ranking is empty